DBA Data[Home] [Help]

APPS.WIP_DISCRETE_WS_MOVE dependencies on MTL_SECONDARY_LOCATORS

Line 517: FROM mtl_item_locations_kfv a,mtl_secondary_locators b

513: OPEN x_Locators FOR
514: SELECT a.inventory_location_id,
515: a.concatenated_segments,
516: nvl( a.description, -1)
517: FROM mtl_item_locations_kfv a,mtl_secondary_locators b
518: WHERE b.organization_id = p_Organization_Id
519: AND b.inventory_item_id = p_Inventory_Item_Id
520: AND nvl(a.disable_date, trunc(sysdate+1)) > trunc(sysdate)
521: AND b.subinventory_code = p_Subinventory_Code

Line 571: FROM mtl_item_locations_kfv a,mtl_secondary_locators b

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