[Home] [Help] [Dependency Information]
Object Name: | JTF_QUAL_USGS_ALL# |
---|---|
Object Type: | VIEW |
Owner: | JTF |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 |
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#;
|
|
|