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_PAC_ACTUAL_COST_DETAILS

Object Details

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

Stores the actual cost of WIP transactions for each WIP entity in a cost group by period. Applicable transactions are resource, overhead, outside processing and job close. COST_ELEMENT_ID indicates the cost element involved in the transaction for resource, outside processing, or overhead. BASIS_RESOURCE_ID is populated for resource-based overhead charges
and indicates the resource ID associated with the overhead charged. BASIS_UNITS is also applicable only to resource-based overhead charges and indicates the units (value or quantity) of the basis resource that was used as the charge factor. LEVEL_TYPE is the current level for all transactions other than job close transactions.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WIP_PAC_ACTUAL_COST_DETAILS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_ID PAC_PERIOD_ID COST_GROUP_ID COST_ELEMENT_ID
WIP_PAC_ACTUAL_COST_DETAILS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAC_PERIOD_ID COST_GROUP_ID

Columns

Name	Datatype	Mandatory	Comments
PAC_PERIOD_ID	NUMBER	Yes	Period identifier
COST_GROUP_ID	NUMBER	Yes	Cost group identifier
COST_TYPE_ID	NUMBER	Yes	Cost type identifier
TRANSACTION_ID	NUMBER	Yes	WIP transaction identifier
LEVEL_TYPE	NUMBER	Yes	Level type
COST_ELEMENT_ID	NUMBER	Yes	Cost element identifier
RESOURCE_ID	NUMBER		Resource, overhead or outside processing identifier
BASIS_RESOURCE_ID	NUMBER		Resource identifier with which the overhead is associated
TRANSACTION_COSTED_DATE	DATE		Date this record was processed
ACTUAL_COST	NUMBER		Per unit cost of the transaction
ACTUAL_VALUE	NUMBER		Extended cost of the transaction
BASIS_TYPE	NUMBER		Basis type
BASIS_UNITS	NUMBER		Basis units
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
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
LAST_UPDATE_LOGIN	NUMBER		Standard Who column

Query Text

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


SELECT PAC_PERIOD_ID
,      COST_GROUP_ID
,      COST_TYPE_ID
,      TRANSACTION_ID
,      LEVEL_TYPE
,      COST_ELEMENT_ID
,      RESOURCE_ID
,      BASIS_RESOURCE_ID
,      TRANSACTION_COSTED_DATE
,      ACTUAL_COST
,      ACTUAL_VALUE
,      BASIS_TYPE
,      BASIS_UNITS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM WIP.WIP_PAC_ACTUAL_COST_DETAILS;

Dependencies

[top of page]

WIP.WIP_PAC_ACTUAL_COST_DETAILS does not reference any database object

WIP.WIP_PAC_ACTUAL_COST_DETAILS is referenced by following:

WIP: WIP_PAC_ACTUAL_COST_DETAILS#