Product: | AS - Sales Foundation |
---|---|
Description: | This view refers to AS_INTEREST_TYPES_TL instead of view AS_INTEREST_TYPES_VL for the performance tuning considerations. Every interest type id in AS_FST_SALES_CATEGORIES will have corresponding entry in AS_INTEREST_TYPES_TL |
Implementation/DBA Data: | APPS.AS_FST_SALES_CATEGORIES_V |
SELECT FST.FST_SALES_CATEGORY_ID
, FST.INTEREST_TYPE_ID
, INT.INTEREST_TYPE
, FST.FORECAST_CATEGORY_ID
, FCT.FORECAST_CATEGORY_NAME
, FST.CREATED_BY
, FST.CREATION_DATE
, FST.LAST_UPDATED_BY
, FST.LAST_UPDATE_DATE
, FST.LAST_UPDATE_LOGIN
, FST.START_DATE_ACTIVE
, FST.END_DATE_ACTIVE
, NULL
FROM AS_FST_SALES_CATEGORIES FST
, AS_FORECAST_CATEGORIES FCT
, AS_INTEREST_TYPES_TL INT
WHERE FST.FORECAST_CATEGORY_ID = FCT.FORECAST_CATEGORY_ID
AND FST.INTEREST_TYPE_ID = INT.INTEREST_TYPE_ID
AND INT.LANGUAGE = USERENV('LANG')