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_REQ_OPERATION_COST_DETAILS

Object Details

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

WIP_REQ_OPERATION_COST_DETAILS stores material costs earned by and
relieved from a job in an average costing organization. This table is
a child table of WIP_REQUIREMENT_OPERATIONS. This table stores
applied and relieved material costs by cost element for each row in
WIP_REQUIREMENT_OPERATIONS.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WIP_REQ_OP_COST_DETAILS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	WIP_ENTITY_ID OPERATION_SEQ_NUM INVENTORY_ITEM_ID COST_ELEMENT_ID

Columns

Name	Datatype	Mandatory	Comments
WIP_ENTITY_ID	NUMBER	Yes	WIP job Identifier
OPERATION_SEQ_NUM	NUMBER	Yes	Operation sequence number
INVENTORY_ITEM_ID	NUMBER	Yes	Item Identifier
COST_ELEMENT_ID	NUMBER	Yes	Cost element 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
ORGANIZATION_ID	NUMBER	Yes	Organization Identifier
APPLIED_MATL_VALUE	NUMBER		Actual value of material issued to WIP
RELIEVED_MATL_COMPLETION_VALUE	NUMBER		Material value relieved due to WIP completion
RELIEVED_MATL_SCRAP_VALUE	NUMBER		Material value 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
,      INVENTORY_ITEM_ID
,      COST_ELEMENT_ID
,      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_MATL_VALUE
,      RELIEVED_MATL_COMPLETION_VALUE
,      RELIEVED_MATL_SCRAP_VALUE
,      RELIEVED_VARIANCE_VALUE
,      TEMP_RELIEVED_VALUE
FROM WIP.WIP_REQ_OPERATION_COST_DETAILS;

Dependencies

[top of page]

WIP.WIP_REQ_OPERATION_COST_DETAILS does not reference any database object

WIP.WIP_REQ_OPERATION_COST_DETAILS is referenced by following:

WIP: WIP_REQ_OPERATION_COST_DETAIL#