View: GL_IEA_TRANSACTION_TYPES_MAP_V

View Text

SELECT IEA.NAME NAME
, IEA.TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID
FROM GL_IEA_TRANSACTION_TYPES IEA
WHERE IEA.ENABLED_FLAG = 'Y' UNION SELECT LK.MEANING NAME
, -1 TRANSACTION_TYPE_ID
FROM GL_LOOKUPS LK
WHERE LK.LOOKUP_TYPE = 'LITERAL'
AND LK.LOOKUP_CODE = 'OTHER1234567890123456789012345'
AND LK.ENABLED_FLAG = 'Y'

Columns