APPS.WIP_DISCRETE_WS_MOVE dependencies on MTL_ITEM_LOCATIONS_KFV

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

540: OPEN x_Locators FOR
541: SELECT inventory_location_id,
542: concatenated_segments,
543: description
544: FROM mtl_item_locations_kfv
545: WHERE organization_id = p_Organization_Id
546: AND subinventory_code = p_Subinventory_Code
547: AND nvl(disable_date, trunc(sysdate+1)) > trunc(sysdate)
548: AND concatenated_segments LIKE (p_concatenated_segments )

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

Line 600: FROM mtl_item_locations_kfv

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