Skip to content

DBA Data[Home] [Help] [Dependency Information]

VIEW: XLA.XLA_AC_BALANCES#

Object Details
Object Name: XLA_AC_BALANCES#
Object Type: VIEW
Owner: XLA
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Yes
LEDGER_ID NUMBER (15) Yes
CODE_COMBINATION_ID NUMBER (15) Yes
ANALYTICAL_CRITERION_CODE VARCHAR2 (30) Yes
ANALYTICAL_CRITERION_TYPE_CODE VARCHAR2 (1) Yes
AMB_CONTEXT_CODE VARCHAR2 (30) Yes
AC1 VARCHAR2 (30)
AC2 VARCHAR2 (30)
AC3 VARCHAR2 (30)
AC4 VARCHAR2 (30)
AC5 VARCHAR2 (30)
PERIOD_NAME VARCHAR2 (15) Yes
BEGINNING_BALANCE_DR NUMBER

BEGINNING_BALANCE_CR NUMBER

PERIOD_BALANCE_DR NUMBER

PERIOD_BALANCE_CR NUMBER

INITIAL_BALANCE_FLAG VARCHAR2 (1)
FIRST_PERIOD_FLAG VARCHAR2 (1)
PERIOD_YEAR NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
PROGRAM_UPDATE_DATE DATE

PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
REQUEST_ID NUMBER (15)
EFFECTIVE_PERIOD_NUM NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

XLA.XLA_AC_BALANCES# references the following:

SchemaXLA
TableXLA_AC_BALANCES
XLA.XLA_AC_BALANCES# is referenced by following:

SchemaAPPS
SynonymXLA_AC_BALANCES