VIEW: APPS.MRP_DAILY_DEMAND_VIEW

Source

View Text - Preformatted

SELECT REQS.INVENTORY_ITEM_ID, REQS.COMPILE_DESIGNATOR, REQS.ORGANIZATION_ID, DATES.CALENDAR_DATE, SUM(DECODE(DAILY_DEMAND_RATE, NULL, USING_REQUIREMENTS_QUANTITY, DAILY_DEMAND_RATE)) FROM BOM_CALENDAR_DATES DATES, MTL_PARAMETERS PARAM, MRP_PLANS PLANS, MRP_GROSS_REQUIREMENTS REQS WHERE DATES.CALENDAR_DATE <= PLANS.CUTOFF_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, DATES.CALENDAR_DATE

View Text - HTML Formatted

SELECT REQS.INVENTORY_ITEM_ID
, REQS.COMPILE_DESIGNATOR
, REQS.ORGANIZATION_ID
, DATES.CALENDAR_DATE
, SUM(DECODE(DAILY_DEMAND_RATE
, NULL
, USING_REQUIREMENTS_QUANTITY
, DAILY_DEMAND_RATE))
FROM BOM_CALENDAR_DATES DATES
, MTL_PARAMETERS PARAM
, MRP_PLANS PLANS
, MRP_GROSS_REQUIREMENTS REQS
WHERE DATES.CALENDAR_DATE <= PLANS.CUTOFF_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
, DATES.CALENDAR_DATE