eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_IMPORT_VALIDATE dependencies on QP_LIST_HEADERS_B

Line 916: ,QP_LIST_HEADERS_B QPI

912: WHERE SP.RESOURCE_ID = SPTL.RESOURCE_ID
913: AND SPTL.LANGUAGE = USERENV('LANG')) SPN
914: ,OE_AGREEMENTS_B AGI
915: ,OE_AGREEMENTS_TL AGTLN
916: ,QP_LIST_HEADERS_B QPI
917: ,(SELECT QP.ROWID ROW_ID, QPTL.NAME, QP.CURRENCY_CODE, QP.LIST_HEADER_ID
918: FROM QP_LIST_HEADERS_B QP, QP_LIST_HEADERS_TL QPTL
919: WHERE QP.LIST_HEADER_ID = QPTL.LIST_HEADER_ID
920: AND QPTL.LANGUAGE = USERENV('LANG')) QPTLN

Line 918: FROM QP_LIST_HEADERS_B QP, QP_LIST_HEADERS_TL QPTL

914: ,OE_AGREEMENTS_B AGI
915: ,OE_AGREEMENTS_TL AGTLN
916: ,QP_LIST_HEADERS_B QPI
917: ,(SELECT QP.ROWID ROW_ID, QPTL.NAME, QP.CURRENCY_CODE, QP.LIST_HEADER_ID
918: FROM QP_LIST_HEADERS_B QP, QP_LIST_HEADERS_TL QPTL
919: WHERE QP.LIST_HEADER_ID = QPTL.LIST_HEADER_ID
920: AND QPTL.LANGUAGE = USERENV('LANG')) QPTLN
921: ,QP_LIST_HEADERS_B RNPLI
922: ,(SELECT QP.ROWID ROW_ID, QPTL.NAME, QP.CURRENCY_CODE, QP.LIST_HEADER_ID

Line 921: ,QP_LIST_HEADERS_B RNPLI

917: ,(SELECT QP.ROWID ROW_ID, QPTL.NAME, QP.CURRENCY_CODE, QP.LIST_HEADER_ID
918: FROM QP_LIST_HEADERS_B QP, QP_LIST_HEADERS_TL QPTL
919: WHERE QP.LIST_HEADER_ID = QPTL.LIST_HEADER_ID
920: AND QPTL.LANGUAGE = USERENV('LANG')) QPTLN
921: ,QP_LIST_HEADERS_B RNPLI
922: ,(SELECT QP.ROWID ROW_ID, QPTL.NAME, QP.CURRENCY_CODE, QP.LIST_HEADER_ID
923: FROM QP_LIST_HEADERS_B QP, QP_LIST_HEADERS_TL QPTL
924: WHERE QP.LIST_HEADER_ID = QPTL.LIST_HEADER_ID
925: AND QPTL.LANGUAGE = USERENV('LANG')) RNPLN

Line 923: FROM QP_LIST_HEADERS_B QP, QP_LIST_HEADERS_TL QPTL

919: WHERE QP.LIST_HEADER_ID = QPTL.LIST_HEADER_ID
920: AND QPTL.LANGUAGE = USERENV('LANG')) QPTLN
921: ,QP_LIST_HEADERS_B RNPLI
922: ,(SELECT QP.ROWID ROW_ID, QPTL.NAME, QP.CURRENCY_CODE, QP.LIST_HEADER_ID
923: FROM QP_LIST_HEADERS_B QP, QP_LIST_HEADERS_TL QPTL
924: WHERE QP.LIST_HEADER_ID = QPTL.LIST_HEADER_ID
925: AND QPTL.LANGUAGE = USERENV('LANG')) RNPLN
926: ,RA_RULES ARI
927: ,RA_RULES ARN

Line 2807: ,QP_LIST_HEADERS_B QPI

2803: ,COUNT(DISTINCT SCN.ROW_ID) OVER (PARTITION BY LNI.ROWID) SCN_COUNT
2804: ,MAX(SCN.CONTACT_ID) OVER (PARTITION BY LNI.ROWID) SCN_ID -- Shipping contact id based on Name */
2805: FROM OKS_LINES_INTERFACE LNI
2806: ,OKS_INT_HEADER_STG_TEMP HST
2807: ,QP_LIST_HEADERS_B QPI
2808: ,(SELECT QP.ROWID ROW_ID, QPTL.NAME, QP.CURRENCY_CODE, QP.LIST_HEADER_ID
2809: FROM QP_LIST_HEADERS_B QP, QP_LIST_HEADERS_TL QPTL
2810: WHERE QP.LIST_HEADER_ID = QPTL.LIST_HEADER_ID
2811: AND QPTL.LANGUAGE = USERENV('LANG')) QPTLN

Line 2809: FROM QP_LIST_HEADERS_B QP, QP_LIST_HEADERS_TL QPTL

2805: FROM OKS_LINES_INTERFACE LNI
2806: ,OKS_INT_HEADER_STG_TEMP HST
2807: ,QP_LIST_HEADERS_B QPI
2808: ,(SELECT QP.ROWID ROW_ID, QPTL.NAME, QP.CURRENCY_CODE, QP.LIST_HEADER_ID
2809: FROM QP_LIST_HEADERS_B QP, QP_LIST_HEADERS_TL QPTL
2810: WHERE QP.LIST_HEADER_ID = QPTL.LIST_HEADER_ID
2811: AND QPTL.LANGUAGE = USERENV('LANG')) QPTLN
2812: ,RA_RULES ARI
2813: ,RA_RULES ARN