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.JTY_WEBADI_QUAL_TYPE_HEADER

Object Details

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

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

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JTY_WEBADI_QUAL_TYPE_HEADER_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	USER_SEQUENCE QUAL_TYPE_NUM

Columns

Name	Datatype	Length	Comments
USER_SEQUENCE	NUMBER		foreign key to JTY_WEBADI_OTH_TERR_INTF.USER_SEQUENCE
QUAL_TYPE_ID	NUMBER		foreign key to JTF_QUAL_TYPE_USGS_ALL.QUAL_TYPE_USG_ID
QUAL_TYPE_NUM	NUMBER		Qual type number
QUAL_TYPE_NAME	VARCHAR2	(150)	foreign key to JTF_QUAL_TYPES_ALL.NAME
QUAL_TYPE_DESCR	VARCHAR2	(150)	foreign key to JTF_QUAL_TYPES_ALL.DESCRIPTION

Query Text

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


SELECT USER_SEQUENCE
,      QUAL_TYPE_ID
,      QUAL_TYPE_NUM
,      QUAL_TYPE_NAME
,      QUAL_TYPE_DESCR
FROM JTF.JTY_WEBADI_QUAL_TYPE_HEADER;

Dependencies

[top of page]

JTF.JTY_WEBADI_QUAL_TYPE_HEADER does not reference any database object

JTF.JTY_WEBADI_QUAL_TYPE_HEADER is referenced by following:

APPS: JTY_WEBADI_QUAL_TYPE_HEADER