[Home] [Help]
View: JTF_QUAL_USGS
| Product: | JTF - CRM Foundation |
|---|
| Description: | Same as JTF_QUAL_USGS_ALL table |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
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
, 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
, ORG_ID
, RULE1
, RULE2
, DISPLAY_SEQUENCE
, DISPLAY_LENGTH
, JSP_LOV_SQL
, USE_IN_LOOKUP_FLAG
FROM JTF_QUAL_USGS_ALL
Columns
| Name |
| 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 |
| 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 |
| ORG_ID |
| RULE1 |
| RULE2 |
| DISPLAY_SEQUENCE |
| DISPLAY_LENGTH |
| JSP_LOV_SQL |
| USE_IN_LOOKUP_FLAG |