DBA Data[Home] [Help]

APPS.OKS_IMPORT_VALIDATE dependencies on RA_RULES

Line 926: ,RA_RULES ARI

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
928: ,RA_RULES IRI
929: ,RA_RULES IRN
930: ,RA_TERMS_B PTI

Line 927: ,RA_RULES ARN

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
928: ,RA_RULES IRI
929: ,RA_RULES IRN
930: ,RA_TERMS_B PTI
931: ,RA_TERMS_TL PTTLN

Line 928: ,RA_RULES IRI

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
928: ,RA_RULES IRI
929: ,RA_RULES IRN
930: ,RA_TERMS_B PTI
931: ,RA_TERMS_TL PTTLN
932: ,OKC_K_GROUPS_B CGI

Line 929: ,RA_RULES IRN

925: AND QPTL.LANGUAGE = USERENV('LANG')) RNPLN
926: ,RA_RULES ARI
927: ,RA_RULES ARN
928: ,RA_RULES IRI
929: ,RA_RULES IRN
930: ,RA_TERMS_B PTI
931: ,RA_TERMS_TL PTTLN
932: ,OKC_K_GROUPS_B CGI
933: ,OKC_K_GROUPS_TL CGTLN

Line 2812: ,RA_RULES ARI

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
2814: ,RA_RULES IRI
2815: ,RA_RULES IRN
2816: ,MTL_SYSTEM_ITEMS_B MSI

Line 2813: ,RA_RULES ARN

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
2814: ,RA_RULES IRI
2815: ,RA_RULES IRN
2816: ,MTL_SYSTEM_ITEMS_B MSI
2817: ,MTL_SYSTEM_ITEMS_B_KFV MSN

Line 2814: ,RA_RULES IRI

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
2814: ,RA_RULES IRI
2815: ,RA_RULES IRN
2816: ,MTL_SYSTEM_ITEMS_B MSI
2817: ,MTL_SYSTEM_ITEMS_B_KFV MSN
2818: ,(SELECT CAR.ROWID ROW_ID, CAR.CUST_ACCOUNT_ROLE_ID CONTACT_ID, P.PARTY_NAME CONTACT_NAME, R.OBJECT_ID PARTY_ID

Line 2815: ,RA_RULES IRN

2811: AND QPTL.LANGUAGE = USERENV('LANG')) QPTLN
2812: ,RA_RULES ARI
2813: ,RA_RULES ARN
2814: ,RA_RULES IRI
2815: ,RA_RULES IRN
2816: ,MTL_SYSTEM_ITEMS_B MSI
2817: ,MTL_SYSTEM_ITEMS_B_KFV MSN
2818: ,(SELECT CAR.ROWID ROW_ID, CAR.CUST_ACCOUNT_ROLE_ID CONTACT_ID, P.PARTY_NAME CONTACT_NAME, R.OBJECT_ID PARTY_ID
2819: FROM HZ_CUST_ACCOUNT_ROLES CAR,HZ_PARTIES P, HZ_RELATIONSHIPS R , HZ_ORG_CONTACTS OC