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_OVERHEADS

Object Details

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

WIP_OPERATION_OVERHEADS stores information about resource-based and
departmental overhead costs for jobs in an average costing
organization. For departmental overheads, each row represents overhead
costs earned by and relieved from a job at each operation and that have a
resource sequence number of -1. For resource-based overheads, each row
represents overhead costs earned by and relieved from a job for each
resource and operation.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WIP_OPERATION_OVERHEADS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	WIP_ENTITY_ID OPERATION_SEQ_NUM OVERHEAD_ID RESOURCE_SEQ_NUM BASIS_TYPE

Columns

Name	Datatype	Mandatory	Comments
WIP_ENTITY_ID	NUMBER	Yes	WIP job Identifier
OPERATION_SEQ_NUM	NUMBER	Yes	Operation sequence number
OVERHEAD_ID	NUMBER	Yes	Overhead Identifier
RESOURCE_SEQ_NUM	NUMBER	Yes	Resource sequence number
BASIS_TYPE	NUMBER	Yes	Basis for charging costs
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
ORGANIZATION_ID	NUMBER		Organization Identifier
APPLIED_OVHD_UNITS	NUMBER		Units of overhead applied based on basis type
APPLIED_OVHD_VALUE	NUMBER		Value of overhead applied based on basis type
RELIEVED_OVHD_COMPLETION_UNITS	NUMBER		Units of overhead relieved due to WIP completion
RELIEVED_OVHD_SCRAP_UNITS	NUMBER		Units of overhead relieved due to WIP scrap
RELIEVED_OVHD_COMPLETION_VALUE	NUMBER		Value of overhead relieved due to WIP completion
RELIEVED_OVHD_SCRAP_VALUE	NUMBER		Value of overhead 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_OVHD_FINAL_COMP_UNITS	NUMBER		Units of overhead relieved due to negative final completion
RELIEVED_OVHD_UNITS	NUMBER		Relieved Overhead Units
RELIEVED_OVHD_VALUE	NUMBER		Relieved Overhead Value

Query Text

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


SELECT WIP_ENTITY_ID
,      OPERATION_SEQ_NUM
,      OVERHEAD_ID
,      RESOURCE_SEQ_NUM
,      BASIS_TYPE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ORGANIZATION_ID
,      APPLIED_OVHD_UNITS
,      APPLIED_OVHD_VALUE
,      RELIEVED_OVHD_COMPLETION_UNITS
,      RELIEVED_OVHD_SCRAP_UNITS
,      RELIEVED_OVHD_COMPLETION_VALUE
,      RELIEVED_OVHD_SCRAP_VALUE
,      RELIEVED_VARIANCE_VALUE
,      TEMP_RELIEVED_VALUE
,      RELIEVED_OVHD_FINAL_COMP_UNITS
,      RELIEVED_OVHD_UNITS
,      RELIEVED_OVHD_VALUE
FROM WIP.WIP_OPERATION_OVERHEADS;

Dependencies

[top of page]

WIP.WIP_OPERATION_OVERHEADS does not reference any database object

WIP.WIP_OPERATION_OVERHEADS is referenced by following:

APPS: WIP_OPERATION_OVERHEADS