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 5458: FROM mtl_item_locations mil, mtl_item_locations milx, mtl_onhand_quantities_detail moq

5454: l_pick_order NUMBER;
5455:
5456: CURSOR c_pick_order IS
5457: SELECT MIN(ABS(NVL(milx.picking_order, -9999) - NVL(mil.picking_order, 9999)))
5458: FROM mtl_item_locations mil, mtl_item_locations milx, mtl_onhand_quantities_detail moq
5459: WHERE mil.inventory_location_id = p_locator_id
5460: AND mil.organization_id = p_organization_id
5461: AND moq.organization_id = p_organization_id
5462: AND moq.inventory_item_id = p_inventory_item_id

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

5518: )
5519: )
5520: )
5521: )
5522: FROM mtl_item_locations mil, mtl_item_locations milx, mtl_onhand_quantities_detail moq
5523: WHERE mil.inventory_location_id = p_locator_id
5524: AND mil.organization_id = p_organization_id
5525: AND moq.organization_id = p_organization_id
5526: AND moq.inventory_item_id = p_inventory_item_id

Line 5570: FROM mtl_onhand_quantities_detail

5566: SELECT COUNT(inventory_item_id)
5567: FROM (SELECT inventory_item_id
5568: FROM (--current onhand
5569: SELECT inventory_item_id
5570: FROM mtl_onhand_quantities_detail
5571: WHERE organization_id = p_organization_id
5572: AND subinventory_code = p_subinventory_code
5573: AND locator_id = p_locator_id
5574: AND inventory_item_id <> p_inventory_item_id

Line 5647: FROM mtl_onhand_quantities_detail

5643: SELECT COUNT(lot_number)
5644: FROM (SELECT lot_number
5645: FROM (--current onhand
5646: SELECT lot_number
5647: FROM mtl_onhand_quantities_detail
5648: WHERE organization_id = p_organization_id
5649: AND inventory_item_id = p_inventory_item_id
5650: AND subinventory_code = p_subinventory_code
5651: AND locator_id = p_locator_id

Line 5755: FROM mtl_onhand_quantities_detail

5751: SELECT COUNT(revision)
5752: FROM (SELECT revision
5753: FROM (--current onhand
5754: SELECT revision
5755: FROM mtl_onhand_quantities_detail
5756: WHERE organization_id = p_organization_id
5757: AND subinventory_code = p_subinventory_code
5758: AND locator_id = p_locator_id
5759: AND inventory_item_id = p_inventory_item_id

Line 6072: FROM mtl_onhand_quantities_detail

6068:
6069: -- This cursor assumes that date_recieved is never null
6070: CURSOR rec_dates IS
6071: SELECT MIN(DECODE(orig_date_received, NULL, date_received, LEAST(date_received, orig_date_received)))
6072: FROM mtl_onhand_quantities_detail
6073: WHERE organization_id = p_org_id
6074: AND inventory_item_id = p_item_id
6075: AND subinventory_code = p_sub
6076: AND NVL(locator_id, -1) = NVL(p_loc_id, NVL(locator_id, -1))