View: MRP_AP_WIP_COMP_SUPPLIES_V

View Text

SELECT WRO.INVENTORY_ITEM_ID
, WRO.ORGANIZATION_ID
, WRO.WIP_ENTITY_ID
, 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
, DECODE( WDJ.JOB_TYPE
, 1
, 14
, 15) ORDER_TYPE
, WDJ.PROJECT_ID
, WDJ.TASK_ID
, MPP.PLANNING_GROUP
, WDJ.END_ITEM_UNIT_NUMBER
, WDJ.DEMAND_CLASS
, NVL(WRO.MPS_REQUIRED_QUANTITY
, 0) MPS_REQUIRED_QUANTITY
, NVL(WRO.REQUIRED_QUANTITY
, 0) REQUIRED_QUANTITY
, NVL(WDJ.QUANTITY_COMPLETED
, 0) QUANTITY_COMPLETED
, WRO.QUANTITY_PER_ASSEMBLY
, WRO.MPS_DATE_REQUIRED
, WDJ.SCHEDULED_COMPLETION_DATE
, WRO.DATE_REQUIRED
, WDJ.SCHEDULED_START_DATE
, WDJ.MPS_NET_QUANTITY
, WDJ.NET_QUANTITY
, WDJ.STATUS_TYPE STATUS_CODE
, WSG.SCHEDULE_GROUP_NAME
, NVL( MPP.RN
, 0) RN5
, WRO.RN RN4
, WDJ.RN RN3
, MSI.RN RN2
, MP.RN RN1
FROM WIP_SCHEDULE_GROUPS WSG
, MRP_AP_PRJ_PARAS_SN MPP
, MRP_AP_WREQ_OPRS_SN WRO
, MRP_AP_MRP_PARAS_SN MP
, MRP_AP_SYS_ITEMS_SN MSI
, MRP_AP_DSCR_JOBS_SN WDJ
WHERE SIGN(WRO.REQUIRED_QUANTITY) <> 1
AND WRO.ORGANIZATION_ID= MP.ORGANIZATION_ID
AND MSI.ORGANIZATION_ID= WRO.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID= WRO.INVENTORY_ITEM_ID
AND WSG.SCHEDULE_GROUP_ID(+)= WDJ.SCHEDULE_GROUP_ID
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.ORGANIZATION_ID = WDJ.ORGANIZATION_ID
AND WRO.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID

Columns