APPS.ENG_REVISED_ITEMS_PKG dependencies on MTL_SYSTEM_ITEMS

Line 202: from mtl_system_items

198: END IF;
199:
200: select effectivity_control
201: INTO l_effectivity_control
202: from mtl_system_items
203: where inventory_item_id = x_assembly_item_id
204: and organization_id = x_organization_id;
205:
206: insert into BOM_BILL_OF_MATERIALS (

Line 730: FROM eng_revised_items eri , mtl_system_items_vl msiv

726: AND organization_id = p_organization_id;
727:
728: CURSOR c_query_revised_item IS
729: SELECT eri.revised_item_sequence_id
730: FROM eng_revised_items eri , mtl_system_items_vl msiv
731: WHERE eri.change_id = p_change_id
732: AND eri.organization_id = p_organization_id
733: AND eri.revised_item_id = p_revised_item_id
734: AND eri.revised_item_id = msiv.inventory_item_id

Line 988: FROM eng_revised_items eri , mtl_system_items_vl msiv , bom_components_b bcb

984: -- 2: revised item status check
985: -- 3: common bom for src pending changes
986: CURSOR c_chk_rev_comp_editable IS
987: SELECT eri.revised_item_sequence_id
988: FROM eng_revised_items eri , mtl_system_items_vl msiv , bom_components_b bcb
989: WHERE eri.revised_item_sequence_id = bcb.revised_item_sequence_id
990: and bcb.component_sequence_id = p_component_sequence_id
991: AND eri.revised_item_id = msiv.inventory_item_id
992: AND eri.organization_id = msiv.organization_id