[Home] [Help]
3791: END IF;
3792: IF l_restrict_locators_code= 1 THEN --Locators restricted to predefined list
3793: OPEN x_locators FOR
3794: SELECT a.inventory_location_id
3795: , inv_project.get_locsegs(a.inventory_location_id,l_org)
3796: , NVL(a.description, -1)
3797: FROM mtl_item_locations a, mtl_secondary_locators b
3798: WHERE b.organization_id = l_org
3799: AND b.inventory_item_id = p_inventory_item_id
3799: AND b.inventory_item_id = p_inventory_item_id
3800: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
3801: AND b.subinventory_code = p_subinventory_code
3802: AND a.inventory_location_id = b.secondary_locator
3803: AND inv_project.get_locsegs(a.inventory_location_id, l_org) LIKE (p_concatenated_segments||'%')
3804: AND NVL(a.project_id, -1) = NVL(p_project_id, -1)
3805: AND NVL(a.task_id, -1) = NVL(p_task_id, -1)
3806: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, l_org, p_inventory_item_id, p_subinventory_code, a.inventory_location_id, NULL, NULL, 'L') = 'Y'
3807: ORDER BY 2;
3807: ORDER BY 2;
3808: ELSE --Locators not restricted
3809: OPEN x_locators FOR
3810: SELECT inventory_location_id
3811: , inv_project.get_locsegs(inventory_location_id, l_org)
3812: , description
3813: FROM mtl_item_locations
3814: WHERE organization_id = l_org
3815: AND subinventory_code = p_subinventory_code
3813: FROM mtl_item_locations
3814: WHERE organization_id = l_org
3815: AND subinventory_code = p_subinventory_code
3816: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
3817: AND inv_project.get_locsegs(inventory_location_id, l_org) LIKE (p_concatenated_segments||'%')
3818: AND NVL(project_id, -1) = NVL(p_project_id, -1)
3819: AND NVL(task_id, -1) = NVL(p_task_id, -1)
3820: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, l_org, p_inventory_item_id, p_subinventory_code, inventory_location_id, NULL, NULL, 'L') = 'Y'
3821: ORDER BY 2;