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]

VIEW: JTF.JTF_QUAL_USGS_ALL#

Object Details

Object Name:	JTF_QUAL_USGS_ALL#
Object Type:	VIEW
Owner:	JTF
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
QUAL_USG_ID	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER		Yes
LAST_UPDATE_LOGIN	NUMBER
APPLICATION_SHORT_NAME	VARCHAR2	(50)	Yes
SEEDED_QUAL_ID	NUMBER		Yes
QUAL_TYPE_USG_ID	NUMBER		Yes
ENABLED_FLAG	VARCHAR2	(1)	Yes
QUAL_COL1	VARCHAR2	(30)
QUAL_COL1_ALIAS	VARCHAR2	(60)
QUAL_COL1_DATATYPE	VARCHAR2	(30)
QUAL_COL1_TABLE	VARCHAR2	(30)
QUAL_COL1_TABLE_ALIAS	VARCHAR2	(30)
PRIM_INT_CDE_COL	VARCHAR2	(30)
PRIM_INT_CDE_COL_ALIAS	VARCHAR2	(60)
PRIM_INT_CDE_COL_DATATYPE	VARCHAR2	(30)
SEC_INT_CDE_COL	VARCHAR2	(30)
SEC_INT_CDE_COL_ALIAS	VARCHAR2	(60)
SEC_INT_CDE_COL_DATATYPE	VARCHAR2	(30)
INT_CDE_COL_TABLE	VARCHAR2	(30)
INT_CDE_COL_TABLE_ALIAS	VARCHAR2	(30)
SEEDED_FLAG	VARCHAR2	(1)
CONVERT_TO_ID_FLAG	VARCHAR2	(1)
DISPLAY_TYPE	VARCHAR2	(40)
LOV_SQL	VARCHAR2	(1000)
ORG_ID	NUMBER
COLUMN_COUNT	NUMBER
FORMATTING_FUNCTION_FLAG	VARCHAR2	(1)
FORMATTING_FUNCTION_NAME	VARCHAR2	(120)
SPECIAL_FUNCTION_FLAG	VARCHAR2	(1)
SPECIAL_FUNCTION_NAME	VARCHAR2	(120)
ENABLE_LOV_VALIDATION	VARCHAR2	(1)
DISPLAY_SQL1	VARCHAR2	(1000)
LOV_SQL2	VARCHAR2	(1000)
DISPLAY_SQL2	VARCHAR2	(1000)
LOV_SQL3	VARCHAR2	(1000)
DISPLAY_SQL3	VARCHAR2	(1000)
SECURITY_GROUP_ID	NUMBER
ORIG_SYSTEM_REFERENCE	VARCHAR2	(60)
ORIG_SYSTEM_REFERENCE_ID	NUMBER
UPGRADE_STATUS_FLAG	VARCHAR2	(1)
RULE1	VARCHAR2	(2000)
RULE2	VARCHAR2	(2000)
DISPLAY_SEQUENCE	NUMBER
DISPLAY_LENGTH	NUMBER
JSP_LOV_SQL	VARCHAR2	(2000)
USE_IN_LOOKUP_FLAG	VARCHAR2	(1)
ALIAS_RULE1	VARCHAR2	(200)
ALIAS_RULE2	VARCHAR2	(200)
ALIAS_OP_LIKE	VARCHAR2	(60)
ALIAS_OP_BETWEEN	VARCHAR2	(60)
ALIAS_LINE_ITEM	VARCHAR2	(240)
OP_EQL	VARCHAR2	(4000)
OP_NOT_EQL	VARCHAR2	(2000)
OP_LSS_THN	VARCHAR2	(2000)
OP_LSS_THN_EQL	VARCHAR2	(2000)
OP_GRTR_THN	VARCHAR2	(2000)
OP_GRTR_THN_EQL	VARCHAR2	(2000)
OP_LIKE	VARCHAR2	(2000)
OP_NOT_LIKE	VARCHAR2	(2000)
OP_BETWEEN	VARCHAR2	(2000)
OP_NOT_BETWEEN	VARCHAR2	(2000)
OP_COMMON_WHERE	VARCHAR2	(2000)
QUAL_RELATION_FACTOR	NUMBER
OBJECT_VERSION_NUMBER	NUMBER
COMPARISON_OPERATOR	VARCHAR2	(30)
LOW_VALUE_CHAR	VARCHAR2	(30)
HIGH_VALUE_CHAR	VARCHAR2	(30)
LOW_VALUE_CHAR_ID	VARCHAR2	(30)
LOW_VALUE_NUMBER	VARCHAR2	(30)
HIGH_VALUE_NUMBER	VARCHAR2	(30)
INTEREST_TYPE_ID	VARCHAR2	(30)
PRIMARY_INTEREST_CODE_ID	VARCHAR2	(30)
SECONDARY_INTEREST_CODE_ID	VARCHAR2	(30)
VALUE1_ID	VARCHAR2	(30)
VALUE2_ID	VARCHAR2	(30)
VALUE3_ID	VARCHAR2	(30)
VALUE4_ID	VARCHAR2	(30)
FIRST_CHAR	VARCHAR2	(30)
CURRENCY_CODE	VARCHAR2	(30)
REAL_TIME_SELECT	VARCHAR2	(2000)
REAL_TIME_WHERE	VARCHAR2	(4000)
REAL_TIME_FROM	VARCHAR2	(2000)
UPDATE_ATTR_VAL_STMT	VARCHAR2	(2000)
INSERT_ATTR_VAL_STMT	VARCHAR2	(2000)
HTML_LOV_SQL1	VARCHAR2	(1000)
HTML_LOV_SQL2	VARCHAR2	(1000)
HTML_LOV_SQL3	VARCHAR2	(1000)
HIERARCHY_TYPE	VARCHAR2	(30)
EQUAL_FLAG	VARCHAR2	(1)
LIKE_FLAG	VARCHAR2	(1)
BETWEEN_FLAG	VARCHAR2	(1)
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT QUAL_USG_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      APPLICATION_SHORT_NAME
,      SEEDED_QUAL_ID
,      QUAL_TYPE_USG_ID
,      ENABLED_FLAG
,      QUAL_COL1
,      QUAL_COL1_ALIAS
,      QUAL_COL1_DATATYPE
,      QUAL_COL1_TABLE
,      QUAL_COL1_TABLE_ALIAS
,      PRIM_INT_CDE_COL
,      PRIM_INT_CDE_COL_ALIAS
,      PRIM_INT_CDE_COL_DATATYPE
,      SEC_INT_CDE_COL
,      SEC_INT_CDE_COL_ALIAS
,      SEC_INT_CDE_COL_DATATYPE
,      INT_CDE_COL_TABLE
,      INT_CDE_COL_TABLE_ALIAS
,      SEEDED_FLAG
,      CONVERT_TO_ID_FLAG
,      DISPLAY_TYPE
,      LOV_SQL
,      ORG_ID
,      COLUMN_COUNT
,      FORMATTING_FUNCTION_FLAG
,      FORMATTING_FUNCTION_NAME
,      SPECIAL_FUNCTION_FLAG
,      SPECIAL_FUNCTION_NAME
,      ENABLE_LOV_VALIDATION
,      DISPLAY_SQL1
,      LOV_SQL2
,      DISPLAY_SQL2
,      LOV_SQL3
,      DISPLAY_SQL3
,      SECURITY_GROUP_ID
,      ORIG_SYSTEM_REFERENCE
,      ORIG_SYSTEM_REFERENCE_ID
,      UPGRADE_STATUS_FLAG
,      RULE1
,      RULE2
,      DISPLAY_SEQUENCE
,      DISPLAY_LENGTH
,      JSP_LOV_SQL
,      USE_IN_LOOKUP_FLAG
,      ALIAS_RULE1
,      ALIAS_RULE2
,      ALIAS_OP_LIKE
,      ALIAS_OP_BETWEEN
,      ALIAS_LINE_ITEM
,      OP_EQL
,      OP_NOT_EQL
,      OP_LSS_THN
,      OP_LSS_THN_EQL
,      OP_GRTR_THN
,      OP_GRTR_THN_EQL
,      OP_LIKE
,      OP_NOT_LIKE
,      OP_BETWEEN
,      OP_NOT_BETWEEN
,      OP_COMMON_WHERE
,      QUAL_RELATION_FACTOR
,      OBJECT_VERSION_NUMBER
,      COMPARISON_OPERATOR
,      LOW_VALUE_CHAR
,      HIGH_VALUE_CHAR
,      LOW_VALUE_CHAR_ID
,      LOW_VALUE_NUMBER
,      HIGH_VALUE_NUMBER
,      INTEREST_TYPE_ID
,      PRIMARY_INTEREST_CODE_ID
,      SECONDARY_INTEREST_CODE_ID
,      VALUE1_ID
,      VALUE2_ID
,      VALUE3_ID
,      VALUE4_ID
,      FIRST_CHAR
,      CURRENCY_CODE
,      REAL_TIME_SELECT
,      REAL_TIME_WHERE
,      REAL_TIME_FROM
,      UPDATE_ATTR_VAL_STMT
,      INSERT_ATTR_VAL_STMT
,      HTML_LOV_SQL1
,      HTML_LOV_SQL2
,      HTML_LOV_SQL3
,      HIERARCHY_TYPE
,      EQUAL_FLAG
,      LIKE_FLAG
,      BETWEEN_FLAG
,      ZD_EDITION_NAME
FROM JTF.JTF_QUAL_USGS_ALL#;

Dependencies

[top of page]

JTF.JTF_QUAL_USGS_ALL# references the following:

JTF: JTF_QUAL_USGS_ALL

JTF.JTF_QUAL_USGS_ALL# is referenced by following:

APPS: JTF_QUAL_USGS; JTF_QUAL_USGS_ALL; JTF_QUAL_USGS_ALL+