View: INVBV_INVENTORY_DEMANDS

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

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 DEMANDED_QUANTITY
, M.LINE_ITEM_RESERVATION_QTY RESERVED_QUANTITY
, M.REVISION
, M.LOT_NUMBER
, M.SUBINVENTORY
, M.LOCATOR_ID
, M.CREATED_BY
, M.CREATION_DATE
, M.LAST_UPDATED_BY
, M.LAST_UPDATE_DATE
FROM MTL_DEMAND M
WHERE M.RESERVATION_TYPE = 1
AND M.PARENT_DEMAND_ID IS NULL
AND (M.LINE_ITEM_QUANTITY - M.LINE_ITEM_RESERVATION_QTY) > 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