eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: JG.JGZZ_AR_TAX_GLOBAL_TMP

Object Details

Object Name:	JGZZ_AR_TAX_GLOBAL_TMP
Object Type:	TABLE
Owner:	JG
Subobject Name:
Status:	VALID

Temporary Table Details

JG.JGZZ_AR_TAX_GLOBAL_TMP 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:
PCT Free:	10
PCT Used:	40

Columns

Name	Datatype	Length
JG_INFO_V1	VARCHAR2	(240)
JG_INFO_V2	VARCHAR2	(240)
JG_INFO_V3	VARCHAR2	(240)
JG_INFO_V4	VARCHAR2	(150)
JG_INFO_V5	VARCHAR2	(150)
JG_INFO_V6	VARCHAR2	(150)
JG_INFO_V7	VARCHAR2	(150)
JG_INFO_V8	VARCHAR2	(150)
JG_INFO_V9	VARCHAR2	(150)
JG_INFO_V10	VARCHAR2	(150)
JG_INFO_V11	VARCHAR2	(150)
JG_INFO_V12	VARCHAR2	(150)
JG_INFO_V13	VARCHAR2	(150)
JG_INFO_V14	VARCHAR2	(150)
JG_INFO_V15	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_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_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_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.JGZZ_AR_TAX_GLOBAL_TMP;

Dependencies

[top of page]

JG.JGZZ_AR_TAX_GLOBAL_TMP does not reference any database object

JG.JGZZ_AR_TAX_GLOBAL_TMP is referenced by following:

APPS: JGZZ_AR_TAX_GLOBAL_TMP