VIEW: APPS.GL_CONSOLIDATION_NAMES_V

Source

View Text - Preformatted

SELECT cons.consolidation_id CONSOLIDATION_ID, cons.name NAME, cons.description DESCRIPTION, cons.method METHOD, cons.usage_code USAGE_CODE, map.start_date_active START_DATE_ACTIVE, map.end_date_active END_DATE_ACTIVE, cons.from_ledger_id FROM_LEDGER_ID, gl_fc_xlate_pkg.get_ledger_short_name ( ledger1.short_name, ledger1.ledger_id, cons.from_currency_code ) FROM_SHORT_NAME, gl_fc_xlate_pkg.get_ledger_name ( ledger1.name, ledger1.ledger_id, cons.from_currency_code ) FROM_LEDGER_NAME, ledger1.enable_average_balances_flag FROM_ENABLE_AB_FLAG, ledger1.consolidation_ledger_flag FROM_CONSOLIDATION_LEDGER_FLAG, ledger1.chart_of_accounts_id FROM_CHART_OF_ACCOUNTS_ID, cons.from_currency_code FROM_CURRENCY_CODE, cons.to_ledger_id TO_LEDGER_ID, ledger2.short_name TO_SHORT_NAME, ledger2.name TO_LEDGER_NAME, ledger2.enable_average_balances_flag TO_ENABLE_AB_FLAG, ledger2.consolidation_ledger_flag TO_CONSOLIDATION_LEDGER_FLAG, nvl ( cons.run_journal_import_flag, 'Y') RUN_JOURNAL_IMPORT, nvl ( cons.summarize_lines_flag, 'Y') SUMMARIZE_LINES, nvl ( cons.audit_mode_flag, 'N') AUDIT_MODE, nvl ( cons.run_posting_flag, 'N') RUN_POSTING_FLAG, decode ( cons.security_flag, 'Y', decode ( fnd_data_security.check_function ( 1.0, 'GL_DAS_CONSOLIDATION_U', 'GL_DAS_CONSOLIDATION', to_char ( cons.consolidation_id ) , null, null, null, null, fnd_global.user_name ) , 'T', 'Y', 'N') , 'Y') USE_PRIVILEGE FROM gl_ledgers ledger1, gl_ledgers ledger2, gl_consolidation cons, gl_coa_mappings map WHERE cons.from_ledger_id = ledger1.ledger_id AND cons.to_ledger_id = ledger2.ledger_id AND cons.coa_mapping_id = map.coa_mapping_id

View Text - HTML Formatted

SELECT CONS.CONSOLIDATION_ID CONSOLIDATION_ID
, CONS.NAME NAME
, CONS.DESCRIPTION DESCRIPTION
, CONS.METHOD METHOD
, CONS.USAGE_CODE USAGE_CODE
, MAP.START_DATE_ACTIVE START_DATE_ACTIVE
, MAP.END_DATE_ACTIVE END_DATE_ACTIVE
, CONS.FROM_LEDGER_ID FROM_LEDGER_ID
, GL_FC_XLATE_PKG.GET_LEDGER_SHORT_NAME ( LEDGER1.SHORT_NAME
, LEDGER1.LEDGER_ID
, CONS.FROM_CURRENCY_CODE ) FROM_SHORT_NAME
, GL_FC_XLATE_PKG.GET_LEDGER_NAME ( LEDGER1.NAME
, LEDGER1.LEDGER_ID
, CONS.FROM_CURRENCY_CODE ) FROM_LEDGER_NAME
, LEDGER1.ENABLE_AVERAGE_BALANCES_FLAG FROM_ENABLE_AB_FLAG
, LEDGER1.CONSOLIDATION_LEDGER_FLAG FROM_CONSOLIDATION_LEDGER_FLAG
, LEDGER1.CHART_OF_ACCOUNTS_ID FROM_CHART_OF_ACCOUNTS_ID
, CONS.FROM_CURRENCY_CODE FROM_CURRENCY_CODE
, CONS.TO_LEDGER_ID TO_LEDGER_ID
, LEDGER2.SHORT_NAME TO_SHORT_NAME
, LEDGER2.NAME TO_LEDGER_NAME
, LEDGER2.ENABLE_AVERAGE_BALANCES_FLAG TO_ENABLE_AB_FLAG
, LEDGER2.CONSOLIDATION_LEDGER_FLAG TO_CONSOLIDATION_LEDGER_FLAG
, NVL ( CONS.RUN_JOURNAL_IMPORT_FLAG
, 'Y') RUN_JOURNAL_IMPORT
, NVL ( CONS.SUMMARIZE_LINES_FLAG
, 'Y') SUMMARIZE_LINES
, NVL ( CONS.AUDIT_MODE_FLAG
, 'N') AUDIT_MODE
, NVL ( CONS.RUN_POSTING_FLAG
, 'N') RUN_POSTING_FLAG
, DECODE ( CONS.SECURITY_FLAG
, 'Y'
, DECODE ( FND_DATA_SECURITY.CHECK_FUNCTION ( 1.0
, 'GL_DAS_CONSOLIDATION_U'
, 'GL_DAS_CONSOLIDATION'
, TO_CHAR ( CONS.CONSOLIDATION_ID )
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME )
, 'T'
, 'Y'
, 'N')
, 'Y') USE_PRIVILEGE
FROM GL_LEDGERS LEDGER1
, GL_LEDGERS LEDGER2
, GL_CONSOLIDATION CONS
, GL_COA_MAPPINGS MAP
WHERE CONS.FROM_LEDGER_ID = LEDGER1.LEDGER_ID
AND CONS.TO_LEDGER_ID = LEDGER2.LEDGER_ID
AND CONS.COA_MAPPING_ID = MAP.COA_MAPPING_ID