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


TABLE: WIP.WIP_LINES

Object Details
Object Name: WIP_LINES
Object Type: TABLE
Owner: WIP
FND Design Data: TableWIP.WIP_LINES
Subobject Name:
Status: VALID


WIP_LINES stores production line information. Each row includes a line name, maximum and minimum rate information, throughput for rate based lines (lead time), and the start and stop time information that determines the amount of time per day that the line is available. Oracle Work in Process uses this information when you associate a line with a repetitive assembly and when you define a repetitive schedule on the line. Production line information is optional for discrete jobs.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WIP_LINES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLINE_ID
ColumnORGANIZATION_ID
WIP_LINES_U3 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLINE_CODE
ColumnORGANIZATION_ID
WIP_LINES_U4 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnLINE_CODE
Columns
Name Datatype Length Mandatory Comments
LINE_ID NUMBER
Yes WIP line Identifier
ORGANIZATION_ID NUMBER
Yes Organization Identifier
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
LINE_CODE VARCHAR2 (10) Yes Line name
DESCRIPTION VARCHAR2 (240)
Descriptive text
DISABLE_DATE DATE

Disable date
MINIMUM_RATE NUMBER
Yes Hourly minimum rate
MAXIMUM_RATE NUMBER
Yes Hourly maximum rate
FIXED_THROUGHPUT NUMBER

Fixed lead time hours
LINE_SCHEDULE_TYPE NUMBER
Yes Method of calculating the lead time for an assembly on the line
SCHEDULING_METHOD_ID NUMBER

Scheduling method identifier
START_TIME NUMBER
Yes Start time of the line
STOP_TIME NUMBER
Yes Stop time of the line
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment
ATP_RULE_ID NUMBER

Identifies ATP Rule, which is used for ATP/CTP projects
EXCEPTION_SET_NAME VARCHAR2 (10)
Exception set name used in Planning
SEQ_DIRECTION NUMBER

Default Flow Sequencing direction. It is forward or backward direction. It's used by Flow Sequencing module.
SEQ_CONNECT_FLAG VARCHAR2 (1)
Default flag to indicate whether to connect the new sequence with the existing sequence of the flow schedules that are scheduled prior to the sequencing horizon start date. It's used by Flow Sequencing module.
SEQ_FIX_SEQUENCE_TYPE NUMBER

Default type to indicate different type of fixing existing flow schedules during the sequencing engine run. The type can be either 'time' or 'quantity'. It's used by Flow Sequencing module.
SEQ_FIX_SEQUENCE_AMOUNT NUMBER

Default amount to indicate the amount to fix during the flow sequencing run. The amount can be either seconds for 'time' fix sequence type or flow schedule quantity for 'quantity' fix sequence type. It's used by Flow Sequencing module.
SEQ_DEFAULT_RULE_ID NUMBER

Default flow sequencing rule identifier. It's used by Flow Sequencing module.
SEQ_COMBINE_SCHEDULE_FLAG VARCHAR2 (1)
Default flag to indicate whether the flow sequencing engine need to combine multiple schedules having the same demand into one schedule. It's used by Flow Sequencing module.
Query Text

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


SELECT LINE_ID
,      ORGANIZATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LINE_CODE
,      DESCRIPTION
,      DISABLE_DATE
,      MINIMUM_RATE
,      MAXIMUM_RATE
,      FIXED_THROUGHPUT
,      LINE_SCHEDULE_TYPE
,      SCHEDULING_METHOD_ID
,      START_TIME
,      STOP_TIME
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATP_RULE_ID
,      EXCEPTION_SET_NAME
,      SEQ_DIRECTION
,      SEQ_CONNECT_FLAG
,      SEQ_FIX_SEQUENCE_TYPE
,      SEQ_FIX_SEQUENCE_AMOUNT
,      SEQ_DEFAULT_RULE_ID
,      SEQ_COMBINE_SCHEDULE_FLAG
FROM WIP.WIP_LINES;

Dependencies

[top of page]

WIP.WIP_LINES does not reference any database object

WIP.WIP_LINES is referenced by following:

SchemaWIP
ViewWIP_LINES#