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

TABLE: FLM.FLM_FILTER_CRITERIA

Object Details
Object Name: FLM_FILTER_CRITERIA
Object Type: TABLE
Owner: FLM
FND Design Data: TableFLM.FLM_FILTER_CRITERIA
Subobject Name:
Status: VALID


FLM_FILTER_CRITERIA table stores the filtering criteria of flow manufacturing related query.
The filtering criteria are grouped using CRITERIA_GROUP_ID column. The type of the group criteria defined in CRITERIA_GROUP_TYPE column indicates the usage of the filtering criteria. Each group can contain one or more filtering criteria. Each filtering criteria in the filtering criteria group is identified using CRITERIA_NUM column. The type of each criteria is stored in CRITERIA_TYPE column. In one criteria, there can be one or more operations (defined in CRITERIA_OPERATION column).


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FLM_FILTER_CRITERIA_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCRITERIA_ID
FLM_FILTER_CRITERIA_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCRITERIA_GROUP_ID
Columns
Name Datatype Length Mandatory Comments
CRITERIA_ID NUMBER
Yes Criteria identifier
CRITERIA_GROUP_ID NUMBER
Yes Criteria group identifier
CRITERIA_NUM NUMBER
Yes Criteria number
CRITERIA_GROUP_TYPE NUMBER
Yes The type of criteria group.
CRITERIA_TYPE NUMBER
Yes The type of criteria
ORGANIZATION_ID NUMBER

Organization identifier
OBJECT_VERSION_NUMBER NUMBER
Yes Object Version Number
CRITERIA_OPERATION NUMBER
Yes Criteria operation
CRITERIA_VALUE_TYPE NUMBER
Yes The type of criteria value
CRITERIA_VALUE_NAME VARCHAR2 (240)
Criteria value with string datatype
CRITERIA_VALUE_NUM NUMBER

Criteria value with number datatype
CRITERIA_VALUE_DATE DATE

Criteria value with date datatype
CREATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
REQUEST_ID NUMBER

Standard Who column
PROGRAM_ID NUMBER

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Standard Who column
PROGRAM_UPDATE_DATE DATE

Standard Who column
Query Text

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


SELECT CRITERIA_ID
,      CRITERIA_GROUP_ID
,      CRITERIA_NUM
,      CRITERIA_GROUP_TYPE
,      CRITERIA_TYPE
,      ORGANIZATION_ID
,      OBJECT_VERSION_NUMBER
,      CRITERIA_OPERATION
,      CRITERIA_VALUE_TYPE
,      CRITERIA_VALUE_NAME
,      CRITERIA_VALUE_NUM
,      CRITERIA_VALUE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
FROM FLM.FLM_FILTER_CRITERIA;

Dependencies

[top of page]

FLM.FLM_FILTER_CRITERIA does not reference any database object

FLM.FLM_FILTER_CRITERIA is referenced by following:

SchemaFLM
ViewFLM_FILTER_CRITERIA#