VIEW: APPS.MRP_FORECASTS_LOV_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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