DBA Data[Home] [Help]

APPS.WIP_DISCRETE_WS_MOVE dependencies on MTL_SECONDARY_LOCATORS

Line 546: FROM mtl_item_locations_kfv a,mtl_secondary_locators b

542: OPEN x_Locators FOR
543: SELECT a.inventory_location_id,
544: a.concatenated_segments,
545: nvl( a.description, -1)
546: FROM mtl_item_locations_kfv a,mtl_secondary_locators b
547: WHERE b.organization_id = p_Organization_Id
548: AND b.inventory_item_id = p_Inventory_Item_Id
549: AND nvl(a.disable_date, trunc(sysdate+1)) > trunc(sysdate)
550: AND b.subinventory_code = p_Subinventory_Code

Line 600: FROM mtl_item_locations_kfv a,mtl_secondary_locators b

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
602: AND b.inventory_item_id = p_Inventory_Item_Id
603: AND nvl(a.disable_date, trunc(sysdate+1)) > trunc(sysdate)
604: AND b.subinventory_code = p_Subinventory_Code