1. Tables and Views for Financials
  2. GL_LEDGERS_ALL_V

GL_LEDGERS_ALL_V

Details

  • Schema: FUSION

  • Object owner: GL

  • Object type: VIEW

Columns

Name

LEDGER_NAME

LEDGER_ID

DISPLAY_LEDGER_TYPE

SORT_ORDER

CHART_OF_ACCOUNTS_ID

PERIOD_SET_NAME

ACCOUNTED_PERIOD_TYPE

DESCRIPTION

TYPE

Query

SQL_Statement

SELECT

led.name ledger_name,

led.ledger_id,

lk.meaning display_ledger_type,

'1' || led.name sort_order,

CHART_OF_ACCOUNTS_ID,

PERIOD_SET_NAME,

ACCOUNTED_PERIOD_TYPE,

led.DESCRIPTION,

ltype.meaning as TYPE

from

gl_ledgers led, gl_lookups lk, gl_lookups ltype

WHERE nvl(led.complete_flag, 'Y') = 'Y'

AND lk.lookup_type = 'LEDGERS'

AND lk.lookup_code = led.object_type_code

AND ltype.lookup_type = 'GL_ASF_LEDGER_CATEGORY'

AND led.ledger_category_code = ltype.lookup_code

UNION ALL

SELECT

l.meaning ledger_name,

0 ledger_id,

NULL display_ledger_type,

'0' sort_order,

NULL CHART_OF_ACCOUNTS_ID,

l.meaning as PERIOD_SET_NAME,

l.meaning as ACCOUNTED_PERIOD_TYPE,

l.meaning as DESCRIPTION,

l.meaning as TYPE

FROM gl_lookups l

WHERE l.lookup_type = 'LITERAL'

AND l.lookup_code = 'ALL'

order by 4