APPS.ENG_DEFAULT_REVISED_ITEM dependencies on MRP_SYSTEM_ITEMS

Line 1235: FROM mrp_system_items si,

1231: l_assembly_item_id NUMBER := NULL;
1232: l_inventory_use_up_date DATE := NULL;
1233: CURSOR SCHED_DATE IS
1234: SELECT si.inventory_use_up_date, bl.assembly_item_id
1235: FROM mrp_system_items si,
1236: bom_lists bl
1237: WHERE bl.sequence_id = l_sequence_id
1238: AND ( bl.assembly_item_id = p_revised_item_id
1239: OR bl.assembly_item_id IN