View: MRP_FORECASTS_LOV_V

Product:	MRP - Master Scheduling/MRP
Description:	Forecast designators and forecast sets list of values view
Implementation/DBA Data:	APPS.MRP_FORECASTS_LOV_V

View Text

SELECT MRFDE1.FORECAST_DESIGNATOR FORECAST_SET_DESIGNATOR
, MRFDE1.DESCRIPTION FORECAST_SET_DESCRIPTION
, MRFDE1.DISABLE_DATE FORECAST_SET_DISABLE_DATE
, MRFDE1.BUCKET_TYPE FORECAST_SET_BUCKET_TYPE
, MRFDE2.FORECAST_DESIGNATOR FORECAST_DESIGNATOR
, MRFDE2.DESCRIPTION FORECAST_DESCRIPTION
, MRFDE2.DISABLE_DATE FORECAST_DISABLE_DATE
, MRFDE2.ORGANIZATION_ID
FROM MRP_FORECAST_DESIGNATORS MRFDE1
, MRP_FORECAST_DESIGNATORS MRFDE2
WHERE MRFDE1.ORGANIZATION_ID = MRFDE2.ORGANIZATION_ID
AND MRFDE1.FORECAST_DESIGNATOR = MRFDE2.FORECAST_SET UNION ALL SELECT MRFDE.FORECAST_DESIGNATOR FORECAST_SET_DESIGNATOR
, MRFDE.DESCRIPTION FORECAST_SET_DESCRIPTION
, MRFDE.DISABLE_DATE FORECAST_SET_DISABLE_DATE
, MRFDE.BUCKET_TYPE FORECAST_SET_BUCKET_TYPE
, ' ' FORECAST_DESIGNATOR
, TO_CHAR(NULL) FORECAST_DESCRIPTION
, TO_DATE(NULL) FORECAST_DISABLE_DATE
, MRFDE.ORGANIZATION_ID
FROM MRP_FORECAST_DESIGNATORS MRFDE
WHERE MRFDE.FORECAST_SET IS NULL

Columns