VIEW: APPS.IBY_TOP_RSTYPES_V

Source

View Text - Preformatted

SELECT distinct lookup_code score_type, meaning, seq from fnd_lookup_values a, iby_mappings b where enabled_flag = 'Y' and lookup_type = 'IBY_RISK_SCORE_TYPE' and lookup_code = mapping_code and mapping_type = lookup_type and language = userenv('LANG') and lookup_code IN ('S','L','LM','M','MH','H') and payeeid is null order by seq

View Text - HTML Formatted

SELECT DISTINCT LOOKUP_CODE SCORE_TYPE
, MEANING
, SEQ
FROM FND_LOOKUP_VALUES A
, IBY_MAPPINGS B
WHERE ENABLED_FLAG = 'Y'
AND LOOKUP_TYPE = 'IBY_RISK_SCORE_TYPE'
AND LOOKUP_CODE = MAPPING_CODE
AND MAPPING_TYPE = LOOKUP_TYPE
AND LANGUAGE = USERENV('LANG')
AND LOOKUP_CODE IN ('S'
, 'L'
, 'LM'
, 'M'
, 'MH'
, 'H')
AND PAYEEID IS NULL ORDER BY SEQ