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

VIEW: XLA.XLA_ANALYTICAL_BALANCES#

Object Details
Object Name: XLA_ANALYTICAL_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_DETAIL_VALUE_ID NUMBER (15) Yes
PERIOD_NAME VARCHAR2 (15) Yes
BEGINNING_BALANCE_DR NUMBER

BEGINNING_BALANCE_CR NUMBER

PERIOD_BALANCE_DR NUMBER

PERIOD_BALANCE_CR NUMBER

DRAFT_BEGINNING_BALANCE_DR NUMBER

DRAFT_BEGINNING_BALANCE_CR NUMBER

PERIOD_DRAFT_BALANCE_DR NUMBER

PERIOD_DRAFT_BALANCE_CR NUMBER

INITIAL_BALANCE_FLAG VARCHAR2 (1)
FIRST_PERIOD_FLAG VARCHAR2 (1)
PERIOD_YEAR NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
PROGRAM_UPDATE_DATE DATE

PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
REQUEST_ID NUMBER (15)
Query Text

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


SELECT APPLICATION_ID
,      LEDGER_ID
,      CODE_COMBINATION_ID
,      ANALYTICAL_DETAIL_VALUE_ID
,      PERIOD_NAME
,      BEGINNING_BALANCE_DR
,      BEGINNING_BALANCE_CR
,      PERIOD_BALANCE_DR
,      PERIOD_BALANCE_CR
,      DRAFT_BEGINNING_BALANCE_DR
,      DRAFT_BEGINNING_BALANCE_CR
,      PERIOD_DRAFT_BALANCE_DR
,      PERIOD_DRAFT_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
FROM XLA.XLA_ANALYTICAL_BALANCES#;

Dependencies

[top of page]

XLA.XLA_ANALYTICAL_BALANCES# references the following:

SchemaXLA
TableXLA_ANALYTICAL_BALANCES
XLA.XLA_ANALYTICAL_BALANCES# is referenced by following:

SchemaAPPS
SynonymXLA_ANALYTICAL_BALANCES