View: MTL_PROJECT_DEMAND_VIEW

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

View Text

SELECT DM.INVENTORY_ITEM_ID
, DM.ORGANIZATION_ID
, DM.REVISION
, DM.DEMAND_SOURCE_HEADER_ID
, DM.DEMAND_SOURCE_LINE
, DM.DEMAND_SOURCE_TYPE
, DM.DEMAND_SOURCE_DELIVERY
, DM.DEMAND_ID
, DM.PARENT_DEMAND_ID
, DM.DEMAND_CLASS
, DM.SUBINVENTORY
, DM.MRP_DATE
, DM.REQUIREMENT_DATE
, DM.MRP_QUANTITY
, DM.PRIMARY_UOM_QUANTITY
, DM.COMPLETED_QUANTITY
, DM.RESERVATION_QUANTITY
, DM.AVAILABLE_TO_MRP
, DM.RESERVATION_TYPE
, DM.USER_LINE_NUM
, DM.CUSTOMER_ID
, DM.BILL_TO_SITE_USE_ID
, DM.SHIP_TO_SITE_USE_ID
, DM.RTO_MODEL_SOURCE_LINE
, DM.UPDATED_FLAG
, NVL(SL.PROJECT_ID
, SLP.PROJECT_ID)
, NVL(SL.TASK_ID
, SLP.TASK_ID)
, NVL(SL.UNIT_NUMBER
, SLP.UNIT_NUMBER)
FROM MTL_DEMAND DM
, PJM_UEFF_SO_LINES_V SL
, PJM_UEFF_SO_LINES_V SLP
WHERE DM.DEMAND_SOURCE_TYPE IN (2
, 8)
AND TO_NUMBER(DM.DEMAND_SOURCE_LINE) = SL.LINE_ID (+)
AND SLP.LINE_ID (+) = NVL(SL.PARENT_LINE_ID
, SL.LINE_ID)

Columns