eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.MRP_DAILY_SCHEDULES_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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