SELECT b.forecast_category_id, t.forecast_category_name, b.start_date_active, b.end_date_active, b.security_group_id, b.created_by, b.creation_date, b.last_updated_by, b.last_update_date, b.last_update_login from as_forecast_categories_B B, as_forecast_categories_tl T WHERE b.forecast_category_id=t.forecast_category_id AND t.language= userenv('LANG')
SELECT B.FORECAST_CATEGORY_ID
, T.FORECAST_CATEGORY_NAME
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
, B.SECURITY_GROUP_ID
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
FROM AS_FORECAST_CATEGORIES_B B
, AS_FORECAST_CATEGORIES_TL T
WHERE B.FORECAST_CATEGORY_ID=T.FORECAST_CATEGORY_ID
AND T.LANGUAGE= USERENV('LANG')
|
|
|