View: FA_ALTERNATE_LEDGERS_V

Product:	OFA - Assets
Description:	Alternate Ledgers Defined for a book
Implementation/DBA Data:	APPS.FA_ALTERNATE_LEDGERS_V

View Text

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'

Columns