VIEW: APPS.OKL_REPRESENTATIONS_V

Source

View Text - Preformatted

SELECT o.set_of_books_id ledger_id, g.name ledger_name, g.short_name representation_code, g.name representation_name, 'PRIMARY' representation_type, okl_accounting_util.get_lookup_meaning('OKL_REPRESENTATION_TYPE', 'PRIMARY') rep_type_meaning, o.org_id FROM okl_sys_acct_opts o, gl_ledgers g WHERE o.set_of_books_id = g.ledger_id UNION ALL SELECT g.ledger_id ledger_id, g.name ledger_name, g.short_name representation_code, g.name representation_name, 'SECONDARY' representation_type, okl_accounting_util.get_lookup_meaning('OKL_REPRESENTATION_TYPE', 'SECONDARY') rep_type_meaning, o.org_id FROM okl_sys_acct_opts o, okl_system_params s, fa_book_controls f, gl_ledgers g WHERE o.org_id = s.org_id AND s.RPT_PROD_BOOK_TYPE_CODE(+) = f.book_type_code AND f.set_of_books_id = g.ledger_id

View Text - HTML Formatted

SELECT O.SET_OF_BOOKS_ID LEDGER_ID
, G.NAME LEDGER_NAME
, G.SHORT_NAME REPRESENTATION_CODE
, G.NAME REPRESENTATION_NAME
, 'PRIMARY' REPRESENTATION_TYPE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_REPRESENTATION_TYPE'
, 'PRIMARY') REP_TYPE_MEANING
, O.ORG_ID
FROM OKL_SYS_ACCT_OPTS O
, GL_LEDGERS G
WHERE O.SET_OF_BOOKS_ID = G.LEDGER_ID UNION ALL SELECT G.LEDGER_ID LEDGER_ID
, G.NAME LEDGER_NAME
, G.SHORT_NAME REPRESENTATION_CODE
, G.NAME REPRESENTATION_NAME
, 'SECONDARY' REPRESENTATION_TYPE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_REPRESENTATION_TYPE'
, 'SECONDARY') REP_TYPE_MEANING
, O.ORG_ID
FROM OKL_SYS_ACCT_OPTS O
, OKL_SYSTEM_PARAMS S
, FA_BOOK_CONTROLS F
, GL_LEDGERS G
WHERE O.ORG_ID = S.ORG_ID
AND S.RPT_PROD_BOOK_TYPE_CODE(+) = F.BOOK_TYPE_CODE
AND F.SET_OF_BOOKS_ID = G.LEDGER_ID