DBA Data[Home] [Help]

APPS.WIP_DISCRETE_WS_MOVE dependencies on INV_PROJECT

Line 568: inv_project.get_locator(a.inventory_location_id,

564: ELSE /*PJM org*/
565: IF p_Restrict_Locators_Code = 1 AND l_sub_type = 1 THEN --Locators restricted to predefined list
566: OPEN x_Locators FOR
567: SELECT a.inventory_location_id,
568: inv_project.get_locator(a.inventory_location_id,
569: a.organization_id) concatenated_segments,
570: nvl( a.description, -1)
571: FROM mtl_item_locations_kfv a,mtl_secondary_locators b
572: WHERE b.organization_id = p_Organization_Id

Line 597: inv_project.get_locator(inventory_location_id,

593: ORDER BY 2;
594: ELSE --Locators not restricted
595: OPEN x_Locators FOR
596: SELECT inventory_location_id,
597: inv_project.get_locator(inventory_location_id,
598: organization_id) concatenated_segments,
599: description
600: FROM mtl_item_locations_kfv
601: WHERE organization_id = p_Organization_Id