VIEW: APPS.PJM_PROJECT_OE_DEMAND_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)