DBA Data[Home] [Help] [Dependency Information]

TABLE: CS.CS_QM_FUNCTION_FILTERS

Object Details
Object Name: CS_QM_FUNCTION_FILTERS
Object Type: TABLE
Owner: CS
FND Design Data: TableCS.CS_QM_FUNCTION_FILTERS
Subobject Name:
Status: VALID


It stores the relationship between functions and filters. The table has a foreign key to both the table CS_QM_FILTERS and FND_FORM_FUNCTIONS.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
FUNCTION_FILTER_ID NUMBER
Yes Function Identifier, primary key.
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.
FUNCTION_ID NUMBER
Yes FK to FND_FORM_FUNCTIONS.
FILTER_ID NUMBER
Yes Filter Id
SEEDED_FLAG VARCHAR2 (1) Yes This indicates if this filter is a seeded one.
ACTIVE_FLAG VARCHAR2 (1) Yes This indicates if this filter is active.
OBJECT_VERSION_NUMBER NUMBER
Yes Object Version Number - Standard Column used for Updates
COLUMN_NAME VARCHAR2 (80)
Column Name
COLUMN_DATATYPE VARCHAR2 (10)
Column Data Type
FUNCTION_NAME VARCHAR2 (30)
Function Name
Query Text

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


SELECT FUNCTION_FILTER_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      FUNCTION_ID
,      FILTER_ID
,      SEEDED_FLAG
,      ACTIVE_FLAG
,      OBJECT_VERSION_NUMBER
,      COLUMN_NAME
,      COLUMN_DATATYPE
,      FUNCTION_NAME
FROM CS.CS_QM_FUNCTION_FILTERS;

Dependencies

[top of page]

CS.CS_QM_FUNCTION_FILTERS does not reference any database object

CS.CS_QM_FUNCTION_FILTERS is referenced by following:

SchemaAPPS
SynonymCS_QM_FUNCTION_FILTERS