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

TABLE: JA.JA_CN_LEDGER_LE_BSV_GT

Object Details
Object Name: JA_CN_LEDGER_LE_BSV_GT
Object Type: TABLE
Owner: JA
FND Design Data: TableJA.JA_CN_LEDGER_LE_BSV_GT
Subobject Name:
Status: VALID

JA_CN_LEDGER_LE_BSV_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.

Temporary Table Details

JA.JA_CN_LEDGER_LE_BSV_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
Indexes
Index Type Uniqueness Tablespace Column
JA_CN_LEDGER_LE_BSV_GT_N1 NORMAL NONUNIQUE Tablespace ColumnLEDGER_ID
ColumnBAL_SEG_VALUE
ColumnLEGAL_ENTITY_ID
Columns
Name Datatype Length Mandatory Comments
LEDGER_ID NUMBER (15) Yes Ledger ID
LEDGER_CATEGORY_CODE VARCHAR2 (30) Yes Ledger category
CHART_OF_ACCOUNTS_ID NUMBER (15) Yes Chart of Accounts ID
BAL_SEG_VALUE_OPTION_CODE VARCHAR2 (1) Yes Balance segment value option
BAL_SEG_VALUE_SET_ID NUMBER (15) Yes Value set ID of balance segment
BAL_SEG_VALUE VARCHAR2 (25) Yes Balance segment value
LEGAL_ENTITY_ID NUMBER (15) Yes Legal Entity ID
START_DATE DATE

Effective start date of the BSV
END_DATE DATE

Effective end date of the BSV
Query Text

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


SELECT LEDGER_ID
,      LEDGER_CATEGORY_CODE
,      CHART_OF_ACCOUNTS_ID
,      BAL_SEG_VALUE_OPTION_CODE
,      BAL_SEG_VALUE_SET_ID
,      BAL_SEG_VALUE
,      LEGAL_ENTITY_ID
,      START_DATE
,      END_DATE
FROM JA.JA_CN_LEDGER_LE_BSV_GT;

Dependencies

[top of page]

JA.JA_CN_LEDGER_LE_BSV_GT does not reference any database object

JA.JA_CN_LEDGER_LE_BSV_GT is referenced by following:

SchemaAPPS
SynonymJA_CN_LEDGER_LE_BSV_GT