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_DEMAND_VIEW

Source

View Text - Preformatted


SELECT REQS.INVENTORY_ITEM_ID, REQS.COMPILE_DESIGNATOR, REQS.ORGANIZATION_ID, CAL.WEEK_START_DATE, SUM(DECODE(DAILY_DEMAND_RATE, NULL, USING_REQUIREMENTS_QUANTITY, DAILY_DEMAND_RATE)) FROM BOM_CAL_WEEK_START_DATES CAL,BOM_CALENDAR_DATES DATES,MTL_PARAMETERS PARAM,MRP_PLANS PLANS,MRP_GROSS_REQUIREMENTS REQS 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 REQS.USING_ASSEMBLY_DEMAND_DATE AND DECODE(DAILY_DEMAND_RATE, NULL, REQS.USING_ASSEMBLY_DEMAND_DATE, REQS.ASSEMBLY_DEMAND_COMP_DATE) AND PARAM.ORGANIZATION_ID = REQS.ORGANIZATION_ID AND PLANS.ORGANIZATION_ID = REQS.ORGANIZATION_ID AND PLANS.COMPILE_DESIGNATOR = REQS.COMPILE_DESIGNATOR GROUP BY REQS.COMPILE_DESIGNATOR, REQS.ORGANIZATION_ID, REQS.INVENTORY_ITEM_ID, CAL.WEEK_START_DATE

View Text - HTML Formatted

SELECT REQS.INVENTORY_ITEM_ID
, REQS.COMPILE_DESIGNATOR
, REQS.ORGANIZATION_ID
, CAL.WEEK_START_DATE
, SUM(DECODE(DAILY_DEMAND_RATE
, NULL
, USING_REQUIREMENTS_QUANTITY
, DAILY_DEMAND_RATE))
FROM BOM_CAL_WEEK_START_DATES CAL
, BOM_CALENDAR_DATES DATES
, MTL_PARAMETERS PARAM
, MRP_PLANS PLANS
, MRP_GROSS_REQUIREMENTS REQS
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 REQS.USING_ASSEMBLY_DEMAND_DATE
AND DECODE(DAILY_DEMAND_RATE
, NULL
, REQS.USING_ASSEMBLY_DEMAND_DATE
, REQS.ASSEMBLY_DEMAND_COMP_DATE)
AND PARAM.ORGANIZATION_ID = REQS.ORGANIZATION_ID
AND PLANS.ORGANIZATION_ID = REQS.ORGANIZATION_ID
AND PLANS.COMPILE_DESIGNATOR = REQS.COMPILE_DESIGNATOR GROUP BY REQS.COMPILE_DESIGNATOR
, REQS.ORGANIZATION_ID
, REQS.INVENTORY_ITEM_ID
, CAL.WEEK_START_DATE