View: MRP_AP_WIP_COMP_DEMANDS_V

View Text

SELECT WRO.INVENTORY_ITEM_ID
, WRO.ORGANIZATION_ID
, WRO.WIP_ENTITY_ID
, WE.WIP_ENTITY_NAME
, WRO.OPERATION_SEQ_NUM
, NVL(WRO.QUANTITY_ISSUED
, 0) QUANTITY_ISSUED
, NVL( WDJ.PRIMARY_ITEM_ID
, WRO.INVENTORY_ITEM_ID) JOB_REFERENCE_ITEM_ID
, WDJ.JOB_TYPE
, WDJ.PROJECT_ID
, WDJ.TASK_ID
, MPP.PLANNING_GROUP
, WDJ.END_ITEM_UNIT_NUMBER
, WDJ.DEMAND_CLASS
, DECODE( WDJ.JOB_TYPE
, 1
, 3
, 2) ORIGINATION_TYPE
, WRO.DATE_REQUIRED
, WRO.MPS_DATE_REQUIRED
, WRO.MPS_REQUIRED_QUANTITY
, WRO.REQUIRED_QUANTITY
, WRO.QUANTITY_PER_ASSEMBLY
, WDJ.SCHEDULED_START_DATE
, WDJ.QUANTITY_COMPLETED
, WDJ.NET_QUANTITY
, WDJ.MPS_NET_QUANTITY
, NVL( MPP.RN
, 0) RN5
, WDJ.RN RN4
, WRO.RN RN3
, MSIK.RN RN2
, MP.RN RN1
FROM WIP_ENTITIES WE
, MRP_AP_PRJ_PARAS_SN MPP
, MRP_AP_DSCR_JOBS_SN WDJ
, MRP_AP_MRP_PARAS_SN MP
, MRP_AP_SYS_ITEMS_SN MSIK
, MRP_AP_WREQ_OPRS_SN WRO
WHERE WE.WIP_ENTITY_ID= WDJ.WIP_ENTITY_ID
AND SIGN(WRO.REQUIRED_QUANTITY) = 1
AND MPP.PROJECT_ID (+) = WDJ.PROJECT_ID
AND MPP.ORGANIZATION_ID (+) = WDJ.ORGANIZATION_ID
AND DECODE( WDJ.JOB_TYPE
, 1
, DECODE( SIGN(NVL(WRO.MPS_REQUIRED_QUANTITY
, 1))
, 1
, WRO.MRP_NET_FLAG
, 1)
, WRO.MRP_NET_FLAG) = 1
AND WRO.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID
AND WRO.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID
AND WRO.ORGANIZATION_ID = MSIK.ORGANIZATION_ID
AND WRO.ORGANIZATION_ID= MP.ORGANIZATION_ID

Columns