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_RESOURCE_EFC

Object Details

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

Columns

Name	Datatype	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
REPETITIVE_SCHEDULE_ID	NUMBER		WIP repetitive schedule Identifier
SET_OF_BOOKS_ID	NUMBER		Set of Books Identifier
USAGE_RATE_OR_AMOUNT	NUMBER	Yes	Rate per assembly or amount per job/schedule
APPLIED_RESOURCE_VALUE	NUMBER	Yes	Value of resource units charged
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

Query Text

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


SELECT WIP_ENTITY_ID
,      OPERATION_SEQ_NUM
,      RESOURCE_SEQ_NUM
,      REPETITIVE_SCHEDULE_ID
,      SET_OF_BOOKS_ID
,      USAGE_RATE_OR_AMOUNT
,      APPLIED_RESOURCE_VALUE
,      RELIEVED_RES_COMPLETION_VALUE
,      RELIEVED_RES_SCRAP_VALUE
,      RELIEVED_VARIANCE_VALUE
,      TEMP_RELIEVED_VALUE
FROM WIP.WIP_SUB_OPERATION_RESOURCE_EFC;

Dependencies

[top of page]

WIP.WIP_SUB_OPERATION_RESOURCE_EFC does not reference any database object

WIP.WIP_SUB_OPERATION_RESOURCE_EFC is referenced by following:

APPS: WIP_SUB_OPERATION_RESOURCE_EFC