View: MTL_ATT_QTY_V

Product:	INV - Inventory
Description:	No longer used
Implementation/DBA Data:	APPS.MTL_ATT_QTY_V

View Text

SELECT 1 TYPE
, MOQ.INVENTORY_ITEM_ID
, MOQ.ORGANIZATION_ID
, MOQ.REVISION
, MOQ.SUBINVENTORY_CODE
, MOQ.LOCATOR_ID
, MOQ.TRANSACTION_QUANTITY
, MOQ.LOT_NUMBER
FROM MTL_ONHAND_QUANTITIES MOQ
, MTL_LOT_NUMBERS MLN
WHERE MLN.LOT_NUMBER (+) = MOQ.LOT_NUMBER
AND MLN.INVENTORY_ITEM_ID (+) = MOQ.INVENTORY_ITEM_ID
AND MLN.ORGANIZATION_ID (+) = MOQ.ORGANIZATION_ID UNION ALL SELECT 2
, MMTT.INVENTORY_ITEM_ID
, MMTT.ORGANIZATION_ID
, MMTT.REVISION
, MMTT.SUBINVENTORY_CODE
, MMTT.LOCATOR_ID
, NVL(MTLT.PRIMARY_QUANTITY
, MMTT.PRIMARY_QUANTITY)
, NVL(MTLT.LOT_NUMBER
, MMTT.LOT_NUMBER)
FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
, MTL_TRANSACTION_LOTS_TEMP MTLT
WHERE MTLT.TRANSACTION_TEMP_ID (+) = MMTT.TRANSACTION_TEMP_ID
AND NVL(MTLT.LOT_EXPIRATION_DATE
, NVL(MMTT.LOT_EXPIRATION_DATE
, SYSDATE+1)) > SYSDATE
AND MMTT.POSTING_FLAG = 'Y' UNION ALL SELECT 7
, MD.INVENTORY_ITEM_ID
, MD.ORGANIZATION_ID
, MD.REVISION
, MD.SUBINVENTORY
, MD.LOCATOR_ID
, -(NVL(MD.PRIMARY_UOM_QUANTITY
, 0)-NVL(COMPLETED_QUANTITY
, 0))
, MD.LOT_NUMBER
FROM MTL_DEMAND MD
, MTL_LOT_NUMBERS MLN
WHERE MLN.LOT_NUMBER (+) = MD.LOT_NUMBER
AND MLN.INVENTORY_ITEM_ID (+) = MD.INVENTORY_ITEM_ID
AND MLN.ORGANIZATION_ID (+) = MD.ORGANIZATION_ID
AND NVL(MLN.EXPIRATION_DATE
, SYSDATE+1) > SYSDATE
AND MD.RESERVATION_TYPE = 2
AND MD.PARENT_DEMAND_ID IS NOT NULL
AND MD.ROW_STATUS_FLAG = 1

Columns