Get Forecast Set and Forecast Designators

Basic Detail

• Resource Type : SQL
• Purpose : Get List of Active Sales Forecast Designators
• Difficulty Rating : Begineer

Apps Detail

• Version : R12 ( 12.1.3 )
• Module : Inventory
• Related Function : Planning : Forecasts : Sets

Related Tables

• MRP.MRP_FORECAST_DESIGNATORS

Other Detail

• None

Considerations

• None

Code

/**************************************************************
PURPOSE : GET ACTIVE SALES FORECAST SET AND FORECAST DESIGNATORS
**************************************************************/

SELECT FC.FORECAST_SET, FC.FORECAST_DESIGNATOR
FROM MRP.MRP_FORECAST_DESIGNATORS FC
WHERE FC.FORECAST_SET IS NOT NULL
AND (FC.DISABLE_DATE IS NULL OR FC.DISABLE_DATE > SYSDATE)
ORDER BY FC.FORECAST_SET, FC.FORECAST_DESIGNATOR;