Product: | MRP - Master Scheduling/MRP |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT MAWJV.INVENTORY_ITEM_ID
, MAWJV.ORGANIZATION_ID
, MAWJV.WIP_ENTITY_ID
, MAWJV.WIP_ENTITY_NAME
, MAWJV.QUANTITY_SCRAPPED
, MAWJV.QUANTITY_COMPLETED
, MAWJV.FIRM_PLANNED_STATUS_TYPE
, MAWJV.START_DATE
, MAWJV.REVISION
, MAWJV.STATUS_CODE
, MAWJV.WIP_JOB_TYPE
, DECODE( MAWJV.ENTITY_TYPE
, 4
, 27
, DECODE( MAWJV.WIP_JOB_TYPE
, 1
, 3
, 7)) ORDER_TYPE
, MAWJV.PROJECT_ID
, MAWJV.TASK_ID
, MPP.PLANNING_GROUP
, MAWJV.SCHEDULE_GROUP_ID
, MAWJV.BUILD_SEQUENCE
, MAWJV.LINE_ID
, MAWJV.ALTERNATE_BOM_DESIGNATOR
, MAWJV.ALTERNATE_ROUTING_DESIGNATOR
, MAWJV.END_ITEM_UNIT_NUMBER
, MAWJV.SCHEDULE_GROUP_NAME
, MAWJV.SCHEDULED_COMPLETION_DATE
, MAWJV.DEMAND_CLASS
, MAWJV.MPS_NET_QUANTITY
, MAWJV.NET_QUANTITY
, MAWJV.MPS_EXPECTED_SCRAP_QUANTITY
, MAWJV.EXPECTED_SCRAP_QUANTITY
, MAWJV.MPS_JOB_QUANTITY
, MAWJV.JOB_QUANTITY
, MAWJV.MPS_SCHEDULED_COMPLETION_DATE
, NVL(MPP.RN
, 0) RN4
, MAWJV.RN3 RN3
, MAWJV.RN2 RN2
, MAWJV.RN1 RN1
FROM MRP_AP_PRJ_PARAS_SN MPP
, MRP_AP_WIP_JOBS_V MAWJV
WHERE MPP.PROJECT_ID(+)= MAWJV.PROJECT_ID
AND MPP.ORGANIZATION_ID(+) = MAWJV.ORGANIZATION_ID