View: MRP_AP_MDS_DEMANDS_V

View Text

SELECT MSD.INVENTORY_ITEM_ID
, MSD.ORGANIZATION_ID
, MSD.INVENTORY_ITEM_ID USING_ASSEMBLY_ID
, DECODE( MSD.RATE_END_DATE
, NULL
, MSD.SCHEDULE_QUANTITY
, MSD.REPETITIVE_DAILY_RATE) USING_REQUIREMENTS_QUANTITY
, MSD.RATE_END_DATE ASSEMBLY_DEMAND_COMP_DATE
, DECODE( MSD.RATE_END_DATE
, NULL
, 1
, 2) DEMAND_TYPE
, MSD.REPETITIVE_DAILY_RATE DAILY_DEMAND_RATE
, DECODE( MSD.SCHEDULE_ORIGINATION_TYPE
, 1
, 8
, 3
, 6
, 2
, 7
, 8
, 7
, 4
, 15
, 11
, 24
, 7
, 8
, NULL) ORIGINATION_TYPE
, DECODE( MSD.SCHEDULE_ORIGINATION_TYPE
, 11
, MSD.SOURCE_ORGANIZATION_ID
, NULL) SOURCE_ORGANIZATION_ID
, MSD.MPS_TRANSACTION_ID DISPOSITION_ID
, MSD.RESERVATION_ID
, MSD.SCHEDULE_DESIGNATOR DEMAND_SCHEDULE_NAME
, DECODE( MSO.SEGMENT1
, NULL
, NULL
, MSO.SEGMENT1||':'||SEGMENT2||':'||SEGMENT3) SALES_ORDER_NUMBER
, MSD.PROJECT_ID
, MSD.TASK_ID
, MPP.PLANNING_GROUP
, MSD.END_ITEM_UNIT_NUMBER
, MSD.RATE_END_DATE
, MSD.SCHEDULE_DATE
, MSD.SCHEDULE_WORKDATE
, MSD.SCHEDULE_ORIGINATION_TYPE
, NVL( MPP.RN
, 0) RN4
, MSD.RN RN3
, MSIK.RN RN2
, MP.RN RN1
FROM MRP_AP_MRP_PARAS_SN MP
, MRP_AP_SYS_ITEMS_SN MSIK
, MRP_AP_PRJ_PARAS_SN MPP
, MTL_SALES_ORDERS MSO
, MRP_AP_SCHD_DSGS_SN MSDS
, MRP_AP_SCHD_DATES_SN MSD
WHERE MSD.SUPPLY_DEMAND_TYPE= 1
AND MSDS.SCHEDULE_TYPE= 1
AND MSDS.ORGANIZATION_ID= MSD.ORGANIZATION_ID
AND MSDS.DESIGNATOR= MSD.SCHEDULE_DESIGNATOR
AND MSO.SALES_ORDER_ID(+)= MSD.SOURCE_SALES_ORDER_ID
AND MPP.ORGANIZATION_ID(+)= MSD.ORGANIZATION_ID
AND MPP.PROJECT_ID(+)= MSD.PROJECT_ID
AND MSD.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID
AND MSD.ORGANIZATION_ID = MSIK.ORGANIZATION_ID
AND MSD.ORGANIZATION_ID = MP.ORGANIZATION_ID

Columns