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

TABLE: JA.JAI_TRX_GT

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

Temporary Table Details

JA.JAI_TRX_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
JAI_INFO_V1 VARCHAR2 (240)
JAI_INFO_V2 VARCHAR2 (240)
JAI_INFO_V3 VARCHAR2 (240)
JAI_INFO_V4 VARCHAR2 (240)
JAI_INFO_V5 VARCHAR2 (240)
JAI_INFO_V6 VARCHAR2 (240)
JAI_INFO_V7 VARCHAR2 (240)
JAI_INFO_V8 VARCHAR2 (240)
JAI_INFO_V9 VARCHAR2 (240)
JAI_INFO_V10 VARCHAR2 (240)
JAI_INFO_V11 VARCHAR2 (240)
JAI_INFO_V12 VARCHAR2 (240)
JAI_INFO_V13 VARCHAR2 (240)
JAI_INFO_V14 VARCHAR2 (240)
JAI_INFO_V15 VARCHAR2 (240)
JAI_INFO_V16 VARCHAR2 (240)
JAI_INFO_V17 VARCHAR2 (240)
JAI_INFO_V18 VARCHAR2 (240)
JAI_INFO_V19 VARCHAR2 (240)
JAI_INFO_V20 VARCHAR2 (240)
JAI_INFO_V21 VARCHAR2 (240)
JAI_INFO_V22 VARCHAR2 (240)
JAI_INFO_V23 VARCHAR2 (240)
JAI_INFO_V24 VARCHAR2 (240)
JAI_INFO_V25 VARCHAR2 (240)
JAI_INFO_V26 VARCHAR2 (240)
JAI_INFO_V27 VARCHAR2 (240)
JAI_INFO_V28 VARCHAR2 (240)
JAI_INFO_V29 VARCHAR2 (240)
JAI_INFO_V30 VARCHAR2 (240)
JAI_INFO_N1 NUMBER

JAI_INFO_N2 NUMBER

JAI_INFO_N3 NUMBER

JAI_INFO_N4 NUMBER

JAI_INFO_N5 NUMBER

JAI_INFO_N6 NUMBER

JAI_INFO_N7 NUMBER

JAI_INFO_N8 NUMBER

JAI_INFO_N9 NUMBER

JAI_INFO_N10 NUMBER

JAI_INFO_N11 NUMBER

JAI_INFO_N12 NUMBER

JAI_INFO_N13 NUMBER

JAI_INFO_N14 NUMBER

JAI_INFO_N15 NUMBER

JAI_INFO_N16 NUMBER

JAI_INFO_N17 NUMBER

JAI_INFO_N18 NUMBER

JAI_INFO_N19 NUMBER

JAI_INFO_N20 NUMBER

JAI_INFO_N21 NUMBER

JAI_INFO_N22 NUMBER

JAI_INFO_N23 NUMBER

JAI_INFO_N24 NUMBER

JAI_INFO_N25 NUMBER

JAI_INFO_N26 NUMBER

JAI_INFO_N27 NUMBER

JAI_INFO_N28 NUMBER

JAI_INFO_N29 NUMBER

JAI_INFO_N30 NUMBER

JAI_INFO_D1 DATE

JAI_INFO_D2 DATE

JAI_INFO_D3 DATE

JAI_INFO_D4 DATE

JAI_INFO_D5 DATE

JAI_INFO_D6 DATE

JAI_INFO_D7 DATE

JAI_INFO_D8 DATE

JAI_INFO_D9 DATE

JAI_INFO_D10 DATE

JAI_INFO_D11 DATE

JAI_INFO_D12 DATE

JAI_INFO_D13 DATE

JAI_INFO_D14 DATE

JAI_INFO_D15 DATE

JAI_INFO_D16 DATE

JAI_INFO_D17 DATE

JAI_INFO_D18 DATE

JAI_INFO_D19 DATE

JAI_INFO_D20 DATE

JAI_INFO_D21 DATE

JAI_INFO_D22 DATE

JAI_INFO_D23 DATE

JAI_INFO_D24 DATE

JAI_INFO_D25 DATE

JAI_INFO_D26 DATE

JAI_INFO_D27 DATE

JAI_INFO_D28 DATE

JAI_INFO_D29 DATE

JAI_INFO_D30 DATE

Query Text

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


SELECT JAI_INFO_V1
,      JAI_INFO_V2
,      JAI_INFO_V3
,      JAI_INFO_V4
,      JAI_INFO_V5
,      JAI_INFO_V6
,      JAI_INFO_V7
,      JAI_INFO_V8
,      JAI_INFO_V9
,      JAI_INFO_V10
,      JAI_INFO_V11
,      JAI_INFO_V12
,      JAI_INFO_V13
,      JAI_INFO_V14
,      JAI_INFO_V15
,      JAI_INFO_V16
,      JAI_INFO_V17
,      JAI_INFO_V18
,      JAI_INFO_V19
,      JAI_INFO_V20
,      JAI_INFO_V21
,      JAI_INFO_V22
,      JAI_INFO_V23
,      JAI_INFO_V24
,      JAI_INFO_V25
,      JAI_INFO_V26
,      JAI_INFO_V27
,      JAI_INFO_V28
,      JAI_INFO_V29
,      JAI_INFO_V30
,      JAI_INFO_N1
,      JAI_INFO_N2
,      JAI_INFO_N3
,      JAI_INFO_N4
,      JAI_INFO_N5
,      JAI_INFO_N6
,      JAI_INFO_N7
,      JAI_INFO_N8
,      JAI_INFO_N9
,      JAI_INFO_N10
,      JAI_INFO_N11
,      JAI_INFO_N12
,      JAI_INFO_N13
,      JAI_INFO_N14
,      JAI_INFO_N15
,      JAI_INFO_N16
,      JAI_INFO_N17
,      JAI_INFO_N18
,      JAI_INFO_N19
,      JAI_INFO_N20
,      JAI_INFO_N21
,      JAI_INFO_N22
,      JAI_INFO_N23
,      JAI_INFO_N24
,      JAI_INFO_N25
,      JAI_INFO_N26
,      JAI_INFO_N27
,      JAI_INFO_N28
,      JAI_INFO_N29
,      JAI_INFO_N30
,      JAI_INFO_D1
,      JAI_INFO_D2
,      JAI_INFO_D3
,      JAI_INFO_D4
,      JAI_INFO_D5
,      JAI_INFO_D6
,      JAI_INFO_D7
,      JAI_INFO_D8
,      JAI_INFO_D9
,      JAI_INFO_D10
,      JAI_INFO_D11
,      JAI_INFO_D12
,      JAI_INFO_D13
,      JAI_INFO_D14
,      JAI_INFO_D15
,      JAI_INFO_D16
,      JAI_INFO_D17
,      JAI_INFO_D18
,      JAI_INFO_D19
,      JAI_INFO_D20
,      JAI_INFO_D21
,      JAI_INFO_D22
,      JAI_INFO_D23
,      JAI_INFO_D24
,      JAI_INFO_D25
,      JAI_INFO_D26
,      JAI_INFO_D27
,      JAI_INFO_D28
,      JAI_INFO_D29
,      JAI_INFO_D30
FROM JA.JAI_TRX_GT;

Dependencies

[top of page]

JA.JAI_TRX_GT does not reference any database object

JA.JAI_TRX_GT is referenced by following:

SchemaAPPS
SynonymJAI_TRX_GT