APPS.INV_LOC_WMS_UTILS dependencies on MTL_ITEM_LOCATIONS_KFV

Line 595: FROM mtl_item_locations_kfv

591: ############# If the locator capacity is infinite, then dont update anything, simply return#############
592: */
593: SELECT location_maximum_units, max_weight, max_cubic_area
594: INTO l_max_units, l_max_weight, l_max_cubic_area
595: FROM mtl_item_locations_kfv
596: WHERE organization_id = p_organization_id
597: AND inventory_location_id = l_inventory_location_id;
598:
599: IF l_max_units IS NULL AND l_max_weight IS NULL AND l_max_cubic_area IS NULL THEN

Line 1305: FROM mtl_item_locations_kfv

1301: ############# If the locator capacity is infinite, then dont update anything, simply return#############
1302: */
1303: SELECT location_maximum_units, max_weight, max_cubic_area
1304: INTO l_max_units, l_max_weight, l_max_cubic_area
1305: FROM mtl_item_locations_kfv
1306: WHERE organization_id = p_organization_id
1307: AND inventory_location_id = l_inventory_location_id;
1308:
1309: IF l_max_units IS NULL AND l_max_weight IS NULL AND l_max_cubic_area IS NULL THEN

Line 1866: FROM mtl_item_locations_kfv

1862: ############# If the locator capacity is infinite, then dont update anything, simply return#############
1863: */
1864: SELECT location_maximum_units, max_weight, max_cubic_area
1865: INTO l_max_units, l_max_weight, l_max_cubic_area
1866: FROM mtl_item_locations_kfv
1867: WHERE organization_id = p_organization_id
1868: AND inventory_location_id = l_inventory_location_id;
1869:
1870: IF l_max_units IS NULL AND l_max_weight IS NULL AND l_max_cubic_area IS NULL THEN

Line 5830: FROM mtl_item_locations_kfv

5826: ############# If the locator capacity is infinite, then dont update anything, simply return#############
5827: */
5828: SELECT location_maximum_units, max_weight, max_cubic_area
5829: INTO l_max_units, l_max_weight, l_max_cubic_area
5830: FROM mtl_item_locations_kfv
5831: WHERE organization_id = p_organization_id
5832: AND inventory_location_id = l_inventory_location_id;
5833:
5834: 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 5845: FROM mtl_item_locations_kfv

5841: );
5842:
5843: SELECT location_maximum_units, max_weight, max_cubic_area
5844: INTO l_max_units, l_max_weight, l_max_cubic_area
5845: FROM mtl_item_locations_kfv
5846: WHERE organization_id = p_from_org_id
5847: AND inventory_location_id = l_from_inventory_location_id;
5848:
5849: 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 */