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

TABLE: FLM.FLM_SEQ_TASK_LINES

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


FLM_SEQ_TASK_LINES table stores the specific production line information for the flow sequencing task.
It is the child table of FLM_SEQ_TASKS table. It holds the specific production line parameters for a specific run. The initial values will be defaulted from WIP_LINES (Production Line) table. Through the flow sequencing user interface, the user can override those values.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FLM_SEQ_TASK_LINES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSEQ_TASK_ID
ColumnLINE_ID
Columns
Name Datatype Length Mandatory Comments
SEQ_TASK_ID NUMBER
Yes Sequencing task identifier
LINE_ID NUMBER
Yes Production line identifier
OBJECT_VERSION_NUMBER NUMBER
Yes Object version number
ORGANIZATION_ID NUMBER

Organization identifier
SEQ_DIRECTION NUMBER
Yes Sequencing direction. It is forward or backward direction.
START_TIME NUMBER

Start time of the production line
STOP_TIME NUMBER

Stop time of the production line
HOURLY_RATE NUMBER

Hourly rate of production line
CONNECT_FLAG VARCHAR2 (1) Yes Flag to indicate whether to connect the new sequence with the existing sequence to the flow schedule that are scheduled prior to the sequencing horizon start date.
FIX_SEQUENCE_TYPE NUMBER
Yes Fix sequence type
FIX_SEQUENCE_AMOUNT NUMBER

Fix sequence amount
COMBINE_SCHEDULE_FLAG VARCHAR2 (1) Yes Flag to indicate whether the flow sequencing engine need to combine multiple schedules having the same demand into one schedule.
AVAILABLE_CAPACITY NUMBER

Available capacity
RESEQUENCED_QTY NUMBER

Resequenced quantity
RULE_ID NUMBER

Sequencing rule 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
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
REQUESTED_RESEQUENCE_QTY NUMBER

The requested qty that comes from existing flow schedules to be resequenced
Query Text

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


SELECT SEQ_TASK_ID
,      LINE_ID
,      OBJECT_VERSION_NUMBER
,      ORGANIZATION_ID
,      SEQ_DIRECTION
,      START_TIME
,      STOP_TIME
,      HOURLY_RATE
,      CONNECT_FLAG
,      FIX_SEQUENCE_TYPE
,      FIX_SEQUENCE_AMOUNT
,      COMBINE_SCHEDULE_FLAG
,      AVAILABLE_CAPACITY
,      RESEQUENCED_QTY
,      RULE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      REQUESTED_RESEQUENCE_QTY
FROM FLM.FLM_SEQ_TASK_LINES;

Dependencies

[top of page]

FLM.FLM_SEQ_TASK_LINES does not reference any database object

FLM.FLM_SEQ_TASK_LINES is referenced by following:

SchemaFLM
ViewFLM_SEQ_TASK_LINES#