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

TABLE: FLM.FLM_SEQ_RULE_CONSTRAINTS

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


FLM_SEQ_RULE_CONTRAINTS table stores flow sequencing constraint definition.
A flow sequencing constraint is a restriction defined in the production line that dictates the order on how the assembly is built. The constraint is defined for a certain attribute.
As an example, we can have required constraint for attribute 'Color' in which assembly having color 'Red' must be followed by assembly having color 'Green'. Such constraint is defined with CONSTRAINT_TYPE of 1(Required Transition'), ATTRIBUTE_ID of X (that reference Attribute 'Color' in FLM_SEQ_ATTRIBUTES table), ATTRIBUTE_VALUE1_NAME of 'Red', and ATTRIBUTE_VALUE2_NAME of 'Green'.
The FLM_SEQ_RULE_CONTRAINTS is the child table of FLM_SEQ_RULES. One rule defined in FLM_SEQ_RULE table can have multiple constraints defined in FLM_SEQ_RULE_CONTRAINTS table. A priority will be defined for each of the constraints for a rule. The constraint having high priority (with lower number) must be satisfied before the constraint having lower priority is satisfied.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FLM_SEQ_RULE_CONSTRAINTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRULE_ID
ColumnCONSTRAINT_NUMBER
Columns
Name Datatype Length Mandatory Comments
RULE_ID NUMBER
Yes Rule identifier
CONSTRAINT_NUMBER NUMBER
Yes Identifier of constraint within a rule
OBJECT_VERSION_NUMBER NUMBER
Yes Object version number
ORGANIZATION_ID NUMBER

Organization identifier
PRIORITY NUMBER

Priority of constraint
CONSTRAINT_TYPE NUMBER
Yes Type of the constraint
CONSTRAINT_TYPE_VALUE1 NUMBER

The first value of constraint type. The meaning of this value is based on the constraint type.
CONSTRAINT_TYPE_VALUE2 NUMBER

The second value of constraint type. The meaning of this value is based on the constraint type.
CONSTRAINT_TYPE_VALUE3 NUMBER

The third value of constraint type. The meaning of this value is based on the constraint type.
ATTRIBUTE_ID NUMBER
Yes Attribute identifier
ATTRIBUTE_VALUE1_NAME VARCHAR2 (240)
The first attribute value for an attribute having string type
ATTRIBUTE_VALUE2_NAME VARCHAR2 (240)
The second attribute value for an attribute having string type
ATTRIBUTE_VALUE1_NUM NUMBER

The first attribute value for an attribute having number type
ATTRIBUTE_VALUE2_NUM NUMBER

The second attribute value for an attribute having number type
ATTRIBUTE_VALUE1_DATE DATE

The first attribute value for an attribute having date type
ATTRIBUTE_VALUE2_DATE DATE

The second attribute value for an attribute having date type
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
PARENT_CONSTRAINT_NUMBER NUMBER

Constraint Number for the parent constraint.
Query Text

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


SELECT RULE_ID
,      CONSTRAINT_NUMBER
,      OBJECT_VERSION_NUMBER
,      ORGANIZATION_ID
,      PRIORITY
,      CONSTRAINT_TYPE
,      CONSTRAINT_TYPE_VALUE1
,      CONSTRAINT_TYPE_VALUE2
,      CONSTRAINT_TYPE_VALUE3
,      ATTRIBUTE_ID
,      ATTRIBUTE_VALUE1_NAME
,      ATTRIBUTE_VALUE2_NAME
,      ATTRIBUTE_VALUE1_NUM
,      ATTRIBUTE_VALUE2_NUM
,      ATTRIBUTE_VALUE1_DATE
,      ATTRIBUTE_VALUE2_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      PARENT_CONSTRAINT_NUMBER
FROM FLM.FLM_SEQ_RULE_CONSTRAINTS;

Dependencies

[top of page]

FLM.FLM_SEQ_RULE_CONSTRAINTS does not reference any database object

FLM.FLM_SEQ_RULE_CONSTRAINTS is referenced by following:

SchemaFLM
ViewFLM_SEQ_RULE_CONSTRAINTS#