APPS.OKS_IMPORT_VALIDATE dependencies on MTL_SYSTEM_ITEMS

Line 2768: ,MTL_SYSTEM_ITEMS_B MSI

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

Line 2769: ,MTL_SYSTEM_ITEMS_B_KFV MSN

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

Line 3849: ,MTL_SYSTEM_ITEMS CMSII

3845: ,COUNT(DISTINCT CMSIN.ROWID) OVER (PARTITION BY CLI.ROWID) CMSIN_COUNT
3846: ,MAX(CMSIN.INVENTORY_ITEM_ID) OVER (PARTITION BY CLI.ROWID) CMSIN_ID --COVERED ITEM ID Based on Name
3847:
3848: FROM OKS_COVERED_LEVELS_INTERFACE CLI
3849: ,MTL_SYSTEM_ITEMS CMSII
3850: ,MTL_SYSTEM_ITEMS CMSIN
3851: WHERE CLI.COVERED_INSTANCE_ID = CMSII.INVENTORY_ITEM_ID (+)
3852: AND CLI.COVERED_ITEM_ORG_ID = CMSII.ORGANIZATION_ID(+)
3853:

Line 3850: ,MTL_SYSTEM_ITEMS CMSIN

3846: ,MAX(CMSIN.INVENTORY_ITEM_ID) OVER (PARTITION BY CLI.ROWID) CMSIN_ID --COVERED ITEM ID Based on Name
3847:
3848: FROM OKS_COVERED_LEVELS_INTERFACE CLI
3849: ,MTL_SYSTEM_ITEMS CMSII
3850: ,MTL_SYSTEM_ITEMS CMSIN
3851: WHERE CLI.COVERED_INSTANCE_ID = CMSII.INVENTORY_ITEM_ID (+)
3852: AND CLI.COVERED_ITEM_ORG_ID = CMSII.ORGANIZATION_ID(+)
3853:
3854: AND CLI.COVERED_ITEM_NAME = CMSIN.SEGMENT1 (+)