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: JE.JE_UK_SALES_TRX_GT

Object Details

Object Name:	JE_UK_SALES_TRX_GT
Object Type:	TABLE
Owner:	JE
FND Design Data:	JE.JE_UK_SALES_TRX_GT
Subobject Name:
Status:	VALID

Temporary Table Details

JE.JE_UK_SALES_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:
PCT Free:	10
PCT Used:	40

Columns

Name	Datatype	Length
JE_INFO_V1	VARCHAR2	(4000)
JE_INFO_V2	VARCHAR2	(4000)
JE_INFO_V3	VARCHAR2	(4000)
JE_INFO_V4	VARCHAR2	(4000)
JE_INFO_V5	VARCHAR2	(4000)
JE_INFO_V6	VARCHAR2	(4000)
JE_INFO_V7	VARCHAR2	(4000)
JE_INFO_V8	VARCHAR2	(4000)
JE_INFO_V9	VARCHAR2	(4000)
JE_INFO_V10	VARCHAR2	(4000)
JE_INFO_V11	VARCHAR2	(4000)
JE_INFO_V12	VARCHAR2	(4000)
JE_INFO_V13	VARCHAR2	(4000)
JE_INFO_V14	VARCHAR2	(4000)
JE_INFO_V15	VARCHAR2	(4000)
JE_INFO_N1	NUMBER
JE_INFO_N2	NUMBER
JE_INFO_N3	NUMBER
JE_INFO_N4	NUMBER
JE_INFO_N5	NUMBER
JE_INFO_N6	NUMBER
JE_INFO_N7	NUMBER
JE_INFO_N8	NUMBER
JE_INFO_N9	NUMBER
JE_INFO_N10	NUMBER
JE_INFO_D1	DATE
JE_INFO_D2	DATE
JE_INFO_D3	DATE
JE_INFO_D4	DATE
JE_INFO_D5	DATE
JE_INFO_D6	DATE
JE_INFO_D7	DATE
JE_INFO_D8	DATE
JE_INFO_D9	DATE
JE_INFO_D10	DATE

Query Text

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


SELECT JE_INFO_V1
,      JE_INFO_V2
,      JE_INFO_V3
,      JE_INFO_V4
,      JE_INFO_V5
,      JE_INFO_V6
,      JE_INFO_V7
,      JE_INFO_V8
,      JE_INFO_V9
,      JE_INFO_V10
,      JE_INFO_V11
,      JE_INFO_V12
,      JE_INFO_V13
,      JE_INFO_V14
,      JE_INFO_V15
,      JE_INFO_N1
,      JE_INFO_N2
,      JE_INFO_N3
,      JE_INFO_N4
,      JE_INFO_N5
,      JE_INFO_N6
,      JE_INFO_N7
,      JE_INFO_N8
,      JE_INFO_N9
,      JE_INFO_N10
,      JE_INFO_D1
,      JE_INFO_D2
,      JE_INFO_D3
,      JE_INFO_D4
,      JE_INFO_D5
,      JE_INFO_D6
,      JE_INFO_D7
,      JE_INFO_D8
,      JE_INFO_D9
,      JE_INFO_D10
FROM JE.JE_UK_SALES_TRX_GT;

Dependencies

[top of page]

JE.JE_UK_SALES_TRX_GT does not reference any database object

JE.JE_UK_SALES_TRX_GT is referenced by following:

APPS: JE_UK_SALES_TRX_GT