View: MTL_RESERVATIONS_V

Product:	INV - Inventory
Description:	10SC ONLY
Implementation/DBA Data:	APPS.MTL_RESERVATIONS_V

View Text

SELECT M.ROWID ROW_ID
, M.DEMAND_ID
, M.ORGANIZATION_ID
, M.INVENTORY_ITEM_ID
, MSIK.PADDED_CONCATENATED_SEGMENTS
, MSIK.DESCRIPTION DESCRIPTION
, M.REQUIREMENT_DATE
, MTST.TRANSACTION_SOURCE_TYPE_NAME SOURCE_TYPE
, MTST.TRANSACTION_SOURCE_TYPE_ID SOURCE_TYPE_ID
, MTST.DESCRIPTIVE_FLEX_CONTEXT_CODE
, M.DEMAND_SOURCE_HEADER_ID SOURCE_ID
, M.DEMAND_SOURCE_LINE
, M.DEMAND_SOURCE_NAME SOURCE_NAME
, M.UOM_CODE UOM
, MSIK.PRIMARY_UOM_CODE PUOM
, M.LINE_ITEM_QUANTITY RSV_QUANTITY
, M.COMPLETED_QUANTITY PUOM_ISSUED_QUANTITY
, (M.PRIMARY_UOM_QUANTITY - M.COMPLETED_QUANTITY) PUOM_QUANTITY
, M.REVISION
, M.LOT_NUMBER LOT
, M.SUBINVENTORY SUB
, M.LOCATOR_ID
, M.ATTRIBUTE_CATEGORY
, M.ATTRIBUTE1
, M.ATTRIBUTE2
, M.ATTRIBUTE3
, M.ATTRIBUTE4
, M.ATTRIBUTE5
, M.ATTRIBUTE6
, M.ATTRIBUTE7
, M.ATTRIBUTE8
, M.ATTRIBUTE9
, M.ATTRIBUTE10
, M.ATTRIBUTE11
, M.ATTRIBUTE12
, M.ATTRIBUTE13
, M.ATTRIBUTE14
, M.ATTRIBUTE15
, M.LAST_UPDATE_DATE
, M.LAST_UPDATED_BY
, M.CREATION_DATE
, M.CREATED_BY
, M.LAST_UPDATE_LOGIN
, M.PARENT_DEMAND_ID
, M.USER_LINE_NUM
FROM MTL_DEMAND M
, MTL_SYSTEM_ITEMS_KFV MSIK
, MTL_TXN_SOURCE_TYPES MTST
WHERE M.ORGANIZATION_ID = MSIK.ORGANIZATION_ID
AND M.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID
AND M.RESERVATION_TYPE = 2
AND (M.PRIMARY_UOM_QUANTITY-M.COMPLETED_QUANTITY) > 0
AND M.DEMAND_SOURCE_TYPE = MTST.TRANSACTION_SOURCE_TYPE_ID

Columns