APPS.OKS_IMPORT_VALIDATE dependencies on MTL_SYSTEM_ITEMS

Line 2816: ,MTL_SYSTEM_ITEMS_B MSI

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
2820: WHERE CAR.ROLE_TYPE = 'CONTACT'

Line 2817: ,MTL_SYSTEM_ITEMS_B_KFV MSN

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
2820: WHERE CAR.ROLE_TYPE = 'CONTACT'
2821: AND R.PARTY_ID = CAR.PARTY_ID

Line 3901: ,MTL_SYSTEM_ITEMS CMSII

3897: ,COUNT(DISTINCT CMSIN.ROWID) OVER (PARTITION BY CLI.ROWID) CMSIN_COUNT
3898: ,MAX(CMSIN.INVENTORY_ITEM_ID) OVER (PARTITION BY CLI.ROWID) CMSIN_ID --COVERED ITEM ID Based on Name
3899:
3900: FROM OKS_COVERED_LEVELS_INTERFACE CLI
3901: ,MTL_SYSTEM_ITEMS CMSII
3902: ,MTL_SYSTEM_ITEMS CMSIN
3903: WHERE CLI.COVERED_ITEM_ID = CMSII.INVENTORY_ITEM_ID (+) ----Modified for bug 13518018
3904: AND CLI.COVERED_ITEM_ORG_ID = CMSII.ORGANIZATION_ID(+)
3905:

Line 3902: ,MTL_SYSTEM_ITEMS CMSIN

3898: ,MAX(CMSIN.INVENTORY_ITEM_ID) OVER (PARTITION BY CLI.ROWID) CMSIN_ID --COVERED ITEM ID Based on Name
3899:
3900: FROM OKS_COVERED_LEVELS_INTERFACE CLI
3901: ,MTL_SYSTEM_ITEMS CMSII
3902: ,MTL_SYSTEM_ITEMS CMSIN
3903: WHERE CLI.COVERED_ITEM_ID = CMSII.INVENTORY_ITEM_ID (+) ----Modified for bug 13518018
3904: AND CLI.COVERED_ITEM_ORG_ID = CMSII.ORGANIZATION_ID(+)
3905:
3906: AND CLI.COVERED_ITEM_NAME = CMSIN.SEGMENT1 (+)