Product: | MRP - Master Scheduling/MRP |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.MRPFV_FORECAST_SETS |
SELECT PA.ORGANIZATION_CODE
, AL.NAME
, DE.FORECAST_DESIGNATOR
, DE.DESCRIPTION
, '_LA:DE.BUCKET_TYPE:MFG_LOOKUPS:MRP_BUCKET_TYPE:MEANING'
, '_LA:DE.UPDATE_TYPE:MFG_LOOKUPS:MRP_UPDATE_TYPE:MEANING'
, '_LA:DE.CONSUME_FORECAST:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, DE.OUTLIER_UPDATE_PERCENTAGE
, DE.BACKWARD_UPDATE_TIME_FENCE
, DE.FOREWARD_UPDATE_TIME_FENCE
, DE.DISABLE_DATE
, '_DF:MRP:MRPFFCFN2:DE'
, DE.ORGANIZATION_ID
, DE.LAST_UPDATE_DATE
, DE.LAST_UPDATED_BY
, DE.CREATION_DATE
, DE.CREATED_BY
FROM MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS AL
, MRP_FORECAST_DESIGNATORS DE
WHERE DE.FORECAST_SET IS NULL
AND DE.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND DE.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND '_SEC:DE.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY