View: EDW_MRP_FCDM_SET_LCV

Product:	ISC - Supply Chain Intelligence
Description:	This is the collection view for the Forecast Set level of the Forecast dimension
Implementation/DBA Data:	APPS.EDW_MRP_FCDM_SET_LCV

View Text

SELECT FD.FORECAST_DESIGNATOR||'-'||FD.ORGANIZATION_ID||'-'||INST.INSTANCE_CODE
, ML.MEANING
, FD.CREATION_DATE
, FD.DESCRIPTION
, FD.DISABLE_DATE
, FD.FORECAST_DESIGNATOR||'-'||MP.ORGANIZATION_CODE||'-'||INST.INSTANCE_CODE
, FD.FORECAST_DESIGNATOR||'('||MP.ORGANIZATION_CODE||')'
, INST.INSTANCE_CODE
, FD.LAST_UPDATE_DATE
, FD.FORECAST_DESIGNATOR||'('||MP.ORGANIZATION_CODE||')'
, NULL
, NULL
, NULL
, NULL
, NULL FROM MFG_LOOKUPS ML
, MRP_FORECAST_DESIGNATORS FD
, MTL_PARAMETERS MP
, EDW_LOCAL_INSTANCE INST
WHERE ML.LOOKUP_CODE = FD.UPDATE_TYPE AND ML.LOOKUP_TYPE='MRP_UPDATE_TYPE' AND FD.FORECAST_SET IS NULL AND FD.ORGANIZATION_ID = MP.ORGANIZATION_ID

Columns