VIEW: APPS.GL_CONSOLIDATION_V

Source

View Text - Preformatted

SELECT cons.rowid ROW_ID, cons.consolidation_id CONSOLIDATION_ID, cons.name NAME, map.coa_mapping_id MAPPING_ID, map.name MAPPING_NAME, cons.last_update_date LAST_UPDATE_DATE, cons.last_updated_by LAST_UPDATED_BY, cons.from_ledger_id FROM_LEDGER_ID, gl_fc_xlate_pkg.get_ledger_name(ledger1.name, ledger1.ledger_id, cons.from_currency_code) FROM_LEDGER_NAME, gl_fc_xlate_pkg.get_ledger_short_name(ledger1.short_name, ledger1.ledger_id, cons.from_currency_code) FROM_SHORT_NAME, ledger1.chart_of_accounts_id FROM_CHART_OF_ACCOUNTS_ID, ledger1.period_set_name FROM_PERIOD_SET_NAME, ledger1.enable_average_balances_flag FROM_LEDGER_ADB_ENABLED, cons.to_ledger_id TO_LEDGER_ID, ledger2.name TO_LEDGER_NAME, ledger2.short_name TO_SHORT_NAME, ledger2.chart_of_accounts_id TO_CHART_OF_ACCOUNTS_ID, ledger2.period_set_name TO_PERIOD_SET_NAME, ledger2.enable_average_balances_flag TO_LEDGER_ADB_ENABLED, ledger2.consolidation_ledger_flag TO_CONS_LEDGER_FLAG, cons.creation_date CREATION_DATE, cons.created_by CREATED_BY, cons.last_update_login LAST_UPDATE_LOGIN, cons.method METHOD, cons.usage_code USAGE, cons.description DESCRIPTION, cons.security_flag SECURITY_FLAG, cons.from_currency_code FROM_CURRENCY_CODE, cons.from_location FROM_LOCATION, cons.from_oracle_id FROM_ORACLE_ID, cons.attribute1 ATTRIBUTE1, cons.attribute2 ATTRIBUTE2, cons.attribute3 ATTRIBUTE3, cons.attribute4 ATTRIBUTE4, cons.attribute5 ATTRIBUTE5, cons.context CONTEXT, nvl(cons.run_journal_import_flag,'N') RUN_JOURNAL_IMPORT_FLAG, nvl(cons.audit_mode_flag,'N') AUDIT_MODE_FLAG, decode(cons.run_journal_import_flag,'N', 'N', nvl(cons.summarize_lines_flag, 'N')) SUMMARIZE_LINES_FLAG, 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_V', 'GL_DAS_CONSOLIDATION', to_char(cons.consolidation_id), null, null, null, null, fnd_global.user_name), 'T', 'Y', 'N'), 'Y') VIEW_PRIVILEGE, 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, decode(cons.security_flag,'Y', decode(fnd_data_security.check_function(1.0,'GL_DAS_CONSOLIDATION_M', 'GL_DAS_CONSOLIDATION', to_char(cons.consolidation_id), null, null, null, null, fnd_global.user_name), 'T', 'Y', 'N'), 'Y') MODIFY_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.ROWID ROW_ID
, CONS.CONSOLIDATION_ID CONSOLIDATION_ID
, CONS.NAME NAME
, MAP.COA_MAPPING_ID MAPPING_ID
, MAP.NAME MAPPING_NAME
, CONS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CONS.LAST_UPDATED_BY LAST_UPDATED_BY
, CONS.FROM_LEDGER_ID FROM_LEDGER_ID
, GL_FC_XLATE_PKG.GET_LEDGER_NAME(LEDGER1.NAME
, LEDGER1.LEDGER_ID
, CONS.FROM_CURRENCY_CODE) FROM_LEDGER_NAME
, GL_FC_XLATE_PKG.GET_LEDGER_SHORT_NAME(LEDGER1.SHORT_NAME
, LEDGER1.LEDGER_ID
, CONS.FROM_CURRENCY_CODE) FROM_SHORT_NAME
, LEDGER1.CHART_OF_ACCOUNTS_ID FROM_CHART_OF_ACCOUNTS_ID
, LEDGER1.PERIOD_SET_NAME FROM_PERIOD_SET_NAME
, LEDGER1.ENABLE_AVERAGE_BALANCES_FLAG FROM_LEDGER_ADB_ENABLED
, CONS.TO_LEDGER_ID TO_LEDGER_ID
, LEDGER2.NAME TO_LEDGER_NAME
, LEDGER2.SHORT_NAME TO_SHORT_NAME
, LEDGER2.CHART_OF_ACCOUNTS_ID TO_CHART_OF_ACCOUNTS_ID
, LEDGER2.PERIOD_SET_NAME TO_PERIOD_SET_NAME
, LEDGER2.ENABLE_AVERAGE_BALANCES_FLAG TO_LEDGER_ADB_ENABLED
, LEDGER2.CONSOLIDATION_LEDGER_FLAG TO_CONS_LEDGER_FLAG
, CONS.CREATION_DATE CREATION_DATE
, CONS.CREATED_BY CREATED_BY
, CONS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CONS.METHOD METHOD
, CONS.USAGE_CODE USAGE
, CONS.DESCRIPTION DESCRIPTION
, CONS.SECURITY_FLAG SECURITY_FLAG
, CONS.FROM_CURRENCY_CODE FROM_CURRENCY_CODE
, CONS.FROM_LOCATION FROM_LOCATION
, CONS.FROM_ORACLE_ID FROM_ORACLE_ID
, CONS.ATTRIBUTE1 ATTRIBUTE1
, CONS.ATTRIBUTE2 ATTRIBUTE2
, CONS.ATTRIBUTE3 ATTRIBUTE3
, CONS.ATTRIBUTE4 ATTRIBUTE4
, CONS.ATTRIBUTE5 ATTRIBUTE5
, CONS.CONTEXT CONTEXT
, NVL(CONS.RUN_JOURNAL_IMPORT_FLAG
, 'N') RUN_JOURNAL_IMPORT_FLAG
, NVL(CONS.AUDIT_MODE_FLAG
, 'N') AUDIT_MODE_FLAG
, DECODE(CONS.RUN_JOURNAL_IMPORT_FLAG
, 'N'
, 'N'
, NVL(CONS.SUMMARIZE_LINES_FLAG
, 'N')) SUMMARIZE_LINES_FLAG
, 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_V'
, 'GL_DAS_CONSOLIDATION'
, TO_CHAR(CONS.CONSOLIDATION_ID)
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N')
, 'Y') VIEW_PRIVILEGE
, 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
, DECODE(CONS.SECURITY_FLAG
, 'Y'
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, 'GL_DAS_CONSOLIDATION_M'
, 'GL_DAS_CONSOLIDATION'
, TO_CHAR(CONS.CONSOLIDATION_ID)
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N')
, 'Y') MODIFY_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