eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: WIP.WIP_LINES

Object Details

Object Name:	WIP_LINES
Object Type:	TABLE
Owner:	WIP
FND Design Data:	WIP.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:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WIP_LINES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	LINE_ID ORGANIZATION_ID
WIP_LINES_U3	NORMAL	UNIQUE	APPS_TS_TX_IDX	LINE_CODE ORGANIZATION_ID
WIP_LINES_U4	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID LINE_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:

APPS: WIP_LINES