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_SUB_OPERATION_RESOURCES

Object Details

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

WIP_OPERATION_RESOURCES stores information about the resource requirements associated with job and repetitive schedule operations. Each
row represents a resource requirement and contains a sequence number,
the resource's unit of measure, its usage rate or amount, and several
other attributes that control how it is scheduled and costed.
Oracle Work in Process uses this information to schedule jobs and
repetitive schedules and to charge resources to jobs and schedules.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WIP_SUB_OPERATION_RESOURCES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	WIP_ENTITY_ID OPERATION_SEQ_NUM RESOURCE_SEQ_NUM ORGANIZATION_ID REPETITIVE_SCHEDULE_ID
WIP_SUB_OPERATION_RESOURCES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REPETITIVE_SCHEDULE_ID ORGANIZATION_ID OPERATION_SEQ_NUM
WIP_SUB_OPERATION_RESOURCES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESOURCE_ID
WIP_SUB_OPERATION_RESOURCES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	WIP_ENTITY_ID OPERATION_SEQ_NUM SUBSTITUTE_GROUP_NUM

Columns

Name	Datatype	Length	Mandatory	Comments
WIP_ENTITY_ID	NUMBER		Yes	WIP job or repetitive assembly Identifier
OPERATION_SEQ_NUM	NUMBER		Yes	Operation sequence number within a routing
RESOURCE_SEQ_NUM	NUMBER		Yes	Resource sequence number
ORGANIZATION_ID	NUMBER		Yes	Organization Identifier
REPETITIVE_SCHEDULE_ID	NUMBER			WIP repetitive schedule 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
RESOURCE_ID	NUMBER		Yes	Resource Identifier
UOM_CODE	VARCHAR2	(3)		Unit of measure code
BASIS_TYPE	NUMBER		Yes	Basis for scheduling and charging resource
USAGE_RATE_OR_AMOUNT	NUMBER		Yes	Rate per assembly or amount per job/schedule
ACTIVITY_ID	NUMBER			Activity Identifier
SCHEDULED_FLAG	NUMBER		Yes	Method of scheduling the resource
ASSIGNED_UNITS	NUMBER			Number of resources assigned to do work
AUTOCHARGE_TYPE	NUMBER		Yes	Method of charging the resource
STANDARD_RATE_FLAG	NUMBER		Yes	Indicates whether the resource is charged at the standard rate
APPLIED_RESOURCE_UNITS	NUMBER		Yes	Amount of resource units charged
APPLIED_RESOURCE_VALUE	NUMBER		Yes	Value of resource units charged
START_DATE	DATE		Yes	Scheduled start date of the resource
COMPLETION_DATE	DATE		Yes	Scheduled completion date of the resource
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
RELIEVED_RES_COMPLETION_UNITS	NUMBER			Units of resource relieved due to WIP completion
RELIEVED_RES_SCRAP_UNITS	NUMBER			Units of resource relieved due to WIP scrap
RELIEVED_RES_COMPLETION_VALUE	NUMBER			Value of resource relieved due to WIP completion
RELIEVED_RES_SCRAP_VALUE	NUMBER			Value of resource relieved due to WIP scrap
RELIEVED_VARIANCE_VALUE	NUMBER			Value of variance relieved
TEMP_RELIEVED_VALUE	NUMBER			Temporary column used in completion cost implementation
RELIEVED_RES_FINAL_COMP_UNITS	NUMBER			Units of resource relieved due to negative final completion
DEPARTMENT_ID	NUMBER			Department of this resource, if different from that of parent operation
PHANTOM_FLAG	NUMBER			Indicates whether or not this is a phantom routing resource (1 for yes, 2 for no)
PHANTOM_OP_SEQ_NUM	NUMBER			Operation sequence number, if part of a phantom routing
PHANTOM_ITEM_ID	NUMBER			Item, if part of a phantom routing
SCHEDULE_SEQ_NUM	NUMBER			schedule sequence number
SUBSTITUTE_GROUP_NUM	NUMBER		Yes	substitution group number
REPLACEMENT_GROUP_NUM	NUMBER		Yes	replacement group number
PRINCIPLE_FLAG	NUMBER			principle flag, for aps
SETUP_ID	NUMBER			Specifies the setup required for the operation resource
MAXIMUM_ASSIGNED_UNITS	NUMBER			maximum allowed assigned_units, inserted during job creation

Query Text

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


SELECT WIP_ENTITY_ID
,      OPERATION_SEQ_NUM
,      RESOURCE_SEQ_NUM
,      ORGANIZATION_ID
,      REPETITIVE_SCHEDULE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      RESOURCE_ID
,      UOM_CODE
,      BASIS_TYPE
,      USAGE_RATE_OR_AMOUNT
,      ACTIVITY_ID
,      SCHEDULED_FLAG
,      ASSIGNED_UNITS
,      AUTOCHARGE_TYPE
,      STANDARD_RATE_FLAG
,      APPLIED_RESOURCE_UNITS
,      APPLIED_RESOURCE_VALUE
,      START_DATE
,      COMPLETION_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      RELIEVED_RES_COMPLETION_UNITS
,      RELIEVED_RES_SCRAP_UNITS
,      RELIEVED_RES_COMPLETION_VALUE
,      RELIEVED_RES_SCRAP_VALUE
,      RELIEVED_VARIANCE_VALUE
,      TEMP_RELIEVED_VALUE
,      RELIEVED_RES_FINAL_COMP_UNITS
,      DEPARTMENT_ID
,      PHANTOM_FLAG
,      PHANTOM_OP_SEQ_NUM
,      PHANTOM_ITEM_ID
,      SCHEDULE_SEQ_NUM
,      SUBSTITUTE_GROUP_NUM
,      REPLACEMENT_GROUP_NUM
,      PRINCIPLE_FLAG
,      SETUP_ID
,      MAXIMUM_ASSIGNED_UNITS
FROM WIP.WIP_SUB_OPERATION_RESOURCES;

Dependencies

[top of page]

WIP.WIP_SUB_OPERATION_RESOURCES does not reference any database object

WIP.WIP_SUB_OPERATION_RESOURCES is referenced by following:

APPS: WIP_SUB_OPERATION_RESOURCES