VIEW: APPS.MRP_DAILY_SUPPLY_VIEW

Source

View Text - Preformatted

SELECT RECOM.INVENTORY_ITEM_ID, RECOM.COMPILE_DESIGNATOR, RECOM.ORGANIZATION_ID, DATES.CALENDAR_DATE, SUM(DECODE(LAST_UNIT_COMPLETION_DATE, NULL, NEW_ORDER_QUANTITY, DAILY_RATE)) SUPPLY_QUANTITY FROM BOM_CALENDAR_DATES DATES,MTL_PARAMETERS PARAM,MRP_PLANS PLANS,MRP_RECOMMENDATIONS RECOM 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 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, DATES.CALENDAR_DATE

View Text - HTML Formatted

SELECT RECOM.INVENTORY_ITEM_ID
, RECOM.COMPILE_DESIGNATOR
, RECOM.ORGANIZATION_ID
, DATES.CALENDAR_DATE
, SUM(DECODE(LAST_UNIT_COMPLETION_DATE
, NULL
, NEW_ORDER_QUANTITY
, DAILY_RATE)) SUPPLY_QUANTITY
FROM BOM_CALENDAR_DATES DATES
, MTL_PARAMETERS PARAM
, MRP_PLANS PLANS
, MRP_RECOMMENDATIONS RECOM
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 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
, DATES.CALENDAR_DATE