VIEW: APPS.IBY_RC_RSTYPES_V

Source

View Text - Preformatted

SELECT 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 mapping_code = lookup_code and mapping_type = lookup_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 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 MAPPING_CODE = LOOKUP_CODE
AND MAPPING_TYPE = LOOKUP_TYPE
AND LANGUAGE = USERENV('LANG')
AND LOOKUP_CODE IN ('NR'
, 'L'
, 'LM'
, 'M'
, 'MH'
, 'H'
, 'S')
AND PAYEEID IS NULL ORDER BY SEQ