Product: | AS - Sales Foundation |
---|---|
Description: | Scorecard rules |
Implementation/DBA Data: | APPS.AS_SCORECARD_RULES_V |
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')