DBA Data[Home] [Help]

APPS.OKS_IMPORT_VALIDATE dependencies on RA_RULES

Line 896: ,RA_RULES ARI

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
898: ,RA_RULES IRI
899: ,RA_RULES IRN
900: ,RA_TERMS_B PTI

Line 897: ,RA_RULES ARN

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
898: ,RA_RULES IRI
899: ,RA_RULES IRN
900: ,RA_TERMS_B PTI
901: ,RA_TERMS_TL PTTLN

Line 898: ,RA_RULES IRI

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
898: ,RA_RULES IRI
899: ,RA_RULES IRN
900: ,RA_TERMS_B PTI
901: ,RA_TERMS_TL PTTLN
902: ,OKC_K_GROUPS_B CGI

Line 899: ,RA_RULES IRN

895: AND QPTL.LANGUAGE = USERENV('LANG')) RNPLN
896: ,RA_RULES ARI
897: ,RA_RULES ARN
898: ,RA_RULES IRI
899: ,RA_RULES IRN
900: ,RA_TERMS_B PTI
901: ,RA_TERMS_TL PTTLN
902: ,OKC_K_GROUPS_B CGI
903: ,OKC_K_GROUPS_TL CGTLN

Line 2764: ,RA_RULES ARI

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
2766: ,RA_RULES IRI
2767: ,RA_RULES IRN
2768: ,MTL_SYSTEM_ITEMS_B MSI

Line 2765: ,RA_RULES ARN

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
2766: ,RA_RULES IRI
2767: ,RA_RULES IRN
2768: ,MTL_SYSTEM_ITEMS_B MSI
2769: ,MTL_SYSTEM_ITEMS_B_KFV MSN

Line 2766: ,RA_RULES IRI

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
2766: ,RA_RULES IRI
2767: ,RA_RULES IRN
2768: ,MTL_SYSTEM_ITEMS_B MSI
2769: ,MTL_SYSTEM_ITEMS_B_KFV MSN
2770: ,(SELECT CAR.ROWID ROW_ID, CAR.CUST_ACCOUNT_ROLE_ID CONTACT_ID, P.PARTY_NAME CONTACT_NAME, R.OBJECT_ID PARTY_ID

Line 2767: ,RA_RULES IRN

2763: AND QPTL.LANGUAGE = USERENV('LANG')) QPTLN
2764: ,RA_RULES ARI
2765: ,RA_RULES ARN
2766: ,RA_RULES IRI
2767: ,RA_RULES IRN
2768: ,MTL_SYSTEM_ITEMS_B MSI
2769: ,MTL_SYSTEM_ITEMS_B_KFV MSN
2770: ,(SELECT CAR.ROWID ROW_ID, CAR.CUST_ACCOUNT_ROLE_ID CONTACT_ID, P.PARTY_NAME CONTACT_NAME, R.OBJECT_ID PARTY_ID
2771: FROM HZ_CUST_ACCOUNT_ROLES CAR,HZ_PARTIES P, HZ_RELATIONSHIPS R , HZ_ORG_CONTACTS OC