DBA Data[Home] [Help]

APPS.WIP_DISCRETE_WS_MOVE dependencies on INV_PROJECT

Line 597: inv_project.get_locator(a.inventory_location_id,

593: ELSE /*PJM org*/
594: IF p_Restrict_Locators_Code = 1 AND l_sub_type = 1 THEN --Locators restricted to predefined list
595: OPEN x_Locators FOR
596: SELECT a.inventory_location_id,
597: inv_project.get_locator(a.inventory_location_id,
598: a.organization_id) concatenated_segments,
599: nvl( a.description, -1)
600: FROM mtl_item_locations_kfv a,mtl_secondary_locators b
601: WHERE b.organization_id = p_Organization_Id

Line 626: inv_project.get_locator(inventory_location_id,

622: ORDER BY 2;
623: ELSE --Locators not restricted
624: OPEN x_Locators FOR
625: SELECT inventory_location_id,
626: inv_project.get_locator(inventory_location_id,
627: organization_id) concatenated_segments,
628: description
629: FROM mtl_item_locations_kfv
630: WHERE organization_id = p_Organization_Id