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

TABLE: JA.JAI_CR_OPEN_BALANCES_GT

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

The table 'JAI_CR_OPEN_BALANCES_GT' is a global temporary table. It is used for India - Creditors Ledger report of calculating the opening balance

Temporary Table Details

JA.JAI_CR_OPEN_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$TRANSACTION. 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
OPENING_BALANCE_CR NUMBER

Opening balance of liabilities account on credit direction
OPENING_BALANCE_DR NUMBER

Opening balance of liabilities account on debit direction
ORG_ID NUMBER (15)
Opertion Unit ID
VENDOR_ID NUMBER (15)
Supplier ID
VENDOR_SITE_ID NUMBER (15)
Supplier site ID
Query Text

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


SELECT OPENING_BALANCE_CR
,      OPENING_BALANCE_DR
,      ORG_ID
,      VENDOR_ID
,      VENDOR_SITE_ID
FROM JA.JAI_CR_OPEN_BALANCES_GT;

Dependencies

[top of page]

JA.JAI_CR_OPEN_BALANCES_GT does not reference any database object

JA.JAI_CR_OPEN_BALANCES_GT is referenced by following:

SchemaAPPS
SynonymJAI_CR_OPEN_BALANCES_GT