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.

VIEW: APPS.MTL_ONHAND_NET

Source

View Text - Preformatted


SELECT moq.inventory_item_id, moq.organization_id, moq.date_received, moq.primary_transaction_quantity, moq.secondary_transaction_quantity, moq.subinventory_code, moq.revision, moq.locator_id, moq.lot_number, moq.lpn_id, moq.planning_tp_type, moq.planning_organization_id FROM mtl_onhand_quantities_detail moq, mtl_secondary_inventories msi, mtl_parameters mp WHERE ((mp.default_status_id is null and moq.organization_id = mp.organization_id AND ((moq.lot_number IS NOT NULL AND EXISTS (SELECT 1 FROM mtl_lot_numbers mln WHERE mln.lot_number = moq.lot_number AND mln.organization_id = moq.organization_id AND nvl(mln.availability_type, 1) = 1)) OR moq.lot_number IS NULL) AND((moq.locator_id IS NOT NULL AND EXISTS (SELECT 1 FROM mtl_item_locations mil WHERE mil.inventory_location_id = moq.locator_id AND mil.organization_id = moq.organization_id AND nvl(mil.availability_type, 1) = 1)) OR moq.locator_id IS NULL) AND(msi.secondary_inventory_name = moq.subinventory_code AND msi.organization_id = moq.organization_id AND msi.availability_type = 1) ) OR (mp.default_status_id IS NOT NULL and moq.organization_id = mp.organization_id and moq.organization_id = msi.organization_id and moq.subinventory_code = msi.secondary_inventory_name AND ((moq.status_id IS NOT NULL AND EXISTS (SELECT 1 FROM mtl_material_statuses mms WHERE status_id = moq.status_id and mms.availability_type = 1 )) OR moq.status_id IS NULL) ))

View Text - HTML Formatted

SELECT MOQ.INVENTORY_ITEM_ID
, MOQ.ORGANIZATION_ID
, MOQ.DATE_RECEIVED
, MOQ.PRIMARY_TRANSACTION_QUANTITY
, MOQ.SECONDARY_TRANSACTION_QUANTITY
, MOQ.SUBINVENTORY_CODE
, MOQ.REVISION
, MOQ.LOCATOR_ID
, MOQ.LOT_NUMBER
, MOQ.LPN_ID
, MOQ.PLANNING_TP_TYPE
, MOQ.PLANNING_ORGANIZATION_ID
FROM MTL_ONHAND_QUANTITIES_DETAIL MOQ
, MTL_SECONDARY_INVENTORIES MSI
, MTL_PARAMETERS MP
WHERE ((MP.DEFAULT_STATUS_ID IS NULL
AND MOQ.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND ((MOQ.LOT_NUMBER IS NOT NULL
AND EXISTS (SELECT 1
FROM MTL_LOT_NUMBERS MLN
WHERE MLN.LOT_NUMBER = MOQ.LOT_NUMBER
AND MLN.ORGANIZATION_ID = MOQ.ORGANIZATION_ID
AND NVL(MLN.AVAILABILITY_TYPE
, 1) = 1)) OR MOQ.LOT_NUMBER IS NULL) AND((MOQ.LOCATOR_ID IS NOT NULL
AND EXISTS (SELECT 1
FROM MTL_ITEM_LOCATIONS MIL
WHERE MIL.INVENTORY_LOCATION_ID = MOQ.LOCATOR_ID
AND MIL.ORGANIZATION_ID = MOQ.ORGANIZATION_ID
AND NVL(MIL.AVAILABILITY_TYPE
, 1) = 1)) OR MOQ.LOCATOR_ID IS NULL) AND(MSI.SECONDARY_INVENTORY_NAME = MOQ.SUBINVENTORY_CODE
AND MSI.ORGANIZATION_ID = MOQ.ORGANIZATION_ID
AND MSI.AVAILABILITY_TYPE = 1) ) OR (MP.DEFAULT_STATUS_ID IS NOT NULL
AND MOQ.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND MOQ.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND MOQ.SUBINVENTORY_CODE = MSI.SECONDARY_INVENTORY_NAME
AND ((MOQ.STATUS_ID IS NOT NULL
AND EXISTS (SELECT 1
FROM MTL_MATERIAL_STATUSES MMS
WHERE STATUS_ID = MOQ.STATUS_ID
AND MMS.AVAILABILITY_TYPE = 1 )) OR MOQ.STATUS_ID IS NULL) ))