VIEW: APPS.AS_SCORECARD_RULES_V

Source

View Text - Preformatted

SELECT b.scorecard_id SCORECARD_ID, b.card_rule_id CARD_RULE_ID, b.score SCORE, b.high_value_number HIGH_VALUE_NUMBER, b.low_value_number LOW_VALUE_NUMBER, b.high_value_char HIGH_VALUE_CHAR, b.low_value_char LOW_VALUE_CHAR, b.qual_value_id QUAL_VALUE_ID, b.seed_qual_id SEED_QUAL_ID, b.last_update_date LAST_UPDATE_DATE, cb.source_table_name SOURCE_TABLE_NAME, cb.source_column_name SOURCE_COLUMN_NAME, substr(cb.data_type,1,8) DATA_TYPE, cb.range_flag RANGE_FLAG, cb.lov_sql LOV_SQL, ct.meaning MEANING from as_card_rule_qual_values b, as_sales_lead_quals_b cb, as_sales_lead_quals_tl ct WHERE cb.seed_qual_id = b.seed_qual_id and cb.enabled_flag = 'Y' and cb.seed_qual_ID = ct.seed_qual_ID and ct.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT B.SCORECARD_ID SCORECARD_ID
, B.CARD_RULE_ID CARD_RULE_ID
, B.SCORE SCORE
, B.HIGH_VALUE_NUMBER HIGH_VALUE_NUMBER
, B.LOW_VALUE_NUMBER LOW_VALUE_NUMBER
, B.HIGH_VALUE_CHAR HIGH_VALUE_CHAR
, B.LOW_VALUE_CHAR LOW_VALUE_CHAR
, B.QUAL_VALUE_ID QUAL_VALUE_ID
, B.SEED_QUAL_ID SEED_QUAL_ID
, B.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CB.SOURCE_TABLE_NAME SOURCE_TABLE_NAME
, CB.SOURCE_COLUMN_NAME SOURCE_COLUMN_NAME
, SUBSTR(CB.DATA_TYPE
, 1
, 8) DATA_TYPE
, CB.RANGE_FLAG RANGE_FLAG
, CB.LOV_SQL LOV_SQL
, CT.MEANING MEANING
FROM AS_CARD_RULE_QUAL_VALUES B
, AS_SALES_LEAD_QUALS_B CB
, AS_SALES_LEAD_QUALS_TL CT
WHERE CB.SEED_QUAL_ID = B.SEED_QUAL_ID
AND CB.ENABLED_FLAG = 'Y'
AND CB.SEED_QUAL_ID = CT.SEED_QUAL_ID
AND CT.LANGUAGE = USERENV('LANG')