APPS.INV_LOC_WMS_PUB dependencies on MTL_ITEM_LOCATIONS_KFV

Line 679: FROM mtl_item_locations_kfv

675:
676: BEGIN
677: SELECT concatenated_segments
678: INTO l_locator
679: FROM mtl_item_locations_kfv
680: WHERE organization_id = p_organization_id
681: AND alias = l_alias
682: AND NVL(physical_location_id,inventory_location_id) = inventory_location_id;
683:

Line 702: FROM mtl_item_locations_kfv

698: BEGIN
699:
700: SELECT concatenated_segments
701: INTO l_locator
702: FROM mtl_item_locations_kfv
703: WHERE organization_id = p_organization_id
704: AND alias = l_alias
705: AND subinventory_code = p_subinventory_code
706: AND NVL(physical_location_id,inventory_location_id) = inventory_location_id;

Line 741: FROM mtl_item_locations_kfv

737: /*
738: BEGIN
739: SELECT inventory_location_id
740: INTO x_inventory_location_id
741: FROM mtl_item_locations_kfv
742: WHERE organization_id = l_organization_id
743: AND subinventory_code = p_subinventory_code
744: AND concatenated_segments = p_concatenated_segments
745: AND ROWNUM < 2;

Line 888: FROM mtl_item_locations_kfv

884: -- Bug 7581675
885:
886: SELECT subinventory_code
887: INTO l_subinventory_code
888: FROM mtl_item_locations_kfv
889: WHERE concatenated_segments like l_physical_concat_seg||'%' -- instead of p_concatenated_segments
890: AND p_subinventory_code <> subinventory_code
891: AND organization_id = l_organization_id
892: AND ROWNUM = 1 ;

Line 1468: FROM MTL_ITEM_LOCATIONS_KFV

1464:
1465: /* BEGIN
1466: SELECT inventory_location_id
1467: INTO l_inventory_location_id
1468: FROM MTL_ITEM_LOCATIONS_KFV
1469: WHERE concatenated_segments = p_concatenated_segments
1470: and organization_id = l_organization_id;
1471: END;
1472: */

Line 1597: FROM mtl_item_locations_kfv

1593:
1594: BEGIN
1595: SELECT concatenated_segments
1596: INTO l_locator
1597: FROM mtl_item_locations_kfv
1598: WHERE organization_id = p_organization_id
1599: AND alias = l_alias
1600: AND NVL(physical_location_id,inventory_location_id) = inventory_location_id;
1601:

Line 1619: FROM mtl_item_locations_kfv

1615:
1616: BEGIN
1617: SELECT concatenated_segments
1618: INTO l_locator
1619: FROM mtl_item_locations_kfv
1620: WHERE organization_id = p_organization_id
1621: AND alias = l_alias
1622: AND subinventory_code = l_subinventory_code
1623: AND NVL(physical_location_id,inventory_location_id) = inventory_location_id;

Line 2161: FROM mtl_item_locations_kfv

2157: ELSE
2158: BEGIN
2159: SELECT inventory_location_id
2160: INTO l_locator_id
2161: FROM mtl_item_locations_kfv
2162: WHERE concatenated_segments = p_locator
2163: AND organization_id = l_organization_id;
2164: EXCEPTION
2165: WHEN NO_DATA_FOUND THEN