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_SCHEDULES

Object Details

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

WIP_REPETITIVE_SCHEDULES stores repetitive schedule information.
Each row includes a repetitive schedule Identifier, information about
the schedule's production line, start and end dates, rate, throughput,
revision, status, and information on the General Ledger accounts to
which charges for this schedule are written. Oracle Work in Process
uses this information to control repetitive production.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	20
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WIP_REPETITIVE_SCHEDULES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	REPETITIVE_SCHEDULE_ID ORGANIZATION_ID
WIP_REPETITIVE_SCHEDULES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LINE_ID
WIP_REPETITIVE_SCHEDULES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	WIP_ENTITY_ID LINE_ID
WIP_REPETITIVE_SCHEDULES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID LINE_ID
WIP_REPETITIVE_SCHEDULES_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	STATUS_TYPE ORGANIZATION_ID FIRST_UNIT_START_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
REPETITIVE_SCHEDULE_ID	NUMBER		Yes	WIP repetitive schedule 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
WIP_ENTITY_ID	NUMBER		Yes	WIP repetitive assembly Identifier
LINE_ID	NUMBER		Yes	WIP line Identifier
DAILY_PRODUCTION_RATE	NUMBER		Yes	Schedule daily quantity
PROCESSING_WORK_DAYS	NUMBER		Yes	Processing work days
STATUS_TYPE	NUMBER		Yes	Status of repetitive schedule
FIRM_PLANNED_FLAG	NUMBER		Yes	Control for MRP rescheduling
ALTERNATE_BOM_DESIGNATOR	VARCHAR2	(10)		Alternate bill of material used in repetitive schedule
COMMON_BOM_SEQUENCE_ID	NUMBER			Common bill Identifier
BOM_REVISION	VARCHAR2	(3)		Inventory item revision code
BOM_REVISION_DATE	DATE			Date of inventory item revision used to explode the bill of material used in the schedule
ALTERNATE_ROUTING_DESIGNATOR	VARCHAR2	(10)		Alternate routing used in a repetitive schedule
COMMON_ROUTING_SEQUENCE_ID	NUMBER			Common routing Identifier
ROUTING_REVISION	VARCHAR2	(3)		Routing revision code
ROUTING_REVISION_DATE	DATE			Routing revision date
FIRST_UNIT_START_DATE	DATE		Yes	First unit start date
FIRST_UNIT_COMPLETION_DATE	DATE		Yes	First unit completion date
LAST_UNIT_START_DATE	DATE		Yes	Last unit start date
LAST_UNIT_COMPLETION_DATE	DATE		Yes	Last unit completion date
DATE_RELEASED	DATE			Date on which repetitive schedule is released
DATE_CLOSED	DATE			Date on which the repetitive schedule is set to Complete - No charges or to Cancelled
QUANTITY_COMPLETED	NUMBER		Yes	Current quantity completed on the schedule
DESCRIPTION	VARCHAR2	(240)		Descriptive text
DEMAND_CLASS	VARCHAR2	(30)		Type of demand the schedule satisfies
MATERIAL_ACCOUNT	NUMBER		Yes	General Ledger account to accumulate material charges for a repetitive schedule
MATERIAL_OVERHEAD_ACCOUNT	NUMBER		Yes	General Ledger account to accumulate material overhead charges for a repetitive schedule
RESOURCE_ACCOUNT	NUMBER		Yes	General Ledger account to accumulate resource charges for a repetitive schedule
OVERHEAD_ACCOUNT	NUMBER		Yes	General Ledger account to accumulate overhead charges for a repetitive schedule
OUTSIDE_PROCESSING_ACCOUNT	NUMBER		Yes	General Ledger account to accumulate outside processing charges for a repetitive schedule
MATERIAL_VARIANCE_ACCOUNT	NUMBER		Yes	General Ledger account to accumulate material variances for a repetitive schedule
OVERHEAD_VARIANCE_ACCOUNT	NUMBER		Yes	General Ledger account to accumulate overhead variances for a repetitive schedule
RESOURCE_VARIANCE_ACCOUNT	NUMBER		Yes	General Ledger account to accumulate resource variances for a repetitive schedule
OUTSIDE_PROC_VARIANCE_ACCOUNT	NUMBER		Yes	General Ledger account to accumulate outside processing variances for a repetitive schedule
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
PO_CREATION_TIME	NUMBER		Yes	Determines whether or not a purchase order is created for an outside processing item, and when it is created

Query Text

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


SELECT REPETITIVE_SCHEDULE_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
,      WIP_ENTITY_ID
,      LINE_ID
,      DAILY_PRODUCTION_RATE
,      PROCESSING_WORK_DAYS
,      STATUS_TYPE
,      FIRM_PLANNED_FLAG
,      ALTERNATE_BOM_DESIGNATOR
,      COMMON_BOM_SEQUENCE_ID
,      BOM_REVISION
,      BOM_REVISION_DATE
,      ALTERNATE_ROUTING_DESIGNATOR
,      COMMON_ROUTING_SEQUENCE_ID
,      ROUTING_REVISION
,      ROUTING_REVISION_DATE
,      FIRST_UNIT_START_DATE
,      FIRST_UNIT_COMPLETION_DATE
,      LAST_UNIT_START_DATE
,      LAST_UNIT_COMPLETION_DATE
,      DATE_RELEASED
,      DATE_CLOSED
,      QUANTITY_COMPLETED
,      DESCRIPTION
,      DEMAND_CLASS
,      MATERIAL_ACCOUNT
,      MATERIAL_OVERHEAD_ACCOUNT
,      RESOURCE_ACCOUNT
,      OVERHEAD_ACCOUNT
,      OUTSIDE_PROCESSING_ACCOUNT
,      MATERIAL_VARIANCE_ACCOUNT
,      OVERHEAD_VARIANCE_ACCOUNT
,      RESOURCE_VARIANCE_ACCOUNT
,      OUTSIDE_PROC_VARIANCE_ACCOUNT
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PO_CREATION_TIME
FROM WIP.WIP_REPETITIVE_SCHEDULES;

Dependencies

[top of page]

WIP.WIP_REPETITIVE_SCHEDULES does not reference any database object

WIP.WIP_REPETITIVE_SCHEDULES is referenced by following:

APPS: WIP_REPETITIVE_SCHEDULES