View: MRP_DAILY_SCHEDULES_V

Product:	MRP - Master Scheduling/MRP
Description:	Daily bucketed master schedule entries
Implementation/DBA Data:	APPS.MRP_DAILY_SCHEDULES_V

View Text

SELECT MRSDA.ORGANIZATION_ID
, MRSDA.SCHEDULE_DESIGNATOR
, MRSDA.INVENTORY_ITEM_ID
, CAL.PRIOR_DATE
, DECODE(MRSDA.REPETITIVE_DAILY_RATE
, NULL
, CAL.CALENDAR_DATE
, CAL.PRIOR_DATE)
, NVL(SUM(DECODE(MSI.REPETITIVE_PLANNING_FLAG
, 'Y'
, MRSDA.REPETITIVE_DAILY_RATE
, MRSDA.SCHEDULE_QUANTITY))
, 0)
, NVL(SUM(NVL(MRSDA.ORIGINAL_SCHEDULE_QUANTITY
, DECODE(MSI.REPETITIVE_PLANNING_FLAG
, 'Y'
, MRSDA.REPETITIVE_DAILY_RATE
, MRSDA.SCHEDULE_QUANTITY)))
, 0)
, MRSDA.SCHEDULE_LEVEL
, /* ORIG: SALES ORDER */ DECODE(MRSDA.SCHEDULE_ORIGINATION_TYPE
, 3
, NVL(SUM(DECODE(MSI.REPETITIVE_PLANNING_FLAG
, 'Y'
, MRSDA.REPETITIVE_DAILY_RATE
, MRSDA.SCHEDULE_QUANTITY))
, 0)
, 0)
, DECODE(MRSDA.SCHEDULE_ORIGINATION_TYPE
, 3
, NVL(SUM(NVL(MRSDA.ORIGINAL_SCHEDULE_QUANTITY
, DECODE(MSI.REPETITIVE_PLANNING_FLAG
, 'Y'
, MRSDA.REPETITIVE_DAILY_RATE
, MRSDA.SCHEDULE_QUANTITY)))
, 0)
, 0)
, /* ORIG: FORECAST */ DECODE(MRSDA.SCHEDULE_ORIGINATION_TYPE
, 2
, NVL(SUM(DECODE(MSI.REPETITIVE_PLANNING_FLAG
, 'Y'
, MRSDA.REPETITIVE_DAILY_RATE
, MRSDA.SCHEDULE_QUANTITY))
, 0)
, 0)
, DECODE(MRSDA.SCHEDULE_ORIGINATION_TYPE
, 2
, NVL(SUM(NVL(MRSDA.ORIGINAL_SCHEDULE_QUANTITY
, DECODE(MSI.REPETITIVE_PLANNING_FLAG
, 'Y'
, MRSDA.REPETITIVE_DAILY_RATE
, MRSDA.SCHEDULE_QUANTITY)))
, 0)
, 0)
, /* ORIG: MPS PLAN */ DECODE(MRSDA.SCHEDULE_ORIGINATION_TYPE
, 6
, NVL(SUM(DECODE(MSI.REPETITIVE_PLANNING_FLAG
, 'Y'
, MRSDA.REPETITIVE_DAILY_RATE
, MRSDA.SCHEDULE_QUANTITY))
, 0)
, 0)
, DECODE(MRSDA.SCHEDULE_ORIGINATION_TYPE
, 6
, NVL(SUM(NVL(MRSDA.ORIGINAL_SCHEDULE_QUANTITY
, DECODE(MSI.REPETITIVE_PLANNING_FLAG
, 'Y'
, MRSDA.REPETITIVE_DAILY_RATE
, MRSDA.SCHEDULE_QUANTITY)))
, 0)
, 0)
, /* ORIG: COPIED SCHEDULE */ DECODE(MRSDA.SCHEDULE_ORIGINATION_TYPE
, 4
, NVL(SUM(DECODE(MSI.REPETITIVE_PLANNING_FLAG
, 'Y'
, MRSDA.REPETITIVE_DAILY_RATE
, MRSDA.SCHEDULE_QUANTITY))
, 0)
, 0)
, DECODE(MRSDA.SCHEDULE_ORIGINATION_TYPE
, 4
, NVL(SUM(NVL(MRSDA.ORIGINAL_SCHEDULE_QUANTITY
, DECODE(MSI.REPETITIVE_PLANNING_FLAG
, 'Y'
, MRSDA.REPETITIVE_DAILY_RATE
, MRSDA.SCHEDULE_QUANTITY)))
, 0)
, 0)
, /* ORIG: INTERORG */ DECODE(MRSDA.SCHEDULE_ORIGINATION_TYPE
, 11
, NVL(SUM(DECODE(MSI.REPETITIVE_PLANNING_FLAG
, 'Y'
, MRSDA.REPETITIVE_DAILY_RATE
, MRSDA.SCHEDULE_QUANTITY))
, 0)
, 0)
, DECODE(MRSDA.SCHEDULE_ORIGINATION_TYPE
, 11
, NVL(SUM(NVL(MRSDA.ORIGINAL_SCHEDULE_QUANTITY
, DECODE(MSI.REPETITIVE_PLANNING_FLAG
, 'Y'
, MRSDA.REPETITIVE_DAILY_RATE
, MRSDA.SCHEDULE_QUANTITY)))
, 0)
, 0)
, /* ORIG: EXPLODED */ DECODE(MRSDA.SCHEDULE_ORIGINATION_TYPE
, 8
, NVL(SUM(DECODE(MSI.REPETITIVE_PLANNING_FLAG
, 'Y'
, MRSDA.REPETITIVE_DAILY_RATE
, MRSDA.SCHEDULE_QUANTITY))
, 0)
, 0)
, DECODE(MRSDA.SCHEDULE_ORIGINATION_TYPE
, 8
, NVL(SUM(NVL(MRSDA.ORIGINAL_SCHEDULE_QUANTITY
, DECODE(MSI.REPETITIVE_PLANNING_FLAG
, 'Y'
, MRSDA.REPETITIVE_DAILY_RATE
, MRSDA.SCHEDULE_QUANTITY)))
, 0)
, 0)
, /* ORIG: MANUAL OR OUTSIDE */ DECODE(MRSDA.SCHEDULE_ORIGINATION_TYPE
, 1
, NVL(SUM(DECODE(MSI.REPETITIVE_PLANNING_FLAG
, 'Y'
, MRSDA.REPETITIVE_DAILY_RATE
, MRSDA.SCHEDULE_QUANTITY))
, 0)
, 7
, NVL(SUM(DECODE(MSI.REPETITIVE_PLANNING_FLAG
, 'Y'
, MRSDA.REPETITIVE_DAILY_RATE
, MRSDA.SCHEDULE_QUANTITY))
, 0)
, 0)
, DECODE(MRSDA.SCHEDULE_ORIGINATION_TYPE
, 1
, NVL(SUM(NVL(MRSDA.ORIGINAL_SCHEDULE_QUANTITY
, DECODE(MSI.REPETITIVE_PLANNING_FLAG
, 'Y'
, MRSDA.REPETITIVE_DAILY_RATE
, MRSDA.SCHEDULE_QUANTITY)))
, 0)
, 7
, NVL(SUM(NVL(MRSDA.ORIGINAL_SCHEDULE_QUANTITY
, DECODE(MSI.REPETITIVE_PLANNING_FLAG
, 'Y'
, MRSDA.REPETITIVE_DAILY_RATE
, MRSDA.SCHEDULE_QUANTITY)))
, 0)
, 0)
FROM MRP_SCHEDULE_DATES MRSDA
, MRP_SCHEDULE_DESIGNATORS MRSDE
, MRP_ORGANIZATIONS_V MO
, BOM_CALENDAR_DATES CAL
, MTL_PARAMETERS PARAM
, MTL_SYSTEM_ITEMS_B MSI
WHERE CAL.EXCEPTION_SET_ID = PARAM.CALENDAR_EXCEPTION_SET_ID
AND CAL.CALENDAR_CODE = PARAM.CALENDAR_CODE
AND ((MRSDA.REPETITIVE_DAILY_RATE IS NOT NULL
AND CAL.SEQ_NUM IS NOT NULL) OR (MRSDA.REPETITIVE_DAILY_RATE IS NULL))
AND CAL.CALENDAR_DATE BETWEEN MRSDA.SCHEDULE_DATE
AND DECODE(MRSDA.REPETITIVE_DAILY_RATE
, NULL
, MRSDA.SCHEDULE_DATE
, MRSDA.RATE_END_DATE)
AND MRSDE.ORGANIZATION_ID = MO.ORGANIZATION_ID(+)
AND MRSDE.SCHEDULE_DESIGNATOR = MO.COMPILE_DESIGNATOR (+)
AND NVL(MO.PLANNED_ORGANIZATION
, MRSDE.ORGANIZATION_ID) = MRSDA.ORGANIZATION_ID
AND MRSDE.SCHEDULE_DESIGNATOR = MRSDA.SCHEDULE_DESIGNATOR
AND MRSDE.SCHEDULE_TYPE = MRSDA.SUPPLY_DEMAND_TYPE
AND MSI.ORGANIZATION_ID = MRSDA.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = MRSDA.INVENTORY_ITEM_ID
AND PARAM.ORGANIZATION_ID = MRSDA.ORGANIZATION_ID GROUP BY MRSDA.ORGANIZATION_ID
, MRSDA.SCHEDULE_DESIGNATOR
, MRSDA.INVENTORY_ITEM_ID
, MRSDA.SCHEDULE_LEVEL
, MRSDA.SUPPLY_DEMAND_TYPE
, CAL.PRIOR_DATE
, CAL.CALENDAR_DATE
, MRSDA.SCHEDULE_ORIGINATION_TYPE
, MRSDA.REPETITIVE_DAILY_RATE

Columns