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

TABLE: JG.JG_ZZ_VAT_TRX_GT

Object Details
Object Name: JG_ZZ_VAT_TRX_GT
Object Type: TABLE
Owner: JG
FND Design Data: TableJG.JG_ZZ_VAT_TRX_GT
Subobject Name:
Status: VALID

Temporary Table Details

JG.JG_ZZ_VAT_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
JG_INFO_V1 VARCHAR2 (240)
JG_INFO_V2 VARCHAR2 (240)
JG_INFO_V3 VARCHAR2 (240)
JG_INFO_V4 VARCHAR2 (240)
JG_INFO_V5 VARCHAR2 (240)
JG_INFO_V6 VARCHAR2 (1996)
JG_INFO_V7 VARCHAR2 (240)
JG_INFO_V8 VARCHAR2 (240)
JG_INFO_V9 VARCHAR2 (1996)
JG_INFO_V10 VARCHAR2 (1996)
JG_INFO_V11 VARCHAR2 (150)
JG_INFO_V12 VARCHAR2 (150)
JG_INFO_V13 VARCHAR2 (150)
JG_INFO_V14 VARCHAR2 (150)
JG_INFO_V15 VARCHAR2 (1996)
JG_INFO_V16 VARCHAR2 (150)
JG_INFO_V17 VARCHAR2 (1996)
JG_INFO_V18 VARCHAR2 (150)
JG_INFO_V19 VARCHAR2 (150)
JG_INFO_V20 VARCHAR2 (150)
JG_INFO_V21 VARCHAR2 (150)
JG_INFO_V22 VARCHAR2 (150)
JG_INFO_V23 VARCHAR2 (150)
JG_INFO_V24 VARCHAR2 (150)
JG_INFO_V25 VARCHAR2 (150)
JG_INFO_V26 VARCHAR2 (150)
JG_INFO_V27 VARCHAR2 (150)
JG_INFO_V28 VARCHAR2 (150)
JG_INFO_V29 VARCHAR2 (150)
JG_INFO_V30 VARCHAR2 (150)
JG_INFO_V31 VARCHAR2 (150)
JG_INFO_V32 VARCHAR2 (1996)
JG_INFO_V33 VARCHAR2 (150)
JG_INFO_V34 VARCHAR2 (150)
JG_INFO_V35 VARCHAR2 (150)
JG_INFO_V36 VARCHAR2 (150)
JG_INFO_V37 VARCHAR2 (150)
JG_INFO_V38 VARCHAR2 (150)
JG_INFO_V39 VARCHAR2 (150)
JG_INFO_V40 VARCHAR2 (150)
JG_INFO_N1 NUMBER

JG_INFO_N2 NUMBER

JG_INFO_N3 NUMBER

JG_INFO_N4 NUMBER

JG_INFO_N5 NUMBER

JG_INFO_N6 NUMBER

JG_INFO_N7 NUMBER

JG_INFO_N8 NUMBER

JG_INFO_N9 NUMBER

JG_INFO_N10 NUMBER

JG_INFO_N11 NUMBER

JG_INFO_N12 NUMBER

JG_INFO_N13 NUMBER

JG_INFO_N14 NUMBER

JG_INFO_N15 NUMBER

JG_INFO_N16 NUMBER

JG_INFO_N17 NUMBER

JG_INFO_N18 NUMBER

JG_INFO_N19 NUMBER

JG_INFO_N20 NUMBER

JG_INFO_N21 NUMBER

JG_INFO_N22 NUMBER

JG_INFO_N23 NUMBER

JG_INFO_N24 NUMBER

JG_INFO_N25 NUMBER

JG_INFO_N26 NUMBER

JG_INFO_N27 NUMBER

JG_INFO_N28 NUMBER

JG_INFO_N29 NUMBER

JG_INFO_N30 NUMBER

JG_INFO_D1 DATE

JG_INFO_D2 DATE

JG_INFO_D3 DATE

JG_INFO_D4 DATE

JG_INFO_D5 DATE

JG_INFO_D6 DATE

JG_INFO_D7 DATE

JG_INFO_D8 DATE

JG_INFO_D9 DATE

JG_INFO_D10 DATE

JG_INFO_D11 DATE

JG_INFO_D12 DATE

JG_INFO_D13 DATE

JG_INFO_D14 DATE

JG_INFO_D15 DATE

Query Text

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


SELECT JG_INFO_V1
,      JG_INFO_V2
,      JG_INFO_V3
,      JG_INFO_V4
,      JG_INFO_V5
,      JG_INFO_V6
,      JG_INFO_V7
,      JG_INFO_V8
,      JG_INFO_V9
,      JG_INFO_V10
,      JG_INFO_V11
,      JG_INFO_V12
,      JG_INFO_V13
,      JG_INFO_V14
,      JG_INFO_V15
,      JG_INFO_V16
,      JG_INFO_V17
,      JG_INFO_V18
,      JG_INFO_V19
,      JG_INFO_V20
,      JG_INFO_V21
,      JG_INFO_V22
,      JG_INFO_V23
,      JG_INFO_V24
,      JG_INFO_V25
,      JG_INFO_V26
,      JG_INFO_V27
,      JG_INFO_V28
,      JG_INFO_V29
,      JG_INFO_V30
,      JG_INFO_V31
,      JG_INFO_V32
,      JG_INFO_V33
,      JG_INFO_V34
,      JG_INFO_V35
,      JG_INFO_V36
,      JG_INFO_V37
,      JG_INFO_V38
,      JG_INFO_V39
,      JG_INFO_V40
,      JG_INFO_N1
,      JG_INFO_N2
,      JG_INFO_N3
,      JG_INFO_N4
,      JG_INFO_N5
,      JG_INFO_N6
,      JG_INFO_N7
,      JG_INFO_N8
,      JG_INFO_N9
,      JG_INFO_N10
,      JG_INFO_N11
,      JG_INFO_N12
,      JG_INFO_N13
,      JG_INFO_N14
,      JG_INFO_N15
,      JG_INFO_N16
,      JG_INFO_N17
,      JG_INFO_N18
,      JG_INFO_N19
,      JG_INFO_N20
,      JG_INFO_N21
,      JG_INFO_N22
,      JG_INFO_N23
,      JG_INFO_N24
,      JG_INFO_N25
,      JG_INFO_N26
,      JG_INFO_N27
,      JG_INFO_N28
,      JG_INFO_N29
,      JG_INFO_N30
,      JG_INFO_D1
,      JG_INFO_D2
,      JG_INFO_D3
,      JG_INFO_D4
,      JG_INFO_D5
,      JG_INFO_D6
,      JG_INFO_D7
,      JG_INFO_D8
,      JG_INFO_D9
,      JG_INFO_D10
,      JG_INFO_D11
,      JG_INFO_D12
,      JG_INFO_D13
,      JG_INFO_D14
,      JG_INFO_D15
FROM JG.JG_ZZ_VAT_TRX_GT;

Dependencies

[top of page]

JG.JG_ZZ_VAT_TRX_GT does not reference any database object

JG.JG_ZZ_VAT_TRX_GT is referenced by following:

SchemaAPPS
SynonymJG_ZZ_VAT_TRX_GT