[Home] [Help] [Dependency Information]
Object Name: | CS_QM_FOLDER_FILTERS |
---|---|
Object Type: | TABLE |
Owner: | CS |
FND Design Data: | CS.CS_QM_FOLDER_FILTERS |
Subobject Name: | |
Status: | VALID |
This table stores the instances of individual filters that belong to folders. The combination of USER_FOLDER_ID and FUNCTION_FILER_ID is unique.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FOLDER_FILTER_ID | NUMBER | Yes | Folder Identifier, primary key | |
FILTER_VALUE_ID | NUMBER | This stores the filter value ID. | ||
LAST_UPDATE_DATE | DATE | Yes | Standard WHO column. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO column. |
CREATION_DATE | DATE | Yes | Standard WHO column. | |
CREATED_BY | NUMBER | (15) | Yes | Standard WHO column. |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO column. | |
USER_FOLDER_ID | NUMBER | Yes | FK to CS_QM_USER_FOLDERS. | |
FUNCTION_FILTER_ID | NUMBER | Yes | FK to CS_QM_FUNCTION_FILTERS. | |
FILTER_OPERATOR | VARCHAR2 | (10) | Yes | This column always equals to "=". |
FILTER_VALUE | VARCHAR2 | (80) | This stores the filter value. | |
OBJECT_VERSION_NUMBER | NUMBER | Yes | Object Version Number - Standard Column |
Cut, paste (and edit) the following text to query this object:
SELECT FOLDER_FILTER_ID
, FILTER_VALUE_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, USER_FOLDER_ID
, FUNCTION_FILTER_ID
, FILTER_OPERATOR
, FILTER_VALUE
, OBJECT_VERSION_NUMBER
FROM CS.CS_QM_FOLDER_FILTERS;
CS.CS_QM_FOLDER_FILTERS does not reference any database object
CS.CS_QM_FOLDER_FILTERS is referenced by following:
|
|
|