APPS.INV_LOC_WMS_UTILS dependencies on MTL_ITEM_LOCATIONS_KFV

Line 588: FROM mtl_item_locations_kfv

584: ############# If the locator capacity is infinite, then dont update anything, simply return#############
585: */
586: SELECT location_maximum_units, max_weight, max_cubic_area
587: INTO l_max_units, l_max_weight, l_max_cubic_area
588: FROM mtl_item_locations_kfv
589: WHERE organization_id = p_organization_id
590: AND inventory_location_id = l_inventory_location_id;
591:
592: IF l_max_units IS NULL AND l_max_weight IS NULL AND l_max_cubic_area IS NULL THEN

Line 1265: FROM mtl_item_locations_kfv

1261: ############# If the locator capacity is infinite, then dont update anything, simply return#############
1262: */
1263: SELECT location_maximum_units, max_weight, max_cubic_area
1264: INTO l_max_units, l_max_weight, l_max_cubic_area
1265: FROM mtl_item_locations_kfv
1266: WHERE organization_id = p_organization_id
1267: AND inventory_location_id = l_inventory_location_id;
1268:
1269: IF l_max_units IS NULL AND l_max_weight IS NULL AND l_max_cubic_area IS NULL THEN

Line 1800: FROM mtl_item_locations_kfv

1796: ############# If the locator capacity is infinite, then dont update anything, simply return#############
1797: */
1798: SELECT location_maximum_units, max_weight, max_cubic_area
1799: INTO l_max_units, l_max_weight, l_max_cubic_area
1800: FROM mtl_item_locations_kfv
1801: WHERE organization_id = p_organization_id
1802: AND inventory_location_id = l_inventory_location_id;
1803:
1804: IF l_max_units IS NULL AND l_max_weight IS NULL AND l_max_cubic_area IS NULL THEN

Line 5402: FROM mtl_item_locations_kfv

5398: ############# If the locator capacity is infinite, then dont update anything, simply return#############
5399: */
5400: SELECT location_maximum_units, max_weight, max_cubic_area
5401: INTO l_max_units, l_max_weight, l_max_cubic_area
5402: FROM mtl_item_locations_kfv
5403: WHERE organization_id = p_organization_id
5404: AND inventory_location_id = l_inventory_location_id;
5405:
5406: IF l_max_units IS NULL AND l_max_weight IS NULL AND l_max_cubic_area IS NULL AND p_transaction_action_id NOT IN (2,3,28) THEN

Line 5417: FROM mtl_item_locations_kfv

5413: );
5414:
5415: SELECT location_maximum_units, max_weight, max_cubic_area
5416: INTO l_max_units, l_max_weight, l_max_cubic_area
5417: FROM mtl_item_locations_kfv
5418: WHERE organization_id = p_from_org_id
5419: AND inventory_location_id = l_from_inventory_location_id;
5420:
5421: IF l_max_units IS NULL AND l_max_weight IS NULL AND l_max_cubic_area IS NULL THEN /* If from locator is infinite */