APPS.EGO_GTIN_PVT dependencies on MTL_CUSTOMER_ITEMS

Line 63: FROM MTL_CUSTOMER_ITEMS MCI,

59: FROM DUAL
60: WHERE EXISTS
61: (
62: SELECT 1
63: FROM MTL_CUSTOMER_ITEMS MCI,
64: MTL_CUSTOMER_ITEM_XREFS MCIX,
65: MTL_CROSS_REFERENCES MCR,
66: MTL_SYSTEM_ITEMS_B MSI,
67: MTL_PARAMETERS MP

Line 1401: FROM MTL_CUSTOMER_ITEMS MCI, MTL_CUSTOMER_ITEM_XREFS MCIX, HZ_CUST_ACCT_SITES_ALL ACCT_SITE

1397: 'Order_Quantity_Min', 'Order_Quantity_Max', 'Shippable_Item_Flag',
1398: 'Invoiceable_Item_Flag');
1399: CURSOR c_customers(c_gtin IN VARCHAR2) IS
1400: SELECT ACCT_SITE.PARTY_SITE_ID AS PARTY_SITE_ID
1401: FROM MTL_CUSTOMER_ITEMS MCI, MTL_CUSTOMER_ITEM_XREFS MCIX, HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1402: WHERE MCI.ITEM_DEFINITION_LEVEL = 3
1403: AND MCI.CUSTOMER_CATEGORY_CODE= 'UCCNET'
1404: AND MCI.CUSTOMER_ITEM_ID = MCIX.CUSTOMER_ITEM_ID
1405: AND MCIX.PREFERENCE_NUMBER = 1