APPS.ENG_REVISED_ITEM_UTIL dependencies on MTL_SYSTEM_ITEMS

Line 1576: FROM mtl_system_items

1572: l_current_item_revision_id NUMBER;
1573: --added for 3972225
1574: CURSOR c_revised_phase_id (cp_revised_item_id NUMBER,cp_organization_id NUMBER) IS
1575: SELECT current_phase_id
1576: FROM mtl_system_items
1577: WHERE inventory_item_id = cp_revised_item_id
1578: and organization_id = cp_organization_id ;
1579:
1580: l_current_lifecycle_phase_id NUMBER;