[Home] [Help]
| Product: | ISC - Supply Chain Intelligence (Obsolete) |
|---|---|
| Description: | This is the collection view for the Forecast level of the Forecast dimension |
| Implementation/DBA Data: | Not implemented in this database |
SELECT FD.FORECAST_DESIGNATOR||'-'||FD.ORGANIZATION_ID||'-'||INST.INSTANCE_CODE
, FD.FORECAST_SET||'-'||FD.ORGANIZATION_ID||'-'||INST.INSTANCE_CODE
, 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 MRP_FORECAST_DESIGNATORS FD
, MTL_PARAMETERS MP
, EDW_LOCAL_INSTANCE INST
WHERE FD.FORECAST_SET IS NOT NULL AND FD.ORGANIZATION_ID = MP.ORGANIZATION_ID