View: INVBV_INVENTORY_RESERVATIONS

Product:	INV - Inventory
Description:	- Retrofitted
Implementation/DBA Data:	APPS.INVBV_INVENTORY_RESERVATIONS

View Text

SELECT M.DEMAND_ID
, M.ORGANIZATION_ID
, M.INVENTORY_ITEM_ID
, M.REQUIREMENT_DATE
, M.DEMAND_SOURCE_TYPE
, M.DEMAND_SOURCE_HEADER_ID
, DECODE (M.DEMAND_SOURCE_TYPE
, 2
, M.DEMAND_SOURCE_HEADER_ID
, 8
, M.DEMAND_SOURCE_HEADER_ID
, 12
, M.DEMAND_SOURCE_HEADER_ID
, NULL) SALES_ORDER_ID
, DECODE (M.DEMAND_SOURCE_TYPE
, 3
, M.DEMAND_SOURCE_HEADER_ID
, NULL) ACCOUNT_ID
, DECODE (M.DEMAND_SOURCE_TYPE
, 6
, M.DEMAND_SOURCE_HEADER_ID
, NULL) ACCOUNT_ALIAS_ID
, DECODE (M.DEMAND_SOURCE_TYPE
, 2
, NULL
, 3
, NULL
, 6
, NULL
, 8
, NULL
, 12
, NULL
, M.DEMAND_SOURCE_NAME)
, M.UOM_CODE UOM
, M.LINE_ITEM_QUANTITY RESERVED_QUANTITY
, (M.COMPLETED_QUANTITY * (INV_CONVERT.INV_UM_CONVERT(M.INVENTORY_ITEM_ID
, 5
, 1
, MSI.PRIMARY_UOM_CODE
, M.UOM_CODE
, NULL
, NULL))) ISSUED_QUANTITY
, (M.LINE_ITEM_QUANTITY - (M.COMPLETED_QUANTITY * (INV_CONVERT.INV_UM_CONVERT(M.INVENTORY_ITEM_ID
, 5
, 1
, MSI.PRIMARY_UOM_CODE
, M.UOM_CODE
, NULL
, NULL)))) PENDING_ISSUE_QUANTITY
, M.REVISION
, M.LOT_NUMBER
, M.SUBINVENTORY
, M.LOCATOR_ID
, M.USER_LINE_NUM
, M.CREATED_BY
, M.CREATION_DATE
, M.LAST_UPDATED_BY
, M.LAST_UPDATE_DATE
FROM MTL_SYSTEM_ITEMS MSI
, MTL_DEMAND M
WHERE MSI.ORGANIZATION_ID = M.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = M.INVENTORY_ITEM_ID
AND M.RESERVATION_TYPE = 2
AND (M.PRIMARY_UOM_QUANTITY-M.COMPLETED_QUANTITY) > 0
AND (M.DEMAND_SOURCE_TYPE IN (2
, 8
, 12
, 3
, 6
, 13) OR M.DEMAND_SOURCE_TYPE > 99)
AND '_SEC:M.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns