APPS.INV_LOC_WMS_PUB dependencies on MTL_ITEM_LOCATIONS_KFV

Line 621: FROM mtl_item_locations_kfv

617:
618: BEGIN
619: SELECT concatenated_segments
620: INTO l_locator
621: FROM mtl_item_locations_kfv
622: WHERE organization_id = p_organization_id
623: AND alias = l_alias
624: AND NVL(physical_location_id,inventory_location_id) = inventory_location_id;
625:

Line 644: FROM mtl_item_locations_kfv

640: BEGIN
641:
642: SELECT concatenated_segments
643: INTO l_locator
644: FROM mtl_item_locations_kfv
645: WHERE organization_id = p_organization_id
646: AND alias = l_alias
647: AND subinventory_code = p_subinventory_code
648: AND NVL(physical_location_id,inventory_location_id) = inventory_location_id;

Line 683: FROM mtl_item_locations_kfv

679: /*
680: BEGIN
681: SELECT inventory_location_id
682: INTO x_inventory_location_id
683: FROM mtl_item_locations_kfv
684: WHERE organization_id = l_organization_id
685: AND subinventory_code = p_subinventory_code
686: AND concatenated_segments = p_concatenated_segments
687: AND ROWNUM < 2;

Line 820: FROM mtl_item_locations_kfv

816: WHERE EXISTS( */
817:
818: SELECT subinventory_code
819: INTO l_subinventory_code
820: FROM mtl_item_locations_kfv
821: WHERE concatenated_segments = p_concatenated_segments
822: AND p_subinventory_code <> subinventory_code
823: AND organization_id = l_organization_id
824: AND ROWNUM = 1 ;

Line 1385: FROM MTL_ITEM_LOCATIONS_KFV

1381:
1382: /* BEGIN
1383: SELECT inventory_location_id
1384: INTO l_inventory_location_id
1385: FROM MTL_ITEM_LOCATIONS_KFV
1386: WHERE concatenated_segments = p_concatenated_segments
1387: and organization_id = l_organization_id;
1388: END;
1389: */

Line 1514: FROM mtl_item_locations_kfv

1510:
1511: BEGIN
1512: SELECT concatenated_segments
1513: INTO l_locator
1514: FROM mtl_item_locations_kfv
1515: WHERE organization_id = p_organization_id
1516: AND alias = l_alias
1517: AND NVL(physical_location_id,inventory_location_id) = inventory_location_id;
1518:

Line 1536: FROM mtl_item_locations_kfv

1532:
1533: BEGIN
1534: SELECT concatenated_segments
1535: INTO l_locator
1536: FROM mtl_item_locations_kfv
1537: WHERE organization_id = p_organization_id
1538: AND alias = l_alias
1539: AND subinventory_code = l_subinventory_code
1540: AND NVL(physical_location_id,inventory_location_id) = inventory_location_id;

Line 2065: FROM mtl_item_locations_kfv

2061: ELSE
2062: BEGIN
2063: SELECT inventory_location_id
2064: INTO l_locator_id
2065: FROM mtl_item_locations_kfv
2066: WHERE concatenated_segments = p_locator
2067: AND organization_id = l_organization_id;
2068: EXCEPTION
2069: WHEN NO_DATA_FOUND THEN