View: IBY_TOP_RSTYPES_V

Product:	IBY - Payments
Description:
Implementation/DBA Data:	APPS.IBY_TOP_RSTYPES_V

View Text

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

Columns