1741: WHERE header_id = l_request_line_rec.header_id;
1742:
1743: CURSOR c_sub_loc_control_from IS
1744: SELECT locator_type
1745: FROM mtl_secondary_inventories
1746: WHERE secondary_inventory_name = l_request_line_rec.from_subinventory_code
1747: AND organization_id = l_request_line_rec.organization_id;
1748:
1749: CURSOR c_sub_loc_control_to IS
1747: AND organization_id = l_request_line_rec.organization_id;
1748:
1749: CURSOR c_sub_loc_control_to IS
1750: SELECT locator_type
1751: FROM mtl_secondary_inventories
1752: WHERE secondary_inventory_name = l_request_line_rec.to_subinventory_code
1753: AND organization_id = l_request_line_rec.to_organization_id;
1754:
1755: CURSOR c_item_loc_control_from IS