We are trying to find in the peoplecode for the SQL found in our trace.
it sounds obvious but these SQLs seems to be dynamic or generated by system somehow and not found in peoplecode
In our trace we have this:
<<< end Nest=05 PO_LN_SHIP_SUT.BUSINESS_UNIT.RowInit Dur=0.062003 CPU=0.031200 Cycles=77
Cur#1.3748.PROD RC=0 Dur=0.000000 COM Stmt=SELECT BUSINESS_UNIT, PO_ID, LINE_NBR, SCHED_NBR, SEQNBR, SUT_PRODUCT
Cur#1.3748.PROD RC=0 Dur=0.000000 COM Stmt=SELECT SETID, CNTRCT_ID, CNTRCT_LINE_NBR, CATEGORY_ID, ITM_ID_VNDR, V
Cur#1.3748.PROD RC=0 Dur=0.000000 COM Stmt=SELECT 'Y' from PS_RECV_LN_DISTRIB where RECV_DS_STATUS <> 'X' and B
Cur#1.3748.PROD RC=0 Dur=0.000000 COM Stmt=SELECT 'Y' from PS_VOUCHER_LINE where BUSINESS_UNIT_PO = :1 and PO_I
Cur#1.3748.PROD RC=0 Dur=0.001000 COM Stmt=SELECT BUSINESS_UNIT, PO_ID, LINE_NBR, SCHED_NBR, EXS_TAX_TYPE, EXS_T
Cur#1.3748.PROD RC=0 Dur=0.001000 COM Stmt=SELECT BUSINESS_UNIT, PO_ID, LINE_NBR, SCHED_NBR, DST_ACCT_TYPE, DIST
Cur#1.3748.PROD RC=0 Dur=0.000000 COM Stmt=SELECT BUSINESS_UNIT FROM PS_BUS_UNIT_INTFC WHERE BUSINESS_UNIT=:1 OR
Cur#1.3748.PROD RC=0 Dur=0.000000 COM Stmt=SELECT BUSINESS_UNIT, REQ_ID, REQUESTOR_ID FROM PS_PO_REQ_HDR_VW WHER
Cur#1.3748.PROD RC=0 Dur=0.000000 COM Stmt=SELECT OPRID, OPRDEFNDESC FROM PS_PO_OPRDEFN_VW WHERE OPRID=:1 ORDER
Cur#1.3748.PROD RC=0 Dur=0.000000 COM Stmt=SELECT REQUESTOR_ID, LOCATION_SETID, LOCATION, DEPTID_SETID, CATALOG_
>>> start Nest=05 PO_PNLS_WRK.DESCR.RowInit
For this trace, can Any body give hints on how to find the SQL "SELECT 'Y' from PS_VOUCHER_LINE"
As we don't see them in Peoplecode