eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: CZ.CZ_FILTER_SETS

Object Details

Object Name:	CZ_FILTER_SETS
Object Type:	TABLE
Owner:	CZ
FND Design Data:	CZ.CZ_FILTER_SETS
Subobject Name:
Status:	VALID

Table defines subsets of data from CZ tables, for use in Populators.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Primary Key: CZ_FILTER_SETS_PK

FILTER_SET_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
CZ_FILTER_SETS_PK	NORMAL	UNIQUE	APPS_TS_SEED	FILTER_SET_ID
CZ_FILTER_SETS_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	DEVL_PROJECT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
LAST_UPDATE_LOGIN	NUMBER	(15)		Records the login ID under which this record was last updated
FILTER_SET_ID	NUMBER	(9)	Yes	Identifies the Filter Set associated with this record
DEVL_PROJECT_ID	NUMBER	(15)	Yes	Identifies the project/model associated with this record
EXPRESS_ID	NUMBER	(9)		Identifies an Expression that specifies criteria for inclusion in this filter set. When null, all source records are used (i.e., none are filtered out)
SOURCE_TYPE	NUMBER	(9)		Indicates what the source data for the filter set is: 1 - items; 2 - item types; 3 - properties (names); 4 - property values. If NULL, indicates a custom view or syntax is in use.
CREATION_DATE	DATE		Yes	Standard field recording the date this record was created
LAST_UPDATE_DATE	DATE		Yes	Standard field recording the date/time this record was last updated
DELETED_FLAG	VARCHAR2	(1)	Yes	Standard flag; '0' indicates the record is active, '1' means deleted. Other values are reserved
EFF_FROM	DATE			UNUSED
EFF_TO	DATE			UNUSED
CREATED_BY	NUMBER	(15)	Yes	Standard field recording the ID of the user that created this record
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard field recording the ID of the user that last updated this record
SECURITY_MASK	VARCHAR2	(40)		UNUSED
EFF_MASK	VARCHAR2	(40)		UNUSED
CHECKOUT_USER	VARCHAR2	(40)		UNUSED
SOURCE_SYNTAX	VARCHAR2	(3000)		Holds a SQL query to be used as the filter set
SOURCE_VIEW_OWNER	VARCHAR2	(40)		Identifies the schema owner of SOURCE_VIEW_NAME
SOURCE_VIEW_NAME	VARCHAR2	(40)		Contains the name of a queriable database object that provides the source data for this filter set
RULE_ID	NUMBER		Yes	FK to CZ_RULES. Required because EXPRESS_ID is obsolete.
SRC_APPLICATION_ID	NUMBER		Yes	Value for existing records will be 708 (CZ).

Query Text

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


SELECT LAST_UPDATE_LOGIN
,      FILTER_SET_ID
,      DEVL_PROJECT_ID
,      EXPRESS_ID
,      SOURCE_TYPE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      DELETED_FLAG
,      EFF_FROM
,      EFF_TO
,      CREATED_BY
,      LAST_UPDATED_BY
,      SECURITY_MASK
,      EFF_MASK
,      CHECKOUT_USER
,      SOURCE_SYNTAX
,      SOURCE_VIEW_OWNER
,      SOURCE_VIEW_NAME
,      RULE_ID
,      SRC_APPLICATION_ID
FROM CZ.CZ_FILTER_SETS;

Dependencies

[top of page]

CZ.CZ_FILTER_SETS does not reference any database object

CZ.CZ_FILTER_SETS is referenced by following:

APPS: CZ_FILTER_SETS; CZ_FILTER_SETS_T1