APPS.ENGECOBO dependencies on MRP_BOM_PLAN_NAME_LOV_V

Line 4743: l_use_up_plan_name mrp_bom_plan_name_lov_v.plan_name%TYPE;

4739: --l_propagated_rev_items_tbl Prop_Rev_Items_Tbl_Type;
4740: --l_prop_rev_items_count NUMBER;
4741: l_propagate_revised_item NUMBER;
4742: l_parent_revised_item_name mtl_system_items_vl.concatenated_segments%TYPE;
4743: l_use_up_plan_name mrp_bom_plan_name_lov_v.plan_name%TYPE;
4744: l_revised_item_number mtl_system_items_vl.concatenated_segments%TYPE;
4745: l_use_up_item_name mtl_system_items_vl.concatenated_segments%TYPE;
4746: l_revised_item_name mtl_system_items_vl.concatenated_segments%TYPE;
4747: l_new_item_revision mtl_item_revisions.revision%TYPE;

Line 4954: FROM mrp_bom_plan_name_lov_v pl

4950: THEN
4951: BEGIN
4952: SELECT pl.plan_name
4953: INTO l_use_up_plan_name
4954: FROM mrp_bom_plan_name_lov_v pl
4955: WHERE pl.item_id = ri.use_up_item_id
4956: AND pl.organization_id = p_local_organization_id
4957: AND pl.plan_name = ri.use_up_plan_name;
4958: EXCEPTION