VIEW: APPS.FA_ALTERNATE_LEDGERS_V

Source

View Text - Preformatted

SELECT Ledger_id, book_type_code alt_book_type_code, primary_set_of_books_id alt_primary_ledger_id, name alt_Ledger, DECODE (ledger_category_code, 'ALC', 'Reporting', 'SECONDARY', 'Secondary' ) alt_Ledger_Type, led.currency_code alt_currency, (SELECT description FROM FND_ID_FLEX_STRUCTURES_vl flex WHERE id_flex_num = chart_of_accounts_id AND id_flex_code = 'GL#' AND application_id = 101) alt_chart_of_accounts, GL_POSTING_ALLOWED_FLAG alt_GL_POSTING_ALLOWED_FLAG, mcbc.enabled_flag alt_enabled_flag FROM fa_mc_book_controls mcbc, gl_ledgers led WHERE mcbc.set_of_books_id = ledger_id AND ledger_category_code <> 'PRIMARY'

View Text - HTML Formatted

SELECT LEDGER_ID
, BOOK_TYPE_CODE ALT_BOOK_TYPE_CODE
, PRIMARY_SET_OF_BOOKS_ID ALT_PRIMARY_LEDGER_ID
, NAME ALT_LEDGER
, DECODE (LEDGER_CATEGORY_CODE
, 'ALC'
, 'REPORTING'
, 'SECONDARY'
, 'SECONDARY' ) ALT_LEDGER_TYPE
, LED.CURRENCY_CODE ALT_CURRENCY
, (SELECT DESCRIPTION
FROM FND_ID_FLEX_STRUCTURES_VL FLEX
WHERE ID_FLEX_NUM = CHART_OF_ACCOUNTS_ID
AND ID_FLEX_CODE = 'GL#'
AND APPLICATION_ID = 101) ALT_CHART_OF_ACCOUNTS
, GL_POSTING_ALLOWED_FLAG ALT_GL_POSTING_ALLOWED_FLAG
, MCBC.ENABLED_FLAG ALT_ENABLED_FLAG
FROM FA_MC_BOOK_CONTROLS MCBC
, GL_LEDGERS LED
WHERE MCBC.SET_OF_BOOKS_ID = LEDGER_ID
AND LEDGER_CATEGORY_CODE <> 'PRIMARY'