SELECT fd.forecast_designator||'-'||fd.organization_id||'-'||inst.instance_code, fd.forecast_designator, fd.organization_id 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
SELECT FD.FORECAST_DESIGNATOR||'-'||FD.ORGANIZATION_ID||'-'||INST.INSTANCE_CODE
, FD.FORECAST_DESIGNATOR
, FD.ORGANIZATION_ID
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
|
|
|