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_REPETITIVE_ITEMS

Object Details

Object Name:	WIP_REPETITIVE_ITEMS
Object Type:	TABLE
Owner:	WIP
FND Design Data:	WIP.WIP_REPETITIVE_ITEMS
Subobject Name:
Status:	VALID

WIP_REPETITIVE_ITEMS stores information about repetitive assemblies
and the production lines on which they are built. Each row
represents a particular assembly and line combination, and includes
information such as the line priority, the accounting class associated
with the line, the production rate, the supply type of the line,
whether the line is used in calculating the assembly's lead time
(PRIMARY_LINE_FLAG), the completion subinventory and locator for
a line, and the alternate bill and/or routing used for a particular
line.
Oracle Work in Process uses this information when you define
repetitive schedules. Oracle Master Scheduling/MRP and Oracle Supply
Chain Planning, as well as Oracle Capacity, use this information when
mass loading repetitive schedules and running capacity loads on
repetitive schedules.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	5
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WIP_REPETITIVE_ITEMS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	WIP_ENTITY_ID LINE_ID ORGANIZATION_ID
WIP_REPETITIVE_ITEMS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PRIMARY_ITEM_ID
WIP_REPETITIVE_ITEMS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LINE_ID PRIMARY_ITEM_ID
WIP_REPETITIVE_ITEMS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CLASS_CODE ORGANIZATION_ID ATTRIBUTE1

Columns

Name	Datatype	Length	Mandatory	Comments
WIP_ENTITY_ID	NUMBER		Yes	WIP repetitive assembly Identifier
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
REQUEST_ID	NUMBER			Enhanced Who column
PROGRAM_APPLICATION_ID	NUMBER			Enhanced Who column
PROGRAM_ID	NUMBER			Enhanced Who column
PROGRAM_UPDATE_DATE	DATE			Enhanced Who column
PRIMARY_ITEM_ID	NUMBER		Yes	Inventory item Identifier for assembly that the repetitive schedule creates
ALTERNATE_BOM_DESIGNATOR	VARCHAR2	(10)		Alternate bill of material used for assembly
ALTERNATE_ROUTING_DESIGNATOR	VARCHAR2	(10)		Alternate routing used in a repetitive assembly
CLASS_CODE	VARCHAR2	(10)	Yes	Accounting class associated with the repetitive item
WIP_SUPPLY_TYPE	NUMBER		Yes	Method of material consumption within WIP
COMPLETION_SUBINVENTORY	VARCHAR2	(10)		Default subinventory for completed units of assembly
COMPLETION_LOCATOR_ID	NUMBER			Default locator Identifier for completed units of assembly
LOAD_DISTRIBUTION_PRIORITY	NUMBER		Yes	Priority that determines load distribution across lines for repetitive mass load
PRIMARY_LINE_FLAG	NUMBER		Yes	Flag indicating whether or not the line is used for lead time calculations
PRODUCTION_LINE_RATE	NUMBER		Yes	Number of assemblies that run down the line per hour
OVERCOMPLETION_TOLERANCE_TYPE	NUMBER			Unit of OVERCOMPLETION_TOLERANCE_VALUE (percent or amount)
OVERCOMPLETION_TOLERANCE_VALUE	NUMBER			Percent or amount above expected quantity that can be completed
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

Query Text

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


SELECT WIP_ENTITY_ID
,      LINE_ID
,      ORGANIZATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PRIMARY_ITEM_ID
,      ALTERNATE_BOM_DESIGNATOR
,      ALTERNATE_ROUTING_DESIGNATOR
,      CLASS_CODE
,      WIP_SUPPLY_TYPE
,      COMPLETION_SUBINVENTORY
,      COMPLETION_LOCATOR_ID
,      LOAD_DISTRIBUTION_PRIORITY
,      PRIMARY_LINE_FLAG
,      PRODUCTION_LINE_RATE
,      OVERCOMPLETION_TOLERANCE_TYPE
,      OVERCOMPLETION_TOLERANCE_VALUE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM WIP.WIP_REPETITIVE_ITEMS;

Dependencies

[top of page]

WIP.WIP_REPETITIVE_ITEMS does not reference any database object

WIP.WIP_REPETITIVE_ITEMS is referenced by following:

APPS: WIP_REPETITIVE_ITEMS