View: IBY_CRC_RSTYPES_V

Product:	IBY - Payments
Description:
Implementation/DBA Data:	APPS.IBY_CRC_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 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

Columns