eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_LOC_WMS_UTILS dependencies on MTL_ITEM_LOCATIONS

Line 59: FROM mtl_item_locations

55: SELECT physical_location_id ,
56: inventory_location_id
57: INTO l_physical_locator_id,
58: l_locator_id
59: FROM mtl_item_locations
60: WHERE inventory_location_id =p_inventory_location_id
61: and organization_id = p_organization_id; */
62:
63: SELECT

Line 96: from mtl_item_locations

92: x_max_cubic_area,
93: x_current_cubic_area,
94: x_suggested_cubic_area,
95: x_available_cubic_area
96: from mtl_item_locations
97: where organization_id = p_organization_id
98: and inventory_location_id = p_inventory_location_id;
99:
100: IF (l_physical_locator_id is NOT null) AND (l_physical_locator_id <> p_inventory_location_id) THEN

Line 132: from mtl_item_locations

128: x_max_cubic_area,
129: x_current_cubic_area,
130: x_suggested_cubic_area,
131: x_available_cubic_area
132: from mtl_item_locations
133: where organization_id = p_organization_id
134: and inventory_location_id = l_physical_locator_id;
135:
136: END IF;

Line 205: FROM mtl_item_locations

201: SELECT physical_location_id ,
202: inventory_location_id
203: INTO l_physical_locator_id,
204: l_locator_id
205: FROM mtl_item_locations
206: WHERE inventory_location_id =p_inventory_location_id
207: and organization_id = p_organization_id; */
208: SELECT physical_location_id ,
209: inventory_location_id ,

Line 220: FROM mtl_item_locations

216: x_location_maximum_units,
217: x_location_current_units,
218: x_location_available_units,
219: x_location_suggested_units
220: FROM mtl_item_locations
221: WHERE inventory_location_id =p_inventory_location_id
222: and organization_id = p_organization_id;
223:
224: IF (l_physical_locator_id is NOT null) AND (l_physical_locator_id <> p_inventory_location_id) THEN

Line 235: from mtl_item_locations

231: x_location_maximum_units,
232: x_location_current_units,
233: x_location_available_units,
234: x_location_suggested_units
235: from mtl_item_locations
236: where organization_id = p_organization_id
237: and inventory_location_id = l_physical_locator_id; -- 7263312 changed to l_physical_locator_id
238: END IF;
239:

Line 309: FROM mtl_item_locations

305: SELECT physical_location_id ,
306: inventory_location_id
307: INTO l_physical_locator_id,
308: l_locator_id
309: FROM mtl_item_locations
310: WHERE inventory_location_id =p_inventory_location_id
311: and organization_id = p_organization_id; */
312: SELECT physical_location_id ,
313: inventory_location_id,

Line 326: FROM mtl_item_locations

322: x_max_weight,
323: x_current_weight,
324: x_suggested_weight,
325: x_available_weight
326: FROM mtl_item_locations
327: WHERE inventory_location_id =p_inventory_location_id
328: and organization_id = p_organization_id;
329:
330: IF (l_physical_locator_id is NOT null) AND (l_physical_locator_id <> p_inventory_location_id) THEN

Line 343: from mtl_item_locations

339: x_max_weight,
340: x_current_weight,
341: x_suggested_weight,
342: x_available_weight
343: from mtl_item_locations
344: where organization_id = p_organization_id
345: and inventory_location_id = l_physical_locator_id; -- 7263312 changed to l_physical_locator_id
346: END IF;
347:

Line 416: FROM mtl_item_locations

412: SELECT physical_location_id ,
413: inventory_location_id
414: INTO l_physical_locator_id,
415: l_locator_id
416: FROM mtl_item_locations
417: WHERE inventory_location_id =p_inventory_location_id
418: and organization_id = p_organization_id; */
419:
420: SELECT physical_location_id ,

Line 434: FROM mtl_item_locations

430: x_max_cubic_area,
431: x_current_cubic_area,
432: x_suggested_cubic_area,
433: x_available_cubic_area
434: FROM mtl_item_locations
435: WHERE organization_id = p_organization_id
436: and inventory_location_id = p_inventory_location_id;
437:
438: IF (l_physical_locator_id is NOT null) AND (l_physical_locator_id <> l_inventory_location_id) THEN

Line 451: from mtl_item_locations

447: x_max_cubic_area,
448: x_current_cubic_area,
449: x_suggested_cubic_area,
450: x_available_cubic_area
451: from mtl_item_locations
452: where organization_id = p_organization_id
453: and inventory_location_id = l_physical_locator_id;
454: END IF;
455:

Line 580: FROM mtl_item_locations

576: SELECT physical_location_id ,
577: inventory_location_id
578: INTO l_physical_locator_id,
579: l_locator_id
580: FROM mtl_item_locations
581: WHERE inventory_location_id =p_inventory_location_id
582: and organization_id = p_organization_id;
583:
584: IF l_physical_locator_id is null THEN

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 614: FROM mtl_item_locations

610: WHILE ((l_loc_counter > 0) and (l_locator_locked))
611: LOOP
612: BEGIN
613: SELECT inventory_location_id INTO l_inventory_location_id
614: FROM mtl_item_locations
615: WHERE inventory_location_id = l_inventory_location_id
616: and organization_id = p_organization_id
617: FOR UPDATE NOWAIT;
618:

Line 648: -- select necessary data from mtl_system_items and mtl_item_locations

644: -- ensure that the input quantity (p_quantity) is always positive regardless whether
645: -- issue or receipt
646: l_quantity :=Abs(p_quantity);
647:
648: -- select necessary data from mtl_system_items and mtl_item_locations
649: select
650: primary_uom_code,
651: weight_uom_code,
652: unit_weight,

Line 695: from mtl_item_locations

691: l_max_cubic_area,
692: l_current_cubic_area,
693: l_suggested_cubic_area,
694: l_available_cubic_area
695: from mtl_item_locations
696: where organization_id = p_organization_id
697: and inventory_location_id = l_inventory_location_id;
698:
699: IF (l_debug = 1) THEN

Line 961: -- Now we update the table MTL_ITEM_LOCATIONS

957: END IF;
958: IF (l_debug = 1) THEN
959: mdebug('l_upd_loc_current_units: '|| l_upd_loc_current_units);
960: END IF;
961: -- Now we update the table MTL_ITEM_LOCATIONS
962: IF (l_update_weight) OR (l_update_volume) OR (l_update_units) THEN
963: UPDATE mtl_item_locations
964: SET
965: location_current_units = l_upd_loc_current_units,

Line 963: UPDATE mtl_item_locations

959: mdebug('l_upd_loc_current_units: '|| l_upd_loc_current_units);
960: END IF;
961: -- Now we update the table MTL_ITEM_LOCATIONS
962: IF (l_update_weight) OR (l_update_volume) OR (l_update_units) THEN
963: UPDATE mtl_item_locations
964: SET
965: location_current_units = l_upd_loc_current_units,
966: location_available_units = l_upd_loc_available_units,
967: current_weight = l_upd_loc_current_weight,

Line 1290: FROM mtl_item_locations

1286: SELECT physical_location_id ,
1287: inventory_location_id
1288: INTO l_physical_locator_id,
1289: l_locator_id
1290: FROM mtl_item_locations
1291: WHERE inventory_location_id =p_inventory_location_id
1292: and organization_id = p_organization_id;
1293:
1294: IF l_physical_locator_id 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 1323: FROM mtl_item_locations

1319: WHILE ((l_loc_counter > 0) and (l_locator_locked))
1320: LOOP
1321: BEGIN
1322: SELECT inventory_location_id INTO l_inventory_location_id
1323: FROM mtl_item_locations
1324: WHERE inventory_location_id = l_inventory_location_id
1325: and organization_id = p_organization_id
1326: FOR UPDATE NOWAIT;
1327:

Line 1356: -- select necessary data from mtl_system_items and mtl_item_locations

1352:
1353: -- ensure that the input quantity (p_quantity) is always positive regardless whether
1354: -- issue or receipt
1355: l_quantity :=Abs(p_quantity);
1356: -- select necessary data from mtl_system_items and mtl_item_locations
1357: select
1358: primary_uom_code,
1359: weight_uom_code,
1360: unit_weight,

Line 1403: from mtl_item_locations

1399: l_max_cubic_area,
1400: l_current_cubic_area,
1401: l_suggested_cubic_area,
1402: l_available_cubic_area
1403: from mtl_item_locations
1404: where organization_id = p_organization_id
1405: and inventory_location_id = l_inventory_location_id;
1406:
1407: IF (l_debug = 1) THEN

Line 1589: -- Now we update the table MTL_ITEM_LOCATIONS

1585:
1586: IF (l_debug = 1) THEN
1587: mdebug('l_upd_loc_suggested_units: '|| l_upd_loc_suggested_units);
1588: END IF;
1589: -- Now we update the table MTL_ITEM_LOCATIONS
1590: IF (l_update_weight) OR (l_update_volume) OR (l_update_units) THEN
1591: UPDATE mtl_item_locations
1592: SET
1593: location_suggested_units = l_upd_loc_suggested_units,

Line 1591: UPDATE mtl_item_locations

1587: mdebug('l_upd_loc_suggested_units: '|| l_upd_loc_suggested_units);
1588: END IF;
1589: -- Now we update the table MTL_ITEM_LOCATIONS
1590: IF (l_update_weight) OR (l_update_volume) OR (l_update_units) THEN
1591: UPDATE mtl_item_locations
1592: SET
1593: location_suggested_units = l_upd_loc_suggested_units,
1594: location_available_units = l_upd_loc_available_units,
1595: suggested_weight = l_upd_loc_suggested_weight,

Line 1851: FROM mtl_item_locations

1847: SELECT physical_location_id ,
1848: inventory_location_id
1849: INTO l_physical_locator_id,
1850: l_locator_id
1851: FROM mtl_item_locations
1852: WHERE inventory_location_id =p_inventory_location_id
1853: and organization_id = p_organization_id;
1854:
1855: IF l_physical_locator_id 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 1888: FROM mtl_item_locations

1884: LOOP
1885: BEGIN
1886:
1887: SELECT inventory_location_id INTO l_inventory_location_id
1888: FROM mtl_item_locations
1889: WHERE inventory_location_id = l_inventory_location_id
1890: AND organization_id = p_organization_id
1891: FOR UPDATE NOWAIT;
1892:

Line 1922: -- select necessary data from mtl_system_items and mtl_item_locations

1918:
1919: -- ensure that the input quantity (p_quantity) is always positive regardless whether
1920: -- issue or receipt
1921: l_quantity :=Abs(p_quantity);
1922: -- select necessary data from mtl_system_items and mtl_item_locations
1923: select
1924: primary_uom_code,
1925: weight_uom_code,
1926: unit_weight,

Line 1969: from mtl_item_locations

1965: l_max_cubic_area,
1966: l_current_cubic_area,
1967: l_suggested_cubic_area,
1968: l_available_cubic_area
1969: from mtl_item_locations
1970: where organization_id = p_organization_id
1971: and inventory_location_id = l_inventory_location_id;
1972:
1973: -- Convert transaction quantity into primary quantity (l_primary_quantity) if needed

Line 2156: -- Now we update the table MTL_ITEM_LOCATIONS

2152: l_upd_loc_suggested_units := l_suggested_units;
2153: l_upd_loc_available_units := l_available_units;
2154: END IF;
2155:
2156: -- Now we update the table MTL_ITEM_LOCATIONS
2157: IF (l_update_weight) OR (l_update_volume) OR (l_update_units) THEN
2158: UPDATE mtl_item_locations
2159: SET
2160: location_suggested_units = l_upd_loc_suggested_units,

Line 2158: UPDATE mtl_item_locations

2154: END IF;
2155:
2156: -- Now we update the table MTL_ITEM_LOCATIONS
2157: IF (l_update_weight) OR (l_update_volume) OR (l_update_units) THEN
2158: UPDATE mtl_item_locations
2159: SET
2160: location_suggested_units = l_upd_loc_suggested_units,
2161: location_available_units = l_upd_loc_available_units,
2162: suggested_weight = l_upd_loc_suggested_weight,

Line 2195: -- capacity locator eventually leading to the empty_flag being incorrectly updated in mtl_item_locations table.

2191: --bug#9159019 FPing fix for #8944467 end
2192:
2193: -- Start of Bug 13095024 change
2194: -- For some cases, l_source is getting updated to NULL from the above procedure call for an infinite
2195: -- capacity locator eventually leading to the empty_flag being incorrectly updated in mtl_item_locations table.
2196: IF l_max_units IS NULL AND l_max_weight IS NULL AND l_max_cubic_area IS NULL THEN
2197:
2198: IF (l_debug = 1) THEN
2199: mdebug('In revert_loc_suggested_cap_nauto, setting l_source to INFINITE for an infinite capacity locator');

Line 2636: ,mtl_item_locations mil

2632: ,mil2.location_maximum_units
2633: ,mil2.max_weight
2634: ,mil2.max_cubic_area
2635: FROM mtl_onhand_quantities_detail moq
2636: ,mtl_item_locations mil
2637: ,mtl_item_locations mil2
2638: ,wms_license_plate_numbers wlpn
2639: WHERE moq.locator_id = mil.inventory_location_id
2640: AND mil.organization_id = moq.organization_id

Line 2637: ,mtl_item_locations mil2

2633: ,mil2.max_weight
2634: ,mil2.max_cubic_area
2635: FROM mtl_onhand_quantities_detail moq
2636: ,mtl_item_locations mil
2637: ,mtl_item_locations mil2
2638: ,wms_license_plate_numbers wlpn
2639: WHERE moq.locator_id = mil.inventory_location_id
2640: AND mil.organization_id = moq.organization_id
2641: AND mil.subinventory_code = moq.subinventory_code

Line 2672: ,mtl_item_locations mil

2668: ,mil2.location_maximum_units
2669: ,mil2.max_weight
2670: ,mil2.max_cubic_area
2671: FROM mtl_material_transactions_temp mmtt
2672: ,mtl_item_locations mil
2673: ,mtl_item_locations mil2
2674: WHERE mmtt.locator_id = mil.inventory_location_id
2675: AND mil.organization_id = mmtt.organization_id
2676: AND mil.subinventory_code = mmtt.subinventory_code

Line 2673: ,mtl_item_locations mil2

2669: ,mil2.max_weight
2670: ,mil2.max_cubic_area
2671: FROM mtl_material_transactions_temp mmtt
2672: ,mtl_item_locations mil
2673: ,mtl_item_locations mil2
2674: WHERE mmtt.locator_id = mil.inventory_location_id
2675: AND mil.organization_id = mmtt.organization_id
2676: AND mil.subinventory_code = mmtt.subinventory_code
2677: AND (l_locator_id IS NULL OR nvl(mil.physical_location_id,mil.inventory_location_id) = l_locator_id)

Line 2711: ,mtl_item_locations mil

2707: ,mil2.location_maximum_units
2708: ,mil2.max_weight
2709: ,mil2.max_cubic_area
2710: FROM mtl_material_transactions_temp mmtt
2711: ,mtl_item_locations mil
2712: ,mtl_item_locations mil2
2713: WHERE mmtt.transfer_to_location = mil.inventory_location_id
2714: AND mil.organization_id = mmtt.organization_id
2715: AND mil.subinventory_code = mmtt.transfer_subinventory -- Bug 5941137 For Destination Locator

Line 2712: ,mtl_item_locations mil2

2708: ,mil2.max_weight
2709: ,mil2.max_cubic_area
2710: FROM mtl_material_transactions_temp mmtt
2711: ,mtl_item_locations mil
2712: ,mtl_item_locations mil2
2713: WHERE mmtt.transfer_to_location = mil.inventory_location_id
2714: AND mil.organization_id = mmtt.organization_id
2715: AND mil.subinventory_code = mmtt.transfer_subinventory -- Bug 5941137 For Destination Locator
2716: -- AND nvl(mil.physical_location_id,mil.inventory_location_id) = l_locator_id

Line 2731: FROM mtl_item_locations

2727:
2728: -- cursor to store the distinct physical_location_id of locators
2729: CURSOR cur_loc_id(l_subinventory VARCHAR2, l_locator_id NUMBER) IS
2730: SELECT DISTINCT NVL(physical_location_id, inventory_location_id) physical_location_id
2731: FROM mtl_item_locations
2732: WHERE organization_id = p_organization_id
2733: AND (l_subinventory IS NULL or subinventory_code = l_subinventory)
2734: AND (l_locator_id IS NULL or NVL(physical_location_id, inventory_location_id) = l_locator_id);
2735:

Line 2774: -- Removed the update statement to reset the complete mtl_item_locations table to avoid incorrect data

2770:
2771: -- Bug 12937771 additions (Start)
2772:
2773: -- (FP changes of Bug 11877396)
2774: -- Removed the update statement to reset the complete mtl_item_locations table to avoid incorrect data
2775: -- being committed in the batch COMMIT for some of the locators in the For loop below.
2776: -- This was causing incorrect Put away suggestions while running ULC in conjunction with
2777: -- Pre-Generate Putaway Suggestions program.
2778:

Line 2944: UPDATE mtl_item_locations

2940:
2941: IF (l_loc_count = 500) THEN
2942: -- BULK update
2943: FORALL k IN t_locator.FIRST..t_locator.LAST
2944: UPDATE mtl_item_locations
2945: SET location_current_units = t_location_current_units(k)
2946: ,location_suggested_units = t_location_suggested_units(k)
2947: ,location_available_units = t_location_available_units(k)
2948: ,current_weight = t_current_weight(k)

Line 3689: UPDATE mtl_item_locations

3685: -- End of fix for the last locator => additions for Bug 10123934 fix
3686: -- **********************************************************************
3687:
3688: FORALL k IN t_locator.FIRST..t_locator.LAST
3689: UPDATE mtl_item_locations
3690: SET location_current_units = t_location_current_units(k)
3691: ,location_suggested_units = t_location_suggested_units(k)
3692: ,location_available_units = t_location_available_units(k)
3693: ,current_weight = t_current_weight(k)

Line 3752: mdebug('Updating the columns for empty locators in mtl_item_locations table...');

3748:
3749: -- Bug 12937771 additions (Start)
3750:
3751: IF (l_debug = 1) THEN
3752: mdebug('Updating the columns for empty locators in mtl_item_locations table...');
3753: END IF;
3754:
3755: l_locator_id := t_loc_hasOnhand.FIRST;
3756:

Line 3771: UPDATE mtl_item_locations

3767:
3768: t_loc_hasOnhand.DELETE;
3769:
3770: FORALL k in t_loc_id_emp.FIRST..t_loc_id_emp.LAST
3771: UPDATE mtl_item_locations
3772: SET location_current_units = DECODE(location_maximum_units, NULL, NULL, 0),
3773: location_suggested_units = DECODE(location_maximum_units, NULL, NULL, 0),
3774: location_available_units = location_maximum_units,
3775: current_weight = DECODE(max_weight, NULL, NULL, 0),

Line 3976: FROM mtl_item_locations

3972: SELECT physical_location_id
3973: , inventory_location_id
3974: INTO l_physical_locator_id
3975: , l_loc_id
3976: FROM mtl_item_locations
3977: WHERE inventory_location_id = p_inventory_location_id
3978: AND organization_id = p_organization_id;
3979:
3980: /*---------------------------------------------------------------------------------------------

Line 4046: FROM MTL_ITEM_LOCATIONS

4042: , l_locator_maximum_units
4043: , l_locator_current_units
4044: , l_locator_available_units
4045: , l_locator_suggested_units
4046: FROM MTL_ITEM_LOCATIONS
4047: WHERE organization_id = p_organization_id
4048: AND inventory_location_id = p_inventory_location_id;
4049:
4050: /*------------------------------------------------------------------------------------------

Line 4836: UPDATE MTL_ITEM_LOCATIONS mil

4832: IF (l_debug = 1) THEN
4833: mdebug(l_proc_name||'issue transaction is successful ');
4834: END IF;
4835:
4836: UPDATE MTL_ITEM_LOCATIONS mil
4837: SET current_weight = nvl(l_locator_current_weight,current_weight)
4838: , available_weight = nvl(l_locator_available_weight,available_weight)
4839: , current_cubic_area = nvl(l_locator_current_cubic_area,current_cubic_area)
4840: , available_cubic_area = nvl(l_locator_available_cubic_area,available_cubic_area)

Line 4944: UPDATE MTL_ITEM_LOCATIONS

4940: IF l_locator_available_cubic_area <0 THEN
4941: l_locator_available_cubic_area := 0;
4942: END IF;
4943:
4944: UPDATE MTL_ITEM_LOCATIONS
4945: SET current_weight = nvl(l_locator_current_weight,current_weight)
4946: , available_weight = nvl(l_locator_available_weight,available_weight)
4947: , current_cubic_area = nvl(l_locator_current_cubic_area,current_cubic_area)
4948: , available_cubic_area = nvl(l_locator_available_cubic_area,available_cubic_area)

Line 5041: FROM mtl_item_locations

5037: mdebug('Before locking source locator ' || l_old_inventory_location_id || ' in UPD_LPN_LOC_CPTY_FOR_XFR');
5038: END IF;
5039:
5040: SELECT inventory_location_id INTO l_old_inventory_location_id
5041: FROM mtl_item_locations
5042: WHERE inventory_location_id = l_old_inventory_location_id
5043: and organization_id = l_old_organization_id
5044: FOR UPDATE NOWAIT;
5045:

Line 5355: UPDATE MTL_ITEM_LOCATIONS

5351: END IF;
5352: END IF;
5353:
5354: IF l_update_table THEN
5355: UPDATE MTL_ITEM_LOCATIONS
5356: SET current_weight = nvl(l_old_loc_current_weight,current_weight)
5357: , available_weight = nvl(l_old_loc_available_weight,available_weight)
5358: , current_cubic_area = nvl(l_old_loc_current_vol,current_cubic_area)
5359: , available_cubic_area = nvl(l_old_loc_available_vol,available_cubic_area)

Line 5453: UPDATE MTL_ITEM_LOCATIONS

5449: IF l_loc_available_vol < 0 THEN
5450: l_loc_available_vol := 0;
5451: END IF;
5452:
5453: UPDATE MTL_ITEM_LOCATIONS
5454: SET current_weight = nvl(l_loc_current_weight,current_weight)
5455: , available_weight = nvl(l_loc_available_weight,available_weight)
5456: , current_cubic_area = nvl(l_loc_current_vol,current_cubic_area)
5457: , available_cubic_area = nvl(l_loc_available_vol,available_cubic_area)

Line 5574: UPDATE MTL_ITEM_LOCATIONS

5570: IF l_locator_available_cubic_area < 0 THEN
5571: l_locator_available_cubic_area := 0;
5572: END IF;
5573:
5574: UPDATE MTL_ITEM_LOCATIONS
5575: SET current_cubic_area = nvl(l_locator_current_cubic_area,current_cubic_area)
5576: , available_cubic_area = nvl(l_locator_available_cubic_area,available_cubic_area)
5577: , current_weight = nvl(l_locator_current_weight,current_weight)
5578: , available_weight = nvl(l_locator_available_weight,available_weight)

Line 5747: UPDATE MTL_ITEM_LOCATIONS

5743: IF l_locator_available_cubic_area < 0 THEN
5744: l_locator_available_cubic_area := 0;
5745: END IF;
5746:
5747: UPDATE MTL_ITEM_LOCATIONS
5748: SET current_cubic_area = nvl(l_locator_current_cubic_area,current_cubic_area)
5749: , available_cubic_area = nvl(l_locator_available_cubic_area,available_cubic_area)
5750: , current_weight = nvl(l_locator_current_weight,current_weight)
5751: , available_weight = nvl(l_locator_available_weight,available_weight)

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 */

Line 5861: FROM mtl_item_locations

5857: mdebug('Before locking locator ' || l_inventory_location_id || ' in UPD_LPN_LOC_CURR_CPTY_NOAUTO');
5858: END IF;
5859:
5860: SELECT inventory_location_id INTO l_inventory_location_id
5861: FROM mtl_item_locations
5862: WHERE inventory_location_id = l_inventory_location_id
5863: and organization_id = p_organization_id
5864: FOR UPDATE NOWAIT;
5865:

Line 7330: FROM mtl_item_locations

7326: SELECT physical_location_id ,
7327: inventory_location_id
7328: INTO l_physical_locator_id,
7329: l_loc_id
7330: FROM mtl_item_locations
7331: WHERE inventory_location_id = p_inventory_location_id
7332: and organization_id = p_organization_id;
7333:
7334: IF l_physical_locator_id is null THEN

Line 7352: FROM mtl_item_locations

7348: WHILE ((l_loc_counter > 0) and (l_locator_locked))
7349: LOOP
7350: BEGIN
7351: SELECT inventory_location_id INTO l_inventory_location_id
7352: FROM mtl_item_locations
7353: WHERE inventory_location_id = l_inventory_location_id
7354: and organization_id = p_organization_id
7355: FOR UPDATE NOWAIT;
7356:

Line 7459: FROM mtl_item_locations

7455: SELECT physical_location_id ,
7456: inventory_location_id
7457: INTO l_des_physical_locator_id,
7458: l_des_loc_id
7459: FROM mtl_item_locations
7460: WHERE inventory_location_id = p_transfer_location_id
7461: and organization_id = p_transfer_organization;
7462:
7463: IF l_des_physical_locator_id is null THEN

Line 7481: FROM mtl_item_locations

7477: WHILE ((l_loc_counter > 0) and (l_locator_locked))
7478: LOOP
7479: BEGIN
7480: SELECT inventory_location_id INTO l_des_inventory_location_id
7481: FROM mtl_item_locations
7482: WHERE inventory_location_id = l_des_inventory_location_id
7483: and organization_id = p_transfer_organization
7484: FOR UPDATE NOWAIT;
7485:

Line 7548: UPDATE MTL_ITEM_LOCATIONS mil

7544:
7545: --Fix for 8630843
7546: --LAST_UPDATED_BY = fnd_global.user_id added to the update statment
7547:
7548: UPDATE MTL_ITEM_LOCATIONS mil
7549: SET EMPTY_FLAG = nvl(l_empty_flag,mil.empty_flag)
7550: , MIXED_ITEMS_FLAG = nvl(l_mixed_flag,mil.mixed_items_flag)
7551: , INVENTORY_ITEM_ID = nvl(l_item_id,mil.inventory_item_id)
7552: , LAST_UPDATE_DATE = sysdate /* Added for Bug 6363028 */

Line 7601: UPDATE MTL_ITEM_LOCATIONS MIL

7597:
7598: --Fix for 8630843
7599: --LAST_UPDATED_BY = fnd_global.user_id added to the update statment
7600:
7601: UPDATE MTL_ITEM_LOCATIONS MIL
7602: SET EMPTY_FLAG = NVL(l_empty_flag,MIL.empty_flag)
7603: , MIXED_ITEMS_FLAG = NVL(l_mixed_flag,MIL.mixed_items_flag)
7604: , INVENTORY_ITEM_ID = NVL(l_item_id,MIL.inventory_item_id)
7605: , LAST_UPDATE_DATE = sysdate /* Added for Bug 6363028 */

Line 7705: FROM MTL_ITEM_LOCATIONS

7701: l_loc_suggested_units,
7702: l_mixed_flag,
7703: l_inventory_item_id,
7704: l_empty_flag
7705: FROM MTL_ITEM_LOCATIONS
7706: WHERE INVENTORY_LOCATION_ID = p_locator_id
7707: AND ORGANIZATION_ID = P_ORG_ID;
7708:
7709: IF ((nvl(l_loc_current_units,0) = 0) and

Line 7839: FROM mtl_item_locations

7835: END IF;
7836: --Added to get subinventory bug3237709
7837: SELECT subinventory_code
7838: INTO l_subinventory_code
7839: FROM mtl_item_locations
7840: WHERE inventory_location_id = p_locator_id
7841: and organization_id = p_org_id;
7842:
7843: BEGIN

Line 7935: MTL_ITEM_LOCATIONS MIL

7931: MMTT.transfer_lpn_id,
7932: MMTT.content_lpn_id,
7933: MMTT.lpn_id
7934: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT,
7935: MTL_ITEM_LOCATIONS MIL
7936: WHERE MMTT.transaction_status <> 2
7937: AND MMTT.organization_id = p_organization_id
7938: AND MMTT.LOCATOR_ID = MIL.INVENTORY_LOCATION_ID
7939: AND MIL.MIXED_ITEMS_FLAG ='Y'

Line 8312: MTL_ITEM_LOCATIONS MIL

8308: ,MIL.VOLUME_UOM_CODE
8309: ,null
8310: ,null),0))),0) content_volume
8311: FROM wms_license_plate_numbers WLPN,
8312: MTL_ITEM_LOCATIONS MIL
8313: WHERE MIL.INVENTORY_LOCATION_ID = WLPN.LOCATOR_ID
8314: AND WLPN.organization_id =p_organization_id
8315: AND WLPN.lpn_context =1
8316: AND WLPN.parent_lpn_id is null

Line 8344: MTL_ITEM_LOCATIONS MIL

8340: ,MIL.VOLUME_UOM_CODE
8341: ,null
8342: ,null),0))),0) content_volume
8343: FROM wms_license_plate_numbers WLPN,
8344: MTL_ITEM_LOCATIONS MIL
8345: WHERE WLPN.LOCATOR_ID = MIL.INVENTORY_LOCATION_ID
8346: AND WLPN.organization_id =p_organization_id
8347: AND WLPN.lpn_context =1
8348: AND WLPN.parent_lpn_id is null

Line 8393: FROM mtl_item_locations

8389: SELECT physical_location_id ,
8390: inventory_location_id
8391: INTO l_physical_locator_id,
8392: l_locator_id
8393: FROM mtl_item_locations
8394: WHERE inventory_location_id =l_curr_cpty.locator_id
8395: and organization_id = p_organization_id;
8396:
8397: IF l_physical_locator_id is null THEN

Line 8424: UPDATE mtl_item_locations

8420: when no_data_found then
8421: null;
8422: end;
8423:
8424: UPDATE mtl_item_locations
8425: set current_weight=nvl(current_weight,0)+l_curr_cpty.gross_weight,
8426: available_weight = max_weight-(nvl(suggested_weight,0) + nvl(current_weight,0)),
8427: current_cubic_area = nvl(current_cubic_area,0) + l_curr_cpty.content_volume,
8428: available_cubic_area = max_cubic_area -(nvl(suggested_cubic_area,0)+nvl(current_cubic_area,0)),

Line 8459: FROM mtl_item_locations

8455: SELECT physical_location_id ,
8456: inventory_location_id
8457: INTO l_physical_locator_id,
8458: l_locator_id
8459: FROM mtl_item_locations
8460: WHERE inventory_location_id =l_curr_cpty.locator_id
8461: and organization_id = p_organization_id;
8462:
8463: IF l_physical_locator_id is null THEN

Line 8490: UPDATE mtl_item_locations

8486: when no_data_found then
8487: null;
8488: end;
8489:
8490: UPDATE mtl_item_locations
8491: set current_weight=nvl(current_weight,0)+l_curr_cpty.gross_weight,
8492: available_weight = max_weight-(nvl(suggested_weight,0) + nvl(current_weight,0)),
8493: current_cubic_area = nvl(current_cubic_area,0) + l_curr_cpty.content_volume,
8494: available_cubic_area = max_cubic_area -(nvl(suggested_cubic_area,0)+nvl(current_cubic_area,0)),

Line 8603: FROM mtl_item_locations

8599: SELECT physical_location_id,
8600: inventory_location_id
8601: INTO l_physical_locator_id,
8602: l_locator_id
8603: FROM mtl_item_locations
8604: WHERE inventory_location_id = p_locator_id
8605: and organization_id = p_org_id;
8606:
8607: IF (l_debug = 1) THEN

Line 8660: UPDATE mtl_item_locations mil

8656: l_mixed_flag := 'N';
8657: END;
8658:
8659: --Update the empty flag/mixed flag
8660: UPDATE mtl_item_locations mil
8661: SET empty_flag = NVL(l_empty_flag,mil.empty_flag)
8662: , mixed_items_flag = NVL(l_mixed_flag,mil.mixed_items_flag)
8663: , last_update_date = sysdate /* Added for Bug 6363028 */
8664: WHERE inventory_location_id = l_locator_id

Line 8756: FROM mtl_item_locations

8752: max_cubic_area
8753: INTO l_source_max_units ,
8754: l_source_max_weight,
8755: l_source_max_cubic_area
8756: FROM mtl_item_locations
8757: WHERE inventory_location_id = p_locator_id
8758: AND organization_id = p_organization_id;
8759:
8760: END IF;