DBA Data[Home] [Help]

APPS.OKS_IMPORT_VALIDATE dependencies on QP_LIST_HEADERS_B

Line 886: ,QP_LIST_HEADERS_B QPI

882: WHERE SP.RESOURCE_ID = SPTL.RESOURCE_ID
883: AND SPTL.LANGUAGE = USERENV('LANG')) SPN
884: ,OE_AGREEMENTS_B AGI
885: ,OE_AGREEMENTS_TL AGTLN
886: ,QP_LIST_HEADERS_B QPI
887: ,(SELECT QP.ROWID ROW_ID, QPTL.NAME, QP.CURRENCY_CODE, QP.LIST_HEADER_ID
888: FROM QP_LIST_HEADERS_B QP, QP_LIST_HEADERS_TL QPTL
889: WHERE QP.LIST_HEADER_ID = QPTL.LIST_HEADER_ID
890: AND QPTL.LANGUAGE = USERENV('LANG')) QPTLN

Line 888: FROM QP_LIST_HEADERS_B QP, QP_LIST_HEADERS_TL QPTL

884: ,OE_AGREEMENTS_B AGI
885: ,OE_AGREEMENTS_TL AGTLN
886: ,QP_LIST_HEADERS_B QPI
887: ,(SELECT QP.ROWID ROW_ID, QPTL.NAME, QP.CURRENCY_CODE, QP.LIST_HEADER_ID
888: FROM QP_LIST_HEADERS_B QP, QP_LIST_HEADERS_TL QPTL
889: WHERE QP.LIST_HEADER_ID = QPTL.LIST_HEADER_ID
890: AND QPTL.LANGUAGE = USERENV('LANG')) QPTLN
891: ,QP_LIST_HEADERS_B RNPLI
892: ,(SELECT QP.ROWID ROW_ID, QPTL.NAME, QP.CURRENCY_CODE, QP.LIST_HEADER_ID

Line 891: ,QP_LIST_HEADERS_B RNPLI

887: ,(SELECT QP.ROWID ROW_ID, QPTL.NAME, QP.CURRENCY_CODE, QP.LIST_HEADER_ID
888: FROM QP_LIST_HEADERS_B QP, QP_LIST_HEADERS_TL QPTL
889: WHERE QP.LIST_HEADER_ID = QPTL.LIST_HEADER_ID
890: AND QPTL.LANGUAGE = USERENV('LANG')) QPTLN
891: ,QP_LIST_HEADERS_B RNPLI
892: ,(SELECT QP.ROWID ROW_ID, QPTL.NAME, QP.CURRENCY_CODE, QP.LIST_HEADER_ID
893: FROM QP_LIST_HEADERS_B QP, QP_LIST_HEADERS_TL QPTL
894: WHERE QP.LIST_HEADER_ID = QPTL.LIST_HEADER_ID
895: AND QPTL.LANGUAGE = USERENV('LANG')) RNPLN

Line 893: FROM QP_LIST_HEADERS_B QP, QP_LIST_HEADERS_TL QPTL

889: WHERE QP.LIST_HEADER_ID = QPTL.LIST_HEADER_ID
890: AND QPTL.LANGUAGE = USERENV('LANG')) QPTLN
891: ,QP_LIST_HEADERS_B RNPLI
892: ,(SELECT QP.ROWID ROW_ID, QPTL.NAME, QP.CURRENCY_CODE, QP.LIST_HEADER_ID
893: FROM QP_LIST_HEADERS_B QP, QP_LIST_HEADERS_TL QPTL
894: WHERE QP.LIST_HEADER_ID = QPTL.LIST_HEADER_ID
895: AND QPTL.LANGUAGE = USERENV('LANG')) RNPLN
896: ,RA_RULES ARI
897: ,RA_RULES ARN

Line 2759: ,QP_LIST_HEADERS_B QPI

2755: ,COUNT(DISTINCT SCN.ROW_ID) OVER (PARTITION BY LNI.ROWID) SCN_COUNT
2756: ,MAX(SCN.CONTACT_ID) OVER (PARTITION BY LNI.ROWID) SCN_ID -- Shipping contact id based on Name */
2757: FROM OKS_LINES_INTERFACE LNI
2758: ,OKS_INT_HEADER_STG_TEMP HST
2759: ,QP_LIST_HEADERS_B QPI
2760: ,(SELECT QP.ROWID ROW_ID, QPTL.NAME, QP.CURRENCY_CODE, QP.LIST_HEADER_ID
2761: FROM QP_LIST_HEADERS_B QP, QP_LIST_HEADERS_TL QPTL
2762: WHERE QP.LIST_HEADER_ID = QPTL.LIST_HEADER_ID
2763: AND QPTL.LANGUAGE = USERENV('LANG')) QPTLN

Line 2761: FROM QP_LIST_HEADERS_B QP, QP_LIST_HEADERS_TL QPTL

2757: FROM OKS_LINES_INTERFACE LNI
2758: ,OKS_INT_HEADER_STG_TEMP HST
2759: ,QP_LIST_HEADERS_B QPI
2760: ,(SELECT QP.ROWID ROW_ID, QPTL.NAME, QP.CURRENCY_CODE, QP.LIST_HEADER_ID
2761: FROM QP_LIST_HEADERS_B QP, QP_LIST_HEADERS_TL QPTL
2762: WHERE QP.LIST_HEADER_ID = QPTL.LIST_HEADER_ID
2763: AND QPTL.LANGUAGE = USERENV('LANG')) QPTLN
2764: ,RA_RULES ARI
2765: ,RA_RULES ARN