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: APPS.JTY_TERR_1500_CNTRCT_TRANS_GT

Object Details

Object Name:	JTY_TERR_1500_CNTRCT_TRANS_GT
Object Type:	TABLE
Owner:	APPS
FND Design Data:	JTF.JTY_TERR_1500_CNTRCT_TRANS_GT
Subobject Name:
Status:	VALID

Temporary Table Details

APPS.JTY_TERR_1500_CNTRCT_TRANS_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$SESSION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Columns

Name	Datatype	Length
USE_TYPE	VARCHAR2	(30)
SOURCE_ID	NUMBER
TRANSACTION_ID	NUMBER
TRANS_OBJECT_ID	NUMBER
TRANS_DETAIL_OBJECT_ID	NUMBER
SQUAL_CHAR01	VARCHAR2	(360)
SQUAL_CHAR02	VARCHAR2	(360)
SQUAL_CHAR03	VARCHAR2	(360)
SQUAL_CHAR04	VARCHAR2	(360)
SQUAL_CHAR05	VARCHAR2	(360)
SQUAL_CHAR06	VARCHAR2	(360)
SQUAL_CHAR07	VARCHAR2	(360)
SQUAL_CHAR08	VARCHAR2	(360)
SQUAL_CHAR09	VARCHAR2	(360)
SQUAL_CHAR10	VARCHAR2	(360)
SQUAL_CHAR11	VARCHAR2	(360)
SQUAL_CHAR12	VARCHAR2	(360)
SQUAL_CHAR13	VARCHAR2	(360)
SQUAL_CHAR14	VARCHAR2	(360)
SQUAL_CHAR15	VARCHAR2	(360)
SQUAL_CHAR16	VARCHAR2	(360)
SQUAL_CHAR17	VARCHAR2	(360)
SQUAL_CHAR18	VARCHAR2	(360)
SQUAL_CHAR19	VARCHAR2	(360)
SQUAL_CHAR20	VARCHAR2	(360)
SQUAL_CHAR21	VARCHAR2	(360)
SQUAL_CHAR22	VARCHAR2	(360)
SQUAL_CHAR23	VARCHAR2	(360)
SQUAL_CHAR24	VARCHAR2	(360)
SQUAL_CHAR25	VARCHAR2	(360)
SQUAL_CHAR26	VARCHAR2	(360)
SQUAL_CHAR27	VARCHAR2	(360)
SQUAL_CHAR28	VARCHAR2	(360)
SQUAL_CHAR29	VARCHAR2	(360)
SQUAL_CHAR30	VARCHAR2	(360)
SQUAL_CHAR31	VARCHAR2	(360)
SQUAL_CHAR32	VARCHAR2	(360)
SQUAL_CHAR33	VARCHAR2	(360)
SQUAL_CHAR34	VARCHAR2	(360)
SQUAL_CHAR35	VARCHAR2	(360)
SQUAL_CHAR36	VARCHAR2	(360)
SQUAL_CHAR37	VARCHAR2	(360)
SQUAL_CHAR38	VARCHAR2	(360)
SQUAL_CHAR39	VARCHAR2	(360)
SQUAL_CHAR40	VARCHAR2	(360)
SQUAL_CHAR41	VARCHAR2	(360)
SQUAL_CHAR42	VARCHAR2	(360)
SQUAL_CHAR43	VARCHAR2	(360)
SQUAL_CHAR44	VARCHAR2	(360)
SQUAL_CHAR45	VARCHAR2	(360)
SQUAL_CHAR46	VARCHAR2	(360)
SQUAL_CHAR47	VARCHAR2	(360)
SQUAL_CHAR48	VARCHAR2	(360)
SQUAL_CHAR49	VARCHAR2	(360)
SQUAL_CHAR50	VARCHAR2	(360)
SQUAL_NUM01	NUMBER
SQUAL_NUM02	NUMBER
SQUAL_NUM03	NUMBER
SQUAL_NUM04	NUMBER
SQUAL_NUM05	NUMBER
SQUAL_NUM06	NUMBER
SQUAL_NUM07	NUMBER
SQUAL_NUM08	NUMBER
SQUAL_NUM09	NUMBER
SQUAL_NUM10	NUMBER
SQUAL_NUM11	NUMBER
SQUAL_NUM12	NUMBER
SQUAL_NUM13	NUMBER
SQUAL_NUM14	NUMBER
SQUAL_NUM15	NUMBER
SQUAL_NUM16	NUMBER
SQUAL_NUM17	NUMBER
SQUAL_NUM18	NUMBER
SQUAL_NUM19	NUMBER
SQUAL_NUM20	NUMBER
SQUAL_NUM21	NUMBER
SQUAL_NUM22	NUMBER
SQUAL_NUM23	NUMBER
SQUAL_NUM24	NUMBER
SQUAL_NUM25	NUMBER
SQUAL_NUM26	NUMBER
SQUAL_NUM27	NUMBER
SQUAL_NUM28	NUMBER
SQUAL_NUM29	NUMBER
SQUAL_NUM30	NUMBER
SQUAL_NUM31	NUMBER
SQUAL_NUM32	NUMBER
SQUAL_NUM33	NUMBER
SQUAL_NUM34	NUMBER
SQUAL_NUM35	NUMBER
SQUAL_NUM36	NUMBER
SQUAL_NUM37	NUMBER
SQUAL_NUM38	NUMBER
SQUAL_NUM39	NUMBER
SQUAL_NUM40	NUMBER
SQUAL_NUM41	NUMBER
SQUAL_NUM42	NUMBER
SQUAL_NUM43	NUMBER
SQUAL_NUM44	NUMBER
SQUAL_NUM45	NUMBER
SQUAL_NUM46	NUMBER
SQUAL_NUM47	NUMBER
SQUAL_NUM48	NUMBER
SQUAL_NUM49	NUMBER
SQUAL_NUM50	NUMBER
SQUAL_CURC01	VARCHAR2	(360)
SQUAL_CURC02	VARCHAR2	(360)
SQUAL_CURC03	VARCHAR2	(360)
SQUAL_CURC04	VARCHAR2	(360)
SQUAL_CURC05	VARCHAR2	(360)
TXN_DATE	DATE

Query Text

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


SELECT USE_TYPE
,      SOURCE_ID
,      TRANSACTION_ID
,      TRANS_OBJECT_ID
,      TRANS_DETAIL_OBJECT_ID
,      SQUAL_CHAR01
,      SQUAL_CHAR02
,      SQUAL_CHAR03
,      SQUAL_CHAR04
,      SQUAL_CHAR05
,      SQUAL_CHAR06
,      SQUAL_CHAR07
,      SQUAL_CHAR08
,      SQUAL_CHAR09
,      SQUAL_CHAR10
,      SQUAL_CHAR11
,      SQUAL_CHAR12
,      SQUAL_CHAR13
,      SQUAL_CHAR14
,      SQUAL_CHAR15
,      SQUAL_CHAR16
,      SQUAL_CHAR17
,      SQUAL_CHAR18
,      SQUAL_CHAR19
,      SQUAL_CHAR20
,      SQUAL_CHAR21
,      SQUAL_CHAR22
,      SQUAL_CHAR23
,      SQUAL_CHAR24
,      SQUAL_CHAR25
,      SQUAL_CHAR26
,      SQUAL_CHAR27
,      SQUAL_CHAR28
,      SQUAL_CHAR29
,      SQUAL_CHAR30
,      SQUAL_CHAR31
,      SQUAL_CHAR32
,      SQUAL_CHAR33
,      SQUAL_CHAR34
,      SQUAL_CHAR35
,      SQUAL_CHAR36
,      SQUAL_CHAR37
,      SQUAL_CHAR38
,      SQUAL_CHAR39
,      SQUAL_CHAR40
,      SQUAL_CHAR41
,      SQUAL_CHAR42
,      SQUAL_CHAR43
,      SQUAL_CHAR44
,      SQUAL_CHAR45
,      SQUAL_CHAR46
,      SQUAL_CHAR47
,      SQUAL_CHAR48
,      SQUAL_CHAR49
,      SQUAL_CHAR50
,      SQUAL_NUM01
,      SQUAL_NUM02
,      SQUAL_NUM03
,      SQUAL_NUM04
,      SQUAL_NUM05
,      SQUAL_NUM06
,      SQUAL_NUM07
,      SQUAL_NUM08
,      SQUAL_NUM09
,      SQUAL_NUM10
,      SQUAL_NUM11
,      SQUAL_NUM12
,      SQUAL_NUM13
,      SQUAL_NUM14
,      SQUAL_NUM15
,      SQUAL_NUM16
,      SQUAL_NUM17
,      SQUAL_NUM18
,      SQUAL_NUM19
,      SQUAL_NUM20
,      SQUAL_NUM21
,      SQUAL_NUM22
,      SQUAL_NUM23
,      SQUAL_NUM24
,      SQUAL_NUM25
,      SQUAL_NUM26
,      SQUAL_NUM27
,      SQUAL_NUM28
,      SQUAL_NUM29
,      SQUAL_NUM30
,      SQUAL_NUM31
,      SQUAL_NUM32
,      SQUAL_NUM33
,      SQUAL_NUM34
,      SQUAL_NUM35
,      SQUAL_NUM36
,      SQUAL_NUM37
,      SQUAL_NUM38
,      SQUAL_NUM39
,      SQUAL_NUM40
,      SQUAL_NUM41
,      SQUAL_NUM42
,      SQUAL_NUM43
,      SQUAL_NUM44
,      SQUAL_NUM45
,      SQUAL_NUM46
,      SQUAL_NUM47
,      SQUAL_NUM48
,      SQUAL_NUM49
,      SQUAL_NUM50
,      SQUAL_CURC01
,      SQUAL_CURC02
,      SQUAL_CURC03
,      SQUAL_CURC04
,      SQUAL_CURC05
,      TXN_DATE
FROM APPS.JTY_TERR_1500_CNTRCT_TRANS_GT;

Dependencies

[top of page]

APPS.JTY_TERR_1500_CNTRCT_TRANS_GT does not reference any database object

APPS.JTY_TERR_1500_CNTRCT_TRANS_GT is referenced by following:

APPS: JTF_TERR_ASSIGN_PUB - show dependent code