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_HEADER

Object Details

Object Name:	JTY_WEBADI_QUAL_HEADER
Object Type:	TABLE
Owner:	JTF
FND Design Data:	JTF.JTY_WEBADI_QUAL_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_HEADER_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	USER_SEQUENCE QUALIFIER_NUM

Columns

Name	Datatype	Length	Comments
USER_SEQUENCE	NUMBER		foreign key to JTY_WEBADI_OTH_TERR_INTF.USER_SEQUENCE
QUAL_USG_ID	NUMBER		foreign key to JTF_QUAL_USGS_ALL.QUAL_USG_ID
QUALIFIER_NAME	VARCHAR2	(150)	foreign key to JTF_SEEDED_QUAL_ALL_B.NAME
QUALIFIER_NUM	NUMBER		Qualifier number
DISPLAY_TYPE	VARCHAR2	(30)	foreign key to JTF_QUAL_USGS_ALL.DISPLAY_TYPE
OPERATOR_TYPE	VARCHAR2	(30)	foreign key to JTF_QUAL_USGS_ALL.OPERATOR_TYPE
QUAL_COND_COL_NAME	VARCHAR2	(150)	Not used
QUAL_VAL1_COL_NAME	VARCHAR2	(150)	value1 for matching attribute
QUAL_VAL2_COL_NAME	VARCHAR2	(150)	value2 for matching attribute
QUAL_VAL3_COL_NAME	VARCHAR2	(150)	value3 for matching attribute
HTML_LOV_SQL1	VARCHAR2	(2000)	foreign key to JTF_QUAL_USGS_ALL.HTML_LOV_SQL1
COMPARISON_OPERATOR	VARCHAR2	(1000)	Comparison operator
HTML_LOV_SQL2	VARCHAR2	(2000)	foreign key to JTF_QUAL_USGS_ALL.HTML_LOV_SQL2
HTML_LOV_SQL3	VARCHAR2	(2000)	foreign key to JTF_QUAL_USGS_ALL.HTML_LOV_SQL3
CONVERT_TO_ID_FLAG	VARCHAR2	(1)	foreign key to JTF_QUAL_USGS_ALL.CONVERT_TO_ID_FLAG
DISPLAY_SQL1	VARCHAR2	(2000)	foreign key to JTF_QUAL_USGS_ALL.DISPLAY_SQL1
DISPLAY_SQL2	VARCHAR2	(2000)	foreign key to JTF_QUAL_USGS_ALL.DISPLAY_SQL2
DISPLAY_SQL3	VARCHAR2	(2000)	foreign key to JTF_QUAL_USGS_ALL.DISPLAY_SQL3

Query Text

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


SELECT USER_SEQUENCE
,      QUAL_USG_ID
,      QUALIFIER_NAME
,      QUALIFIER_NUM
,      DISPLAY_TYPE
,      OPERATOR_TYPE
,      QUAL_COND_COL_NAME
,      QUAL_VAL1_COL_NAME
,      QUAL_VAL2_COL_NAME
,      QUAL_VAL3_COL_NAME
,      HTML_LOV_SQL1
,      COMPARISON_OPERATOR
,      HTML_LOV_SQL2
,      HTML_LOV_SQL3
,      CONVERT_TO_ID_FLAG
,      DISPLAY_SQL1
,      DISPLAY_SQL2
,      DISPLAY_SQL3
FROM JTF.JTY_WEBADI_QUAL_HEADER;

Dependencies

[top of page]

JTF.JTY_WEBADI_QUAL_HEADER does not reference any database object

JTF.JTY_WEBADI_QUAL_HEADER is referenced by following:

APPS: JTY_WEBADI_QUAL_HEADER