[Home] [Help] [Dependency Information]
Object Name: | JA_CN_LEDGER_LE_BSV_GT |
---|---|
Object Type: | TABLE |
Owner: | JA |
FND Design Data: | JA.JA_CN_LEDGER_LE_BSV_GT |
Subobject Name: | |
Status: | VALID |
JA_CN_LEDGER_LE_BSV_GT is a global temporary table. This table is used to populate Balance Segment Values for current Legal Entity and Ledger in runtime, which have been assigned to current Legal Entity as well as the Ledger in Accounting Setup page.
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.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JA_CN_LEDGER_LE_BSV_GT_N1 | NORMAL | NONUNIQUE |
LEDGER_ID
BAL_SEG_VALUE LEGAL_ENTITY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LEDGER_ID | NUMBER | (15) | Yes | Identify of Ledger |
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 | Identify of legal Entity |
START_DATE | DATE | Effective start date of the BSV | ||
END_DATE | DATE | Effective end date of the BSV |
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;
JA.JA_CN_LEDGER_LE_BSV_GT does not reference any database object
JA.JA_CN_LEDGER_LE_BSV_GT is referenced by following:
|
|
|