[Home] [Help]
| Product: | MRP - Master Scheduling/MRP |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT MSD.MPS_TRANSACTION_ID DISPOSITION_ID
, MSD.INVENTORY_ITEM_ID
, MSD.ORGANIZATION_ID
, MSD.SCHEDULE_DESIGNATOR
, MSD.SCHEDULE_DATE
, MSD.SCHEDULE_WORKDATE
, MSD.RATE_END_DATE
, MSD.SCHEDULE_QUANTITY
, MSD.ORIGINAL_SCHEDULE_QUANTITY
, MSD.REPETITIVE_DAILY_RATE
, MSD.SCHEDULE_ORIGINATION_TYPE
, MSD.SOURCE_FORECAST_DESIGNATOR
, MSD.REFERENCE_SCHEDULE_ID
, MSD.SCHEDULE_COMMENTS
, MSD.SOURCE_ORGANIZATION_ID
, MSD.SOURCE_SCHEDULE_DESIGNATOR
, MSD.SOURCE_SALES_ORDER_ID
, MSD.SOURCE_CODE
, MSD.SOURCE_LINE_ID
, MSD.RESERVATION_ID
, MSD.FORECAST_ID
, MSD.PROJECT_ID
, MSD.TASK_ID
, MSD.LINE_ID
, MSD.END_ITEM_UNIT_NUMBER
, 5 ORDER_TYPE
, 1 FIRM_PLANNED_TYPE
, MPP.PLANNING_GROUP
, NVL( MPP.RN
, 0) RN4
, MSD.RN RN3
, MSI.RN RN2
, MP.RN RN1
FROM MRP_AP_PRJ_PARAS_SN MPP
, MRP_AP_MRP_PARAS_SN MP
, MRP_AP_SYS_ITEMS_SN MSI
, MRP_AP_SCHD_DSGS_SN MSDS
, MRP_AP_SCHD_DATES_SN MSD
WHERE MSD.INVENTORY_ITEM_ID= MSI.INVENTORY_ITEM_ID
AND MSD.ORGANIZATION_ID= MSI.ORGANIZATION_ID
AND MSD.ORGANIZATION_ID= MP.ORGANIZATION_ID
AND MPP.ORGANIZATION_ID(+)= MSD.ORGANIZATION_ID
AND MPP.PROJECT_ID(+)= MSD.PROJECT_ID
AND MSDS.SCHEDULE_TYPE= 2
AND MSDS.ORGANIZATION_ID= MSD.ORGANIZATION_ID
AND MSDS.DESIGNATOR= MSD.SCHEDULE_DESIGNATOR
AND MSD.SUPPLY_DEMAND_TYPE= 2