VIEW: APPS.EDW_MRP_FCDM_SET_LCV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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