APPS.EGO_EBI_ITEM_LOAD dependencies on MTL_SYSTEM_ITEMS_B

Line 52: FROM MTL_SYSTEM_ITEMS_B

48: -- Initialize Event Id to 0
49: l_eventId := 0;
50: INSERT INTO EGO_EBI_ITEM_LOAD_LOG (INVENTORY_ITEM_ID,ORGANIZATION_ID, EVENT_ID)
51: SELECT INVENTORY_ITEM_ID, ORGANIZATION_ID, NULL
52: FROM MTL_SYSTEM_ITEMS_B
53: WHERE ORGANIZATION_ID = p_organization_id
54: AND bom_item_type in (1, 2, 4)
55: AND customer_order_flag = 'Y'
56: AND customer_order_enabled_flag = 'Y';

Line 124: FROM MTL_SYSTEM_ITEMS_B

120: WHERE ORGANIZATION_ID = p_organization_id AND
121: EVENT_ID = p_event_id AND
122: INVENTORY_ITEM_ID NOT IN(
123: SELECT INVENTORY_ITEM_ID
124: FROM MTL_SYSTEM_ITEMS_B
125: WHERE ORGANIZATION_ID = p_organization_id
126: AND bom_item_type in (1, 2, 4)
127: AND customer_order_flag = 'Y'
128: AND customer_order_enabled_flag = 'Y');