View: MRP_AP_REPT_ITEM_SUPPLIES_V

View Text

SELECT X.PRIMARY_ITEM_ID
, X.ORGANIZATION_ID
, X.WIP_ENTITY_ID
, X.REPETITIVE_SCHEDULE_ID
, X.LINE_ID
, X.FIRST_UNIT_START_DATE
, X.FIRST_UNIT_COMPLETION_DATE
, X.LAST_UNIT_START_DATE
, X.LAST_UNIT_COMPLETION_DATE
, X.PROCESSING_WORK_DAYS
, X.DAILY_PRODUCTION_RATE
, X.BOM_REVISION
, X.STATUS_TYPE STATUS_CODE
, X.FIRM_PLANNED_FLAG
, X.QUANTITY_COMPLETED
, X.FULL_LEAD_TIME
, NVL(WO.QUANTITY_SCRAPPED
, 0) QUANTITY_SCRAPPED
, WO.OPERATION_SEQ_NUM
, X.DEMAND_CLASS
, NVL(WO.RN
, 0) RN5
, X.RN4 RN4
, X.RN3 RN3
, X.RN2 RN2
, X.RN1 RN1
FROM MRP_AP_WOPRS_SN WO
, ( SELECT WRI.PRIMARY_ITEM_ID
, WRI.ORGANIZATION_ID
, WRS.WIP_ENTITY_ID
, WRS.REPETITIVE_SCHEDULE_ID
, WRS.LINE_ID
, WRS.FIRST_UNIT_START_DATE
, WRS.FIRST_UNIT_COMPLETION_DATE
, WRS.LAST_UNIT_START_DATE
, WRS.LAST_UNIT_COMPLETION_DATE
, WRS.PROCESSING_WORK_DAYS
, WRS.DAILY_PRODUCTION_RATE
, WRS.BOM_REVISION
, WRS.STATUS_TYPE
, WRS.FIRM_PLANNED_FLAG
, NVL(WRS.QUANTITY_COMPLETED
, 0) QUANTITY_COMPLETED
, WRS.DEMAND_CLASS
, MSI.FULL_LEAD_TIME
, WRI.RN RN4
, WRI.RN RN3
, MSI.RN RN2
, MP.RN RN1
FROM MRP_AP_SYS_ITEMS_SN MSI
, MRP_AP_MRP_PARAS_SN MP
, MRP_AP_REPT_ITEMS_SN WRI
, MRP_AP_REPT_SCHDS_SN WRS
WHERE WRI.WIP_ENTITY_ID = WRS.WIP_ENTITY_ID
AND WRI.ORGANIZATION_ID = WRS.ORGANIZATION_ID
AND WRI.LINE_ID = WRS.LINE_ID
AND WRI.ORGANIZATION_ID= MP.ORGANIZATION_ID
AND MSI.ORGANIZATION_ID = WRI.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = WRI.PRIMARY_ITEM_ID ) X
WHERE WO.REPETITIVE_SCHEDULE_ID(+) = X.REPETITIVE_SCHEDULE_ID
AND WO.ORGANIZATION_ID(+) = X.ORGANIZATION_ID

Columns