[Home] [Help] [Dependency Information]
Object Name: | CS_QM_FILTERS# |
---|---|
Object Type: | VIEW |
Owner: | CS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FILTER_ID | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
FILTER_CODE | VARCHAR2 | (30) | Yes | |
FILTER_NAME | VARCHAR2 | (80) | Yes | |
ID_BASED_FLAG | VARCHAR2 | (1) | ||
DESCRIPTION | VARCHAR2 | (240) | ||
SEEDED_FLAG | VARCHAR2 | (1) | Yes | |
ACTIVE_FLAG | VARCHAR2 | (1) | Yes | |
SQL_STATEMENT_FOR_LOV | VARCHAR2 | (1000) | ||
OBJECT_VERSION_NUMBER | NUMBER | Yes | ||
DEFAULT_COLUMN_NAME | VARCHAR2 | (80) | ||
DEFAULT_COLUMN_DATATYPE | VARCHAR2 | (10) | ||
SQL_STATEMENT | VARCHAR2 | (240) | ||
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT FILTER_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, FILTER_CODE
, FILTER_NAME
, ID_BASED_FLAG
, DESCRIPTION
, SEEDED_FLAG
, ACTIVE_FLAG
, SQL_STATEMENT_FOR_LOV
, OBJECT_VERSION_NUMBER
, DEFAULT_COLUMN_NAME
, DEFAULT_COLUMN_DATATYPE
, SQL_STATEMENT
, ZD_EDITION_NAME
FROM CS.CS_QM_FILTERS#;
|
|
|