[Home] [Help]
4865: --l_propagated_rev_items_tbl Prop_Rev_Items_Tbl_Type;
4866: --l_prop_rev_items_count NUMBER;
4867: l_propagate_revised_item NUMBER;
4868: l_parent_revised_item_name mtl_system_items_vl.concatenated_segments%TYPE;
4869: l_use_up_plan_name mrp_bom_plan_name_lov_v.plan_name%TYPE;
4870: l_revised_item_number mtl_system_items_vl.concatenated_segments%TYPE;
4871: l_use_up_item_name mtl_system_items_vl.concatenated_segments%TYPE;
4872: l_revised_item_name mtl_system_items_vl.concatenated_segments%TYPE;
4873: l_new_item_revision mtl_item_revisions.revision%TYPE;
5077: THEN
5078: BEGIN
5079: SELECT pl.plan_name
5080: INTO l_use_up_plan_name
5081: FROM mrp_bom_plan_name_lov_v pl
5082: WHERE pl.item_id = ri.use_up_item_id
5083: AND pl.organization_id = p_local_organization_id
5084: AND pl.plan_name = ri.use_up_plan_name;
5085: EXCEPTION