View: PJM_PROJECT_OE_DEMAND_V

Product:	PJM - Project Manufacturing
Description:	Not currently used
Implementation/DBA Data:	APPS.PJM_PROJECT_OE_DEMAND_V

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.END_ITEM_UNIT_NUMBER
, SLP.END_ITEM_UNIT_NUMBER)
FROM MTL_DEMAND DM
, SO_LINES_ALL SL
, SO_LINES_ALL 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