DBA Data[Home] [Help]

APPS.ENG_REVISED_ITEMS_PKG dependencies on MTL_SYSTEM_ITEMS_VL

Line 707: FROM eng_revised_items eri , mtl_system_items_vl msiv

703: AND organization_id = p_organization_id;
704:
705: CURSOR c_query_revised_item IS
706: SELECT eri.revised_item_sequence_id
707: FROM eng_revised_items eri , mtl_system_items_vl msiv
708: WHERE eri.change_id = p_change_id
709: AND eri.organization_id = p_organization_id
710: AND eri.revised_item_id = p_revised_item_id
711: AND eri.revised_item_id = msiv.inventory_item_id

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

961: -- 2: revised item status check
962: -- 3: common bom for src pending changes
963: CURSOR c_chk_rev_comp_editable IS
964: SELECT eri.revised_item_sequence_id
965: FROM eng_revised_items eri , mtl_system_items_vl msiv , bom_components_b bcb
966: WHERE eri.revised_item_sequence_id = bcb.revised_item_sequence_id
967: and bcb.component_sequence_id = p_component_sequence_id
968: AND eri.revised_item_id = msiv.inventory_item_id
969: AND eri.organization_id = msiv.organization_id