[Home] [Help] [Dependency Information]

TABLE: XLA.XLA_REPORT_BALANCES_GT

Object Details

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:
PCT Free:	10
PCT Used:	40

Columns

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:

APPS

XLA_REPORT_BALANCES_GT