View: GL_MRC_REPORTING_SOB_PROFILE_V

View Text

SELECT SB.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, SB.NAME NAME
, SB.SHORT_NAME SHORT_NAME
, SB.CURRENCY_CODE CURRENCY_CODE
FROM GL_SETS_OF_BOOKS SB
WHERE SB.MRC_SOB_TYPE_CODE = 'R' UNION SELECT -1 SET_OF_BOOKS_ID
, LU.MEANING NAME
, NULL SHORT_NAME
, NULL CURRENCY_CODE
FROM GL_LOOKUPS LU
WHERE LU.LOOKUP_TYPE = 'LITERAL'
AND LU.LOOKUP_CODE = 'N/A'

Columns