VIEW: APPS.IBY_CRC_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 lookup_type = mapping_type and language = userenv('LANG') and lookup_code IN ('NR','L','LM','M','MH','H','S') 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 LOOKUP_TYPE = MAPPING_TYPE
AND LANGUAGE = USERENV('LANG')
AND LOOKUP_CODE IN ('NR'
, 'L'
, 'LM'
, 'M'
, 'MH'
, 'H'
, 'S')
AND PAYEEID IS NULL ORDER BY SEQ