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_WEEKLY_SUPPLY_VIEW

Source

View Text - Preformatted


SELECT RECOM.INVENTORY_ITEM_ID, RECOM.COMPILE_DESIGNATOR, RECOM.ORGANIZATION_ID, CAL.WEEK_START_DATE, SUM(DECODE(LAST_UNIT_COMPLETION_DATE, NULL, NEW_ORDER_QUANTITY, DAILY_RATE)) FROM BOM_CAL_WEEK_START_DATES CAL,BOM_CALENDAR_DATES DATES,MTL_PARAMETERS PARAM,MRP_PLANS PLANS,MRP_RECOMMENDATIONS RECOM WHERE CAL.EXCEPTION_SET_ID = PARAM.CALENDAR_EXCEPTION_SET_ID AND CAL.CALENDAR_CODE = PARAM.CALENDAR_CODE AND CAL.WEEK_START_DATE <= PLANS.CUTOFF_DATE AND DATES.CALENDAR_DATE >= CAL.WEEK_START_DATE AND DATES.CALENDAR_DATE < CAL.NEXT_DATE AND DATES.EXCEPTION_SET_ID = PARAM.CALENDAR_EXCEPTION_SET_ID AND DATES.CALENDAR_CODE = PARAM.CALENDAR_CODE AND DATES.SEQ_NUM IS NOT NULL AND DATES.CALENDAR_DATE BETWEEN RECOM.NEW_SCHEDULE_DATE AND DECODE(LAST_UNIT_COMPLETION_DATE, NULL, RECOM.NEW_SCHEDULE_DATE, RECOM.LAST_UNIT_COMPLETION_DATE) AND PARAM.ORGANIZATION_ID = RECOM.ORGANIZATION_ID AND PLANS.ORGANIZATION_ID = RECOM.ORGANIZATION_ID AND PLANS.COMPILE_DESIGNATOR = RECOM.COMPILE_DESIGNATOR AND RECOM.DISPOSITION_STATUS_TYPE = 1 GROUP BY RECOM.COMPILE_DESIGNATOR, RECOM.ORGANIZATION_ID, RECOM.INVENTORY_ITEM_ID, CAL.WEEK_START_DATE

View Text - HTML Formatted

SELECT RECOM.INVENTORY_ITEM_ID
, RECOM.COMPILE_DESIGNATOR
, RECOM.ORGANIZATION_ID
, CAL.WEEK_START_DATE
, SUM(DECODE(LAST_UNIT_COMPLETION_DATE
, NULL
, NEW_ORDER_QUANTITY
, DAILY_RATE))
FROM BOM_CAL_WEEK_START_DATES CAL
, BOM_CALENDAR_DATES DATES
, MTL_PARAMETERS PARAM
, MRP_PLANS PLANS
, MRP_RECOMMENDATIONS RECOM
WHERE CAL.EXCEPTION_SET_ID = PARAM.CALENDAR_EXCEPTION_SET_ID
AND CAL.CALENDAR_CODE = PARAM.CALENDAR_CODE
AND CAL.WEEK_START_DATE <= PLANS.CUTOFF_DATE
AND DATES.CALENDAR_DATE >= CAL.WEEK_START_DATE
AND DATES.CALENDAR_DATE < CAL.NEXT_DATE
AND DATES.EXCEPTION_SET_ID = PARAM.CALENDAR_EXCEPTION_SET_ID
AND DATES.CALENDAR_CODE = PARAM.CALENDAR_CODE
AND DATES.SEQ_NUM IS NOT NULL
AND DATES.CALENDAR_DATE BETWEEN RECOM.NEW_SCHEDULE_DATE
AND DECODE(LAST_UNIT_COMPLETION_DATE
, NULL
, RECOM.NEW_SCHEDULE_DATE
, RECOM.LAST_UNIT_COMPLETION_DATE)
AND PARAM.ORGANIZATION_ID = RECOM.ORGANIZATION_ID
AND PLANS.ORGANIZATION_ID = RECOM.ORGANIZATION_ID
AND PLANS.COMPILE_DESIGNATOR = RECOM.COMPILE_DESIGNATOR
AND RECOM.DISPOSITION_STATUS_TYPE = 1 GROUP BY RECOM.COMPILE_DESIGNATOR
, RECOM.ORGANIZATION_ID
, RECOM.INVENTORY_ITEM_ID
, CAL.WEEK_START_DATE