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_OPERATION_RESOURCES

Object Details

Object Name:	WIP_OPERATION_RESOURCES
Object Type:	TABLE
Owner:	WIP
FND Design Data:	WIP.WIP_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_OPERATION_RESOURCES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	WIP_ENTITY_ID OPERATION_SEQ_NUM RESOURCE_SEQ_NUM ORGANIZATION_ID REPETITIVE_SCHEDULE_ID
WIP_OPERATION_RESOURCES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REPETITIVE_SCHEDULE_ID ORGANIZATION_ID OPERATION_SEQ_NUM
WIP_OPERATION_RESOURCES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESOURCE_ID
WIP_OPERATION_RESOURCES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID START_DATE COMPLETION_DATE RESOURCE_ID

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			substitution group number
REPLACEMENT_GROUP_NUM	NUMBER			replacement group number
PRINCIPLE_FLAG	NUMBER			principle flag, for aps
SETUP_ID	NUMBER			Setup Identifier
PARENT_RESOURCE_SEQ	NUMBER			Parent Resource Sequence
BATCH_ID	NUMBER			Batch Id used in grouping operation resources across jobs
RELIEVED_RES_UNITS	NUMBER			Relieved Resource Units
RELIEVED_RES_VALUE	NUMBER			Relieved Resource Value
MAXIMUM_ASSIGNED_UNITS	NUMBER			maximum allowed assigned_units, inserted during job creation
FIRM_FLAG	NUMBER			NOT FIRM - 0, FIRM_START - 1,FIRM_END - 2, FIRM_RESOURCE -3 ,FIRM_START_END- 4, FIRM_START_RESOURCE - 5, FIRM_END_RESOURCE - 6, FIRM_ALL 7
GROUP_SEQUENCE_ID	NUMBER			Identifies the firmed fixed sequence for resource req
GROUP_SEQUENCE_NUMBER	NUMBER			Sequence in firmed sequence for resource requirement
ACTUAL_START_DATE	DATE			An actual resource start date.
ACTUAL_COMPLETION_DATE	DATE			An actual resource completion date.
PROJECTED_COMPLETION_DATE	DATE			Projected Completion Date

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
,      PARENT_RESOURCE_SEQ
,      BATCH_ID
,      RELIEVED_RES_UNITS
,      RELIEVED_RES_VALUE
,      MAXIMUM_ASSIGNED_UNITS
,      FIRM_FLAG
,      GROUP_SEQUENCE_ID
,      GROUP_SEQUENCE_NUMBER
,      ACTUAL_START_DATE
,      ACTUAL_COMPLETION_DATE
,      PROJECTED_COMPLETION_DATE
FROM WIP.WIP_OPERATION_RESOURCES;

Dependencies

[top of page]

WIP.WIP_OPERATION_RESOURCES does not reference any database object

WIP.WIP_OPERATION_RESOURCES is referenced by following:

APPS: WIP_OPERATION_RESOURCES