VIEW: GL.GL_CONSOLIDATION#

Source

View Text - Preformatted

select CONSOLIDATION_ID CONSOLIDATION_ID, TO_LEDGER_ID TO_LEDGER_ID, FROM_LEDGER_ID FROM_LEDGER_ID, NAME NAME, USAGE_CODE USAGE_CODE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, RUN_JOURNAL_IMPORT_FLAG RUN_JOURNAL_IMPORT_FLAG, SUMMARIZE_LINES_FLAG SUMMARIZE_LINES_FLAG, AUDIT_MODE_FLAG AUDIT_MODE_FLAG, DESCRIPTION DESCRIPTION, METHOD METHOD, FROM_CURRENCY_CODE FROM_CURRENCY_CODE, START_DATE_ACTIVE_11I START_DATE_ACTIVE_11I, END_DATE_ACTIVE_11I END_DATE_ACTIVE_11I, FROM_LOCATION FROM_LOCATION, FROM_ORACLE_ID FROM_ORACLE_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CONTEXT CONTEXT, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, RUN_POSTING_FLAG RUN_POSTING_FLAG, COA_MAPPING_ID COA_MAPPING_ID, SECURITY_FLAG SECURITY_FLAG from "GL"."GL_CONSOLIDATION"

View Text - HTML Formatted

SELECT CONSOLIDATION_ID CONSOLIDATION_ID
, TO_LEDGER_ID TO_LEDGER_ID
, FROM_LEDGER_ID FROM_LEDGER_ID
, NAME NAME
, USAGE_CODE USAGE_CODE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, RUN_JOURNAL_IMPORT_FLAG RUN_JOURNAL_IMPORT_FLAG
, SUMMARIZE_LINES_FLAG SUMMARIZE_LINES_FLAG
, AUDIT_MODE_FLAG AUDIT_MODE_FLAG
, DESCRIPTION DESCRIPTION
, METHOD METHOD
, FROM_CURRENCY_CODE FROM_CURRENCY_CODE
, START_DATE_ACTIVE_11I START_DATE_ACTIVE_11I
, END_DATE_ACTIVE_11I END_DATE_ACTIVE_11I
, FROM_LOCATION FROM_LOCATION
, FROM_ORACLE_ID FROM_ORACLE_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CONTEXT CONTEXT
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, RUN_POSTING_FLAG RUN_POSTING_FLAG
, COA_MAPPING_ID COA_MAPPING_ID
, SECURITY_FLAG SECURITY_FLAG
FROM "GL"."GL_CONSOLIDATION"