View: GL_ALL_LEDGER_NAME_VIEW

View Text

SELECT LED.LEDGER_ID LEDGER_ID
, LED.NAME LEDGER_NAME
, LED.OBJECT_TYPE_CODE LEDGER_TYPE
, LK.MEANING DISPLAY_LEDGER_TYPE
, LED.CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID
, LED.PERIOD_SET_NAME PERIOD_SET_NAME
, LED.ACCOUNTED_PERIOD_TYPE ACCOUNTED_PERIOD_TYPE
FROM GL_LEDGERS LED
, GL_LOOKUPS LK
, GL_LEDGER_CONFIGURATIONS LC
WHERE LC.CONFIGURATION_ID (+) = LED.CONFIGURATION_ID
AND DECODE(LED.OBJECT_TYPE_CODE
, 'L'
, LC.COMPLETION_STATUS_CODE(+)
, 'CONFIRMED') = 'CONFIRMED'
AND LK.LOOKUP_TYPE = 'LEDGERS'
AND LK.LOOKUP_CODE = LED.OBJECT_TYPE_CODE UNION SELECT -1234567890
, L.MEANING
, '-'
, NULL
, NULL
, NULL
, NULL
FROM GL_LOOKUPS L
WHERE L.LOOKUP_TYPE = 'LITERAL'
AND L.LOOKUP_CODE = 'ALL'

Columns