VIEW: XLA.XLA_AC_BALANCES#

Source

View Text - Preformatted

select APPLICATION_ID APPLICATION_ID, LEDGER_ID LEDGER_ID, CODE_COMBINATION_ID CODE_COMBINATION_ID, ANALYTICAL_CRITERION_CODE ANALYTICAL_CRITERION_CODE, ANALYTICAL_CRITERION_TYPE_CODE ANALYTICAL_CRITERION_TYPE_CODE, AMB_CONTEXT_CODE AMB_CONTEXT_CODE, AC1 AC1, AC2 AC2, AC3 AC3, AC4 AC4, AC5 AC5, PERIOD_NAME PERIOD_NAME, BEGINNING_BALANCE_DR BEGINNING_BALANCE_DR, BEGINNING_BALANCE_CR BEGINNING_BALANCE_CR, PERIOD_BALANCE_DR PERIOD_BALANCE_DR, PERIOD_BALANCE_CR PERIOD_BALANCE_CR, INITIAL_BALANCE_FLAG INITIAL_BALANCE_FLAG, FIRST_PERIOD_FLAG FIRST_PERIOD_FLAG, PERIOD_YEAR PERIOD_YEAR, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, REQUEST_ID REQUEST_ID, EFFECTIVE_PERIOD_NUM EFFECTIVE_PERIOD_NUM from "XLA"."XLA_AC_BALANCES"

View Text - HTML Formatted

SELECT APPLICATION_ID APPLICATION_ID
, LEDGER_ID LEDGER_ID
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, ANALYTICAL_CRITERION_CODE ANALYTICAL_CRITERION_CODE
, ANALYTICAL_CRITERION_TYPE_CODE ANALYTICAL_CRITERION_TYPE_CODE
, AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, AC1 AC1
, AC2 AC2
, AC3 AC3
, AC4 AC4
, AC5 AC5
, PERIOD_NAME PERIOD_NAME
, BEGINNING_BALANCE_DR BEGINNING_BALANCE_DR
, BEGINNING_BALANCE_CR BEGINNING_BALANCE_CR
, PERIOD_BALANCE_DR PERIOD_BALANCE_DR
, PERIOD_BALANCE_CR PERIOD_BALANCE_CR
, INITIAL_BALANCE_FLAG INITIAL_BALANCE_FLAG
, FIRST_PERIOD_FLAG FIRST_PERIOD_FLAG
, PERIOD_YEAR PERIOD_YEAR
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, REQUEST_ID REQUEST_ID
, EFFECTIVE_PERIOD_NUM EFFECTIVE_PERIOD_NUM
FROM "XLA"."XLA_AC_BALANCES"