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

TABLE: FLM.FLM_SEQ_LINE_RULES

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


FLM_SEQ_LINE_RULES table stores the association between production line and flow sequencing rule.
A production line can be assigned to multiple rules, and a rule can be assigned to multiple production lines. Among many assigned rules to a production line, the user may choose one rule as the default rule to be used on the flow sequencing run. The user will also be able to overwrite the default rule assignment at the time of the flow sequencing run.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FLM_SEQ_LINE_RULES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLINE_ID
ColumnRULE_ID
Columns
Name Datatype Length Mandatory Comments
RULE_ID NUMBER
Yes Rule identifier
LINE_ID NUMBER
Yes Production line identifier
OBJECT_VERSION_NUMBER NUMBER
Yes Object version number
ORGANIZATION_ID NUMBER

Organization identifier
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
Query Text

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


SELECT RULE_ID
,      LINE_ID
,      OBJECT_VERSION_NUMBER
,      ORGANIZATION_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM FLM.FLM_SEQ_LINE_RULES;

Dependencies

[top of page]

FLM.FLM_SEQ_LINE_RULES does not reference any database object

FLM.FLM_SEQ_LINE_RULES is referenced by following:

SchemaAPPS
SynonymFLM_SEQ_LINE_RULES