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

TABLE: XLA.XLA_REPORT_BALANCES_GT

Object Details
Object Name: XLA_REPORT_BALANCES_GT
Object Type: TABLE
Owner: XLA
Subobject Name:
Status: VALID

Temporary Table Details

XLA.XLA_REPORT_BALANCES_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Columns
Name Datatype Length Mandatory Comments
LEDGER_ID NUMBER (15)
LEDGER_SHORT_NAME VARCHAR2 (20)
LEDGER_DESCRIPTION VARCHAR2 (240)
LEDGER_NAME VARCHAR2 (30)
LEDGER_CURRENCY VARCHAR2 (15)
LEGAL_ENTITY_ID NUMBER (15)
LEGAL_ENTITY_NAME VARCHAR2 (240)
LE_ADDRESS_LINE_1 VARCHAR2 (240)
LE_ADDRESS_LINE_2 VARCHAR2 (240)
LE_ADDRESS_LINE_3 VARCHAR2 (240)
LE_CITY VARCHAR2 (30)
LE_REGION_1 VARCHAR2 (120)
LE_REGION_2 VARCHAR2 (120)
LE_REGION_3 VARCHAR2 (120)
LE_POSTAL_CODE VARCHAR2 (30)
LE_COUNTRY VARCHAR2 (80)
LE_REGISTRATION_NUMBER VARCHAR2 (30)
LE_REGISTRATION_EFFECTIVE_FROM DATE

LE_ACTIVITY_CODE VARCHAR2 (150)
LE_SUB_ACTIVITY_CODE VARCHAR2 (150)
LE_CONTACT_NAME VARCHAR2 (240)
LE_CONTACT_PHONE_NUMBER VARCHAR2 (240)
LE_BR_DAILY_INSCRIPTION_NUMBER NUMBER

LE_BR_DAILY_INSCRIPTION_DATE DATE

LE_BR_DAILY_ENTITY VARCHAR2 (360)
LE_BR_DAILY_LOCATION VARCHAR2 (80)
LE_BR_DIRECTOR_NUMBER NUMBER

LE_BR_ACCOUNTANT_NUMBER NUMBER

LE_BR_ACCOUNTANT_NAME VARCHAR2 (360)
PARTY_TYPE_CODE VARCHAR2 (30)
PARTY_ID NUMBER (15)
PARTY_NUMBER VARCHAR2 (30)
PARTY_NAME VARCHAR2 (360)
PARTY_SITE_ID NUMBER (15)
PARTY_SITE_NUMBER VARCHAR2 (30)
PARTY_SITE_TAX_REGS_NUMBER VARCHAR2 (50)
PARTY_TYPE_TAXPAYER_ID VARCHAR2 (30)
PARTY_TAX_REGISTRATION_NUMBER VARCHAR2 (50)
PARTY_ADDRESS_1 VARCHAR2 (240)
PARTY_ADDRESS_2 VARCHAR2 (240)
PARTY_ADDRESS_3 VARCHAR2 (240)
PARTY_ADDRESS_4 VARCHAR2 (240)
PARTY_CITY VARCHAR2 (240)
PARTY_ZIP_CODE VARCHAR2 (240)
PARTY_STATE VARCHAR2 (240)
PARTY_PROVINCE VARCHAR2 (240)
PARTY_COUNTRY VARCHAR2 (240)
PARTY_COUNTY VARCHAR2 (240)
PARTY_SITE_NAME VARCHAR2 (240)
PARTY_SITE_ADDRESS_LINE_1 VARCHAR2 (240)
PARTY_SITE_ADDRESS_LINE_2 VARCHAR2 (240)
PARTY_SITE_ADDRESS_LINE_3 VARCHAR2 (240)
PARTY_SITE_ADDRESS_LINE_4 VARCHAR2 (240)
PARTY_SITE_CITY VARCHAR2 (240)
PARTY_SITE_ZIP_CODE VARCHAR2 (240)
PARTY_SITE_STATE VARCHAR2 (240)
PARTY_SITE_PROVINCE VARCHAR2 (240)
PARTY_SITE_COUNTRY VARCHAR2 (240)
PARTY_SITE_COUNTY VARCHAR2 (240)
APPLICATION_ID NUMBER (15)
APPLICATION_NAME VARCHAR2 (240)
JE_SOURCE_NAME VARCHAR2 (25)
PERIOD_YEAR NUMBER (15)
PERIOD_NUMBER NUMBER (15)
PERIOD_NAME VARCHAR2 (15)
PERIOD_START_DATE DATE

PERIOD_END_DATE DATE

BALANCE_TYPE_CODE VARCHAR2 (1)
BALANCE_TYPE VARCHAR2 (80)
BUDGET_VERSION_ID NUMBER

BUDGET_NAME VARCHAR2 (15)
ENCUMBRANCE_TYPE_ID NUMBER

ENCUMBRANCE_TYPE VARCHAR2 (30)
BEGIN_BALANCE_DR NUMBER

BEGIN_BALANCE_CR NUMBER

PERIOD_NET_DR NUMBER

PERIOD_NET_CR NUMBER

BEGIN_DRAFT_BALANCE_DR NUMBER

BEGIN_DRAFT_BALANCE_CR NUMBER

PERIOD_DRAFT_NET_DR NUMBER

PERIOD_DRAFT_NET_CR NUMBER

BEGIN_RUNNING_TOTAL_CR NUMBER

BEGIN_RUNNING_TOTAL_DR NUMBER

END_RUNNING_TOTAL_CR NUMBER

END_RUNNING_TOTAL_DR NUMBER

CODE_COMBINATION_ID NUMBER (15)
ACCOUNTING_CODE_COMBINATION VARCHAR2 (240)
CODE_COMBINATION_DESCRIPTION VARCHAR2 (4000)
CONTROL_ACCOUNT_FLAG VARCHAR2 (25)
CONTROL_ACCOUNT VARCHAR2 (80)
BALANCING_SEGMENT VARCHAR2 (25)
NATURAL_ACCOUNT_SEGMENT VARCHAR2 (25)
COST_CENTER_SEGMENT VARCHAR2 (25)
MANAGEMENT_SEGMENT VARCHAR2 (25)
INTERCOMPANY_SEGMENT VARCHAR2 (25)
BALANCING_SEGMENT_DESC VARCHAR2 (240)
NATURAL_ACCOUNT_DESC VARCHAR2 (240)
COST_CENTER_DESC VARCHAR2 (240)
MANAGEMENT_SEGMENT_DESC VARCHAR2 (240)
INTERCOMPANY_SEGMENT_DESC VARCHAR2 (240)
SEGMENT1 VARCHAR2 (25)
SEGMENT2 VARCHAR2 (25)
SEGMENT3 VARCHAR2 (25)
SEGMENT4 VARCHAR2 (25)
SEGMENT5 VARCHAR2 (25)
SEGMENT6 VARCHAR2 (25)
SEGMENT7 VARCHAR2 (25)
SEGMENT8 VARCHAR2 (25)
SEGMENT9 VARCHAR2 (25)
SEGMENT10 VARCHAR2 (25)
SEGMENT11 VARCHAR2 (25)
SEGMENT12 VARCHAR2 (25)
SEGMENT13 VARCHAR2 (25)
SEGMENT14 VARCHAR2 (25)
SEGMENT15 VARCHAR2 (25)
SEGMENT16 VARCHAR2 (25)
SEGMENT17 VARCHAR2 (25)
SEGMENT18 VARCHAR2 (25)
SEGMENT19 VARCHAR2 (25)
SEGMENT20 VARCHAR2 (25)
SEGMENT21 VARCHAR2 (25)
SEGMENT22 VARCHAR2 (25)
SEGMENT23 VARCHAR2 (25)
SEGMENT24 VARCHAR2 (25)
SEGMENT25 VARCHAR2 (25)
SEGMENT26 VARCHAR2 (25)
SEGMENT27 VARCHAR2 (25)
SEGMENT28 VARCHAR2 (25)
SEGMENT29 VARCHAR2 (25)
SEGMENT30 VARCHAR2 (25)
Query Text

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


SELECT LEDGER_ID
,      LEDGER_SHORT_NAME
,      LEDGER_DESCRIPTION
,      LEDGER_NAME
,      LEDGER_CURRENCY
,      LEGAL_ENTITY_ID
,      LEGAL_ENTITY_NAME
,      LE_ADDRESS_LINE_1
,      LE_ADDRESS_LINE_2
,      LE_ADDRESS_LINE_3
,      LE_CITY
,      LE_REGION_1
,      LE_REGION_2
,      LE_REGION_3
,      LE_POSTAL_CODE
,      LE_COUNTRY
,      LE_REGISTRATION_NUMBER
,      LE_REGISTRATION_EFFECTIVE_FROM
,      LE_ACTIVITY_CODE
,      LE_SUB_ACTIVITY_CODE
,      LE_CONTACT_NAME
,      LE_CONTACT_PHONE_NUMBER
,      LE_BR_DAILY_INSCRIPTION_NUMBER
,      LE_BR_DAILY_INSCRIPTION_DATE
,      LE_BR_DAILY_ENTITY
,      LE_BR_DAILY_LOCATION
,      LE_BR_DIRECTOR_NUMBER
,      LE_BR_ACCOUNTANT_NUMBER
,      LE_BR_ACCOUNTANT_NAME
,      PARTY_TYPE_CODE
,      PARTY_ID
,      PARTY_NUMBER
,      PARTY_NAME
,      PARTY_SITE_ID
,      PARTY_SITE_NUMBER
,      PARTY_SITE_TAX_REGS_NUMBER
,      PARTY_TYPE_TAXPAYER_ID
,      PARTY_TAX_REGISTRATION_NUMBER
,      PARTY_ADDRESS_1
,      PARTY_ADDRESS_2
,      PARTY_ADDRESS_3
,      PARTY_ADDRESS_4
,      PARTY_CITY
,      PARTY_ZIP_CODE
,      PARTY_STATE
,      PARTY_PROVINCE
,      PARTY_COUNTRY
,      PARTY_COUNTY
,      PARTY_SITE_NAME
,      PARTY_SITE_ADDRESS_LINE_1
,      PARTY_SITE_ADDRESS_LINE_2
,      PARTY_SITE_ADDRESS_LINE_3
,      PARTY_SITE_ADDRESS_LINE_4
,      PARTY_SITE_CITY
,      PARTY_SITE_ZIP_CODE
,      PARTY_SITE_STATE
,      PARTY_SITE_PROVINCE
,      PARTY_SITE_COUNTRY
,      PARTY_SITE_COUNTY
,      APPLICATION_ID
,      APPLICATION_NAME
,      JE_SOURCE_NAME
,      PERIOD_YEAR
,      PERIOD_NUMBER
,      PERIOD_NAME
,      PERIOD_START_DATE
,      PERIOD_END_DATE
,      BALANCE_TYPE_CODE
,      BALANCE_TYPE
,      BUDGET_VERSION_ID
,      BUDGET_NAME
,      ENCUMBRANCE_TYPE_ID
,      ENCUMBRANCE_TYPE
,      BEGIN_BALANCE_DR
,      BEGIN_BALANCE_CR
,      PERIOD_NET_DR
,      PERIOD_NET_CR
,      BEGIN_DRAFT_BALANCE_DR
,      BEGIN_DRAFT_BALANCE_CR
,      PERIOD_DRAFT_NET_DR
,      PERIOD_DRAFT_NET_CR
,      BEGIN_RUNNING_TOTAL_CR
,      BEGIN_RUNNING_TOTAL_DR
,      END_RUNNING_TOTAL_CR
,      END_RUNNING_TOTAL_DR
,      CODE_COMBINATION_ID
,      ACCOUNTING_CODE_COMBINATION
,      CODE_COMBINATION_DESCRIPTION
,      CONTROL_ACCOUNT_FLAG
,      CONTROL_ACCOUNT
,      BALANCING_SEGMENT
,      NATURAL_ACCOUNT_SEGMENT
,      COST_CENTER_SEGMENT
,      MANAGEMENT_SEGMENT
,      INTERCOMPANY_SEGMENT
,      BALANCING_SEGMENT_DESC
,      NATURAL_ACCOUNT_DESC
,      COST_CENTER_DESC
,      MANAGEMENT_SEGMENT_DESC
,      INTERCOMPANY_SEGMENT_DESC
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      SEGMENT21
,      SEGMENT22
,      SEGMENT23
,      SEGMENT24
,      SEGMENT25
,      SEGMENT26
,      SEGMENT27
,      SEGMENT28
,      SEGMENT29
,      SEGMENT30
FROM XLA.XLA_REPORT_BALANCES_GT;

Dependencies

[top of page]

XLA.XLA_REPORT_BALANCES_GT does not reference any database object

XLA.XLA_REPORT_BALANCES_GT is referenced by following:

SchemaAPPS
SynonymXLA_REPORT_BALANCES_GT