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.WMS_PARAMETER_PVT dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 4477: FROM mtl_onhand_quantities_detail moq

4473: , moq.inventory_item_id inventory_item_id
4474: , moq.subinventory_code subinventory_code
4475: , moq.locator_id locator_id
4476: , moq.primary_transaction_quantity oh_quantity
4477: FROM mtl_onhand_quantities_detail moq
4478: -- to be more conservative ( or simply realistic ) we don't add
4479: -- negative on-hand to the capacity
4480: WHERE moq.transaction_quantity > 0
4481: UNION ALL

Line 4552: FROM mtl_onhand_quantities_detail moq

4548: , moq.inventory_item_id inventory_item_id
4549: , moq.subinventory_code subinventory_code
4550: , moq.locator_id locator_id
4551: , moq.primary_transaction_quantity oh_quantity
4552: FROM mtl_onhand_quantities_detail moq
4553: -- to be more conservative ( or simply realistic ) we don't add
4554: -- negative on-hand to the capacity
4555: WHERE moq.transaction_quantity > 0
4556: UNION ALL

Line 4628: FROM mtl_onhand_quantities_detail moq

4624: , moq.inventory_item_id inventory_item_id
4625: , moq.subinventory_code subinventory_code
4626: , moq.locator_id locator_id
4627: , moq.primary_transaction_quantity oh_quantity
4628: FROM mtl_onhand_quantities_detail moq
4629: -- to be more conservative ( or simply realistic ) we don't add
4630: -- negative on-hand to the capacity
4631: WHERE moq.transaction_quantity > 0
4632: UNION ALL

Line 4870: -- not null. This way, the correct index on mtl_onhand_quantities_detail will

4866: WHERE organization_id = p_organization_id
4867: AND inventory_item_id = p_locator_inventory_item_id;
4868:
4869: --bug 2200812: change where clause so that we always assume p_locator_id is
4870: -- not null. This way, the correct index on mtl_onhand_quantities_detail will
4871: -- be used.
4872: CURSOR l_tot_onhand IS
4873: SELECT onhand.inventory_item_id
4874: , NVL(SUM(onhand.oh_quantity), 0)

Line 4883: FROM mtl_onhand_quantities_detail moq

4879: , moq.inventory_item_id inventory_item_id
4880: , moq.subinventory_code subinventory_code
4881: , moq.locator_id locator_id
4882: , moq.primary_transaction_quantity oh_quantity
4883: FROM mtl_onhand_quantities_detail moq
4884: -- to be more conservative ( or simply realistic ) we don't add
4885: -- negative on-hand to the capacity
4886: WHERE moq.transaction_quantity > 0
4887: UNION ALL

Line 5038: FROM mtl_onhand_quantities_detail

5034: SELECT 'Y'
5035: INTO l_return_value
5036: FROM DUAL
5037: WHERE EXISTS( SELECT 'Y'
5038: FROM mtl_onhand_quantities_detail
5039: WHERE organization_id = p_organization_id
5040: AND inventory_item_id = p_inventory_item_id
5041: AND subinventory_code = p_subinventory_code
5042: AND locator_id = p_locator_id);

Line 5069: FROM mtl_onhand_quantities_detail moqdx

5065: END IF;
5066:
5067: SELECT SUM(moqdx.primary_transaction_quantity)
5068: INTO l_return_value
5069: FROM mtl_onhand_quantities_detail moqdx
5070: WHERE moqdx.lpn_id IN (SELECT wlpn1.lpn_id
5071: FROM wms_license_plate_numbers wlpn1
5072: WHERE wlpn1.outermost_lpn_id = p_lpn_id)
5073: AND moqdx.inventory_item_id = p_inventory_item_id

Line 5098: FROM mtl_onhand_quantities_detail moqdx

5094: END IF;
5095:
5096: SELECT SUM(moqdx.primary_transaction_quantity)
5097: INTO l_return_value
5098: FROM mtl_onhand_quantities_detail moqdx
5099: WHERE moqdx.lpn_id IN (SELECT wlpn1.lpn_id
5100: FROM wms_license_plate_numbers wlpn1
5101: WHERE wlpn1.outermost_lpn_id = p_lpn_id)
5102: AND moqdx.inventory_item_id = p_inventory_item_id;

Line 5124: FROM mtl_onhand_quantities_detail moqdx

5120: END IF;
5121:
5122: SELECT COUNT(DISTINCT (moqdx.inventory_item_id)) - 1
5123: INTO l_return_value
5124: FROM mtl_onhand_quantities_detail moqdx
5125: WHERE moqdx.lpn_id IN (SELECT wlpn1.lpn_id
5126: FROM wms_license_plate_numbers wlpn1
5127: WHERE wlpn1.outermost_lpn_id = p_lpn_id);
5128:

Line 5150: FROM mtl_onhand_quantities_detail moqdx

5146: END IF;
5147:
5148: SELECT COUNT(DISTINCT (moqdx.revision)) - 1
5149: INTO l_return_value
5150: FROM mtl_onhand_quantities_detail moqdx
5151: WHERE moqdx.lpn_id IN (SELECT wlpn1.lpn_id
5152: FROM wms_license_plate_numbers wlpn1
5153: WHERE wlpn1.outermost_lpn_id = p_lpn_id)
5154: AND moqdx.inventory_item_id = p_inventory_item_id;

Line 5177: FROM mtl_onhand_quantities_detail moqdx

5173: END IF;
5174:
5175: SELECT COUNT(DISTINCT (moqdx.lot_number)) - 1
5176: INTO l_return_value
5177: FROM mtl_onhand_quantities_detail moqdx
5178: WHERE moqdx.lpn_id IN (SELECT wlpn1.lpn_id
5179: FROM wms_license_plate_numbers wlpn1
5180: WHERE wlpn1.outermost_lpn_id = p_lpn_id)
5181: AND moqdx.inventory_item_id = p_inventory_item_id;

Line 5204: FROM mtl_onhand_quantities_detail moqdx

5200: END IF;
5201:
5202: SELECT SUM(moqdx.primary_transaction_quantity)
5203: INTO l_return_value
5204: FROM mtl_onhand_quantities_detail moqdx
5205: WHERE moqdx.lpn_id = p_lpn_id
5206: AND moqdx.inventory_item_id = p_inventory_item_id
5207: AND NVL(moqdx.revision, '-99') = NVL(p_revision, '-99')
5208: AND NVL(moqdx.lot_number, '-9999') = NVL(p_lot_number, '-9999');

Line 5231: FROM mtl_onhand_quantities_detail moqdx

5227: END IF;
5228:
5229: SELECT SUM(moqdx.primary_transaction_quantity)
5230: INTO l_return_value
5231: FROM mtl_onhand_quantities_detail moqdx
5232: WHERE moqdx.lpn_id = p_lpn_id
5233: AND moqdx.inventory_item_id = p_inventory_item_id;
5234:
5235: RETURN l_return_value;

Line 5255: FROM mtl_onhand_quantities_detail moqdx

5251: END IF;
5252:
5253: SELECT COUNT(DISTINCT (moqdx.inventory_item_id))
5254: INTO l_return_value
5255: FROM mtl_onhand_quantities_detail moqdx
5256: WHERE moqdx.lpn_id = p_lpn_id;
5257:
5258: RETURN l_return_value;
5259: EXCEPTION

Line 5279: FROM mtl_onhand_quantities_detail moqdx

5275: END IF;
5276:
5277: SELECT COUNT(DISTINCT (moqdx.revision))
5278: INTO l_return_value
5279: FROM mtl_onhand_quantities_detail moqdx
5280: WHERE moqdx.lpn_id = p_lpn_id
5281: AND moqdx.inventory_item_id = p_inventory_item_id;
5282:
5283: RETURN l_return_value;

Line 5304: FROM mtl_onhand_quantities_detail moqdx

5300: END IF;
5301:
5302: SELECT COUNT(DISTINCT (moqdx.lot_number))
5303: INTO l_return_value
5304: FROM mtl_onhand_quantities_detail moqdx
5305: WHERE moqdx.lpn_id = p_lpn_id
5306: AND moqdx.inventory_item_id = p_inventory_item_id;
5307:
5308: RETURN l_return_value;

Line 5472: FROM mtl_item_locations mil, mtl_item_locations milx, mtl_onhand_quantities_detail moq

5468: l_pick_order NUMBER;
5469:
5470: CURSOR c_pick_order IS
5471: SELECT MIN(ABS(NVL(milx.picking_order, -9999) - NVL(mil.picking_order, 9999)))
5472: FROM mtl_item_locations mil, mtl_item_locations milx, mtl_onhand_quantities_detail moq
5473: WHERE mil.inventory_location_id = p_locator_id
5474: AND mil.organization_id = p_organization_id
5475: AND moq.organization_id = p_organization_id
5476: AND moq.inventory_item_id = p_inventory_item_id

Line 5536: FROM mtl_item_locations mil, mtl_item_locations milx, mtl_onhand_quantities_detail moq

5532: )
5533: )
5534: )
5535: )
5536: FROM mtl_item_locations mil, mtl_item_locations milx, mtl_onhand_quantities_detail moq
5537: WHERE mil.inventory_location_id = p_locator_id
5538: AND mil.organization_id = p_organization_id
5539: AND moq.organization_id = p_organization_id
5540: AND moq.inventory_item_id = p_inventory_item_id

Line 5584: FROM mtl_onhand_quantities_detail

5580: SELECT COUNT(inventory_item_id)
5581: FROM (SELECT inventory_item_id
5582: FROM (--current onhand
5583: SELECT inventory_item_id
5584: FROM mtl_onhand_quantities_detail
5585: WHERE organization_id = p_organization_id
5586: AND subinventory_code = p_subinventory_code
5587: AND locator_id = p_locator_id
5588: AND inventory_item_id <> p_inventory_item_id

Line 5661: FROM mtl_onhand_quantities_detail

5657: SELECT COUNT(lot_number)
5658: FROM (SELECT lot_number
5659: FROM (--current onhand
5660: SELECT lot_number
5661: FROM mtl_onhand_quantities_detail
5662: WHERE organization_id = p_organization_id
5663: AND inventory_item_id = p_inventory_item_id
5664: AND subinventory_code = p_subinventory_code
5665: AND locator_id = p_locator_id

Line 5769: FROM mtl_onhand_quantities_detail

5765: SELECT COUNT(revision)
5766: FROM (SELECT revision
5767: FROM (--current onhand
5768: SELECT revision
5769: FROM mtl_onhand_quantities_detail
5770: WHERE organization_id = p_organization_id
5771: AND subinventory_code = p_subinventory_code
5772: AND locator_id = p_locator_id
5773: AND inventory_item_id = p_inventory_item_id

Line 6086: FROM mtl_onhand_quantities_detail

6082:
6083: -- This cursor assumes that date_recieved is never null
6084: CURSOR rec_dates IS
6085: SELECT MIN(DECODE(orig_date_received, NULL, date_received, LEAST(date_received, orig_date_received)))
6086: FROM mtl_onhand_quantities_detail
6087: WHERE organization_id = p_org_id
6088: AND inventory_item_id = p_item_id
6089: AND subinventory_code = p_sub
6090: AND NVL(locator_id, -1) = NVL(p_loc_id, NVL(locator_id, -1))

Line 6184: FROM mtl_onhand_quantities_detail moqdx

6180: END IF;
6181:
6182: SELECT SUM(moqdx.secondary_transaction_quantity)
6183: INTO l_return_value
6184: FROM mtl_onhand_quantities_detail moqdx
6185: WHERE moqdx.lpn_id IN (SELECT wlpn1.lpn_id
6186: FROM wms_license_plate_numbers wlpn1
6187: WHERE wlpn1.outermost_lpn_id = p_lpn_id)
6188: AND moqdx.inventory_item_id = p_inventory_item_id;

Line 6211: FROM mtl_onhand_quantities_detail moqdx

6207: END IF;
6208:
6209: SELECT SUM(moqdx.secondary_transaction_quantity)
6210: INTO l_return_value
6211: FROM mtl_onhand_quantities_detail moqdx
6212: WHERE moqdx.lpn_id = p_lpn_id
6213: AND moqdx.inventory_item_id = p_inventory_item_id;
6214:
6215: RETURN l_return_value;