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: JTF.JTF_TTY_WEBADI_INTERFACES

Object Details

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

Interface table to store data that needs to be displayed in Excel

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JTF_TTY_WEBADI_INTFS_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	USER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
USER_SEQUENCE	NUMBER		Yes	User Sequence
USER_ID	NUMBER		Yes	User Identifier
OPTIONAL_ID1	NUMBER			Generic Column to store an Identifier
OPTIONAL_ID2	NUMBER			Generic Column to store an Identifier
OPTIONAL_ID3	NUMBER			Generic Column to store an Identifier
OPTIONAL_ID4	NUMBER			Generic Column to store an Identifier
OPTIONAL_ID5	NUMBER			Generic Column to store an Identifier
ATTRIBUTE1	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE2	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE3	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE4	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE5	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE6	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE7	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE8	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE9	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE10	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE11	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE12	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE13	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE14	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE15	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE16	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE17	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE18	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE19	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE20	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE21	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE22	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE23	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE24	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE25	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE26	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE27	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE28	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE29	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE30	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE31	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE32	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE33	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE34	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE35	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE36	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE37	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE38	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE39	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE40	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE41	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE42	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE43	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE44	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE45	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE46	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE47	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE48	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE49	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE50	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE51	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE52	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE53	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE54	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE55	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE56	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE57	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE58	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE59	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE60	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE61	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE62	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE63	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE64	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE65	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE66	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE67	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE68	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE69	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE70	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE71	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE72	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE73	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE74	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE75	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE76	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE77	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE78	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE79	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE80	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE81	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE82	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE83	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE84	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE85	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE86	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE87	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE88	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE89	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE90	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE91	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE92	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE93	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE94	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE95	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE96	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE97	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE98	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE99	VARCHAR2	(500)		Column to store any attribute
ATTRIBUTE100	VARCHAR2	(500)		Column to store any attribute
CREATED_BY	NUMBER	(15)	Yes	Created By
CREATION_DATE	DATE		Yes	Creation Date
LAST_UPDATED_BY	NUMBER	(15)	Yes	Last Updated By
LAST_UPDATE_DATE	DATE		Yes	Last Update Date
LAST_UPDATE_LOGIN	NUMBER	(15)		Last Update Login

Query Text

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


SELECT USER_SEQUENCE
,      USER_ID
,      OPTIONAL_ID1
,      OPTIONAL_ID2
,      OPTIONAL_ID3
,      OPTIONAL_ID4
,      OPTIONAL_ID5
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      ATTRIBUTE31
,      ATTRIBUTE32
,      ATTRIBUTE33
,      ATTRIBUTE34
,      ATTRIBUTE35
,      ATTRIBUTE36
,      ATTRIBUTE37
,      ATTRIBUTE38
,      ATTRIBUTE39
,      ATTRIBUTE40
,      ATTRIBUTE41
,      ATTRIBUTE42
,      ATTRIBUTE43
,      ATTRIBUTE44
,      ATTRIBUTE45
,      ATTRIBUTE46
,      ATTRIBUTE47
,      ATTRIBUTE48
,      ATTRIBUTE49
,      ATTRIBUTE50
,      ATTRIBUTE51
,      ATTRIBUTE52
,      ATTRIBUTE53
,      ATTRIBUTE54
,      ATTRIBUTE55
,      ATTRIBUTE56
,      ATTRIBUTE57
,      ATTRIBUTE58
,      ATTRIBUTE59
,      ATTRIBUTE60
,      ATTRIBUTE61
,      ATTRIBUTE62
,      ATTRIBUTE63
,      ATTRIBUTE64
,      ATTRIBUTE65
,      ATTRIBUTE66
,      ATTRIBUTE67
,      ATTRIBUTE68
,      ATTRIBUTE69
,      ATTRIBUTE70
,      ATTRIBUTE71
,      ATTRIBUTE72
,      ATTRIBUTE73
,      ATTRIBUTE74
,      ATTRIBUTE75
,      ATTRIBUTE76
,      ATTRIBUTE77
,      ATTRIBUTE78
,      ATTRIBUTE79
,      ATTRIBUTE80
,      ATTRIBUTE81
,      ATTRIBUTE82
,      ATTRIBUTE83
,      ATTRIBUTE84
,      ATTRIBUTE85
,      ATTRIBUTE86
,      ATTRIBUTE87
,      ATTRIBUTE88
,      ATTRIBUTE89
,      ATTRIBUTE90
,      ATTRIBUTE91
,      ATTRIBUTE92
,      ATTRIBUTE93
,      ATTRIBUTE94
,      ATTRIBUTE95
,      ATTRIBUTE96
,      ATTRIBUTE97
,      ATTRIBUTE98
,      ATTRIBUTE99
,      ATTRIBUTE100
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM JTF.JTF_TTY_WEBADI_INTERFACES;

Dependencies

[top of page]

JTF.JTF_TTY_WEBADI_INTERFACES does not reference any database object

JTF.JTF_TTY_WEBADI_INTERFACES is referenced by following:

APPS: JTF_TTY_WEBADI_INTERFACES