APPS.WIP_DISCRETE_WS_MOVE dependencies on MTL_ITEM_LOCATIONS_KFV

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 573: FROM mtl_item_locations_kfv

569: OPEN x_Locators FOR
570: SELECT inventory_location_id,
571: concatenated_segments,
572: description
573: FROM mtl_item_locations_kfv
574: WHERE organization_id = p_Organization_Id
575: AND subinventory_code = p_Subinventory_Code
576: AND nvl(disable_date, trunc(sysdate+1)) > trunc(sysdate)
577: AND concatenated_segments LIKE (p_concatenated_segments )

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

Line 629: FROM mtl_item_locations_kfv

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
631: AND subinventory_code = p_Subinventory_Code
632: AND nvl(disable_date, trunc(sysdate+1)) > trunc(sysdate)
633: AND concatenated_segments LIKE (p_concatenated_segments )