VIEW: APPS.CSP_FORECAST_RULES_VL

Source

View Text - Preformatted

SELECT b.rowid, b.forecast_rule_id, b.created_by, b.creation_date, b.last_updated_by, b.last_update_date, b.last_update_login, b.forecast_rule_name, t.description, b.period_type, b.period_size, b.forecast_periods, b.forecast_method, b.history_periods, b.alpha, b.beta, b.tracking_signal_cycle, b.weighted_avg_period1, b.weighted_avg_period2, b.weighted_avg_period3, b.weighted_avg_period4, b.weighted_avg_period5, b.weighted_avg_period6, b.weighted_avg_period7, b.weighted_avg_period8, b.weighted_avg_period9, b.weighted_avg_period10, b.weighted_avg_period11, b.weighted_avg_period12, b.attribute_category, b.attribute1, b.attribute2, b.attribute3, b.attribute4, b.attribute5, b.attribute6, b.attribute7, b.attribute8, b.attribute9, b.attribute10, b.attribute11, b.attribute12, b.attribute13, b.attribute14, b.attribute15 from csp_forecast_rules_tl t, csp_forecast_rules_b b where b.forecast_rule_id = t.forecast_rule_id and t.language = userenv('LANG')

View Text - HTML Formatted

SELECT B.ROWID
, B.FORECAST_RULE_ID
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.FORECAST_RULE_NAME
, T.DESCRIPTION
, B.PERIOD_TYPE
, B.PERIOD_SIZE
, B.FORECAST_PERIODS
, B.FORECAST_METHOD
, B.HISTORY_PERIODS
, B.ALPHA
, B.BETA
, B.TRACKING_SIGNAL_CYCLE
, B.WEIGHTED_AVG_PERIOD1
, B.WEIGHTED_AVG_PERIOD2
, B.WEIGHTED_AVG_PERIOD3
, B.WEIGHTED_AVG_PERIOD4
, B.WEIGHTED_AVG_PERIOD5
, B.WEIGHTED_AVG_PERIOD6
, B.WEIGHTED_AVG_PERIOD7
, B.WEIGHTED_AVG_PERIOD8
, B.WEIGHTED_AVG_PERIOD9
, B.WEIGHTED_AVG_PERIOD10
, B.WEIGHTED_AVG_PERIOD11
, B.WEIGHTED_AVG_PERIOD12
, B.ATTRIBUTE_CATEGORY
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
FROM CSP_FORECAST_RULES_TL T
, CSP_FORECAST_RULES_B B
WHERE B.FORECAST_RULE_ID = T.FORECAST_RULE_ID
AND T.LANGUAGE = USERENV('LANG')