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: BOM.CST_PAC_REQ_OPER_COST_DETAILS

Object Details

Object Name:	CST_PAC_REQ_OPER_COST_DETAILS
Object Type:	TABLE
Owner:	BOM
FND Design Data:	BOM.CST_PAC_REQ_OPER_COST_DETAILS
Subobject Name:
Status:	VALID

Stores the WIP balances for all entities within a cost group by period. Values are stored by WIP_ENTITY_ID, LINE_ID,OPERATION_SEQ_NUM and INVENTORY_ITEM_ID (component).
Applied_Value represent value charged to the entity by Component and Applied_Quantity represent quantity charged to the entity by Component.
Relieved_Value represent value relieved from the entity of component by scrap/completions and Relieved_Quantity represent quantity relieved from the entity of component by scrap/completions.
material_variance represent the difference between Applied_Value and Relieved_Value.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CST_PAC_REQ_OPR_COST_DTLS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAC_PERIOD_ID COST_GROUP_ID WIP_ENTITY_ID

Columns

Name	Datatype	Mandatory	Comments
PAC_PERIOD_ID	NUMBER	Yes	PAC Period ID
COST_GROUP_ID	NUMBER	Yes	Cost Group ID
WIP_ENTITY_ID	NUMBER	Yes	WIP ENTITY ID
LINE_ID	NUMBER		LINE ID
OPERATION_SEQ_NUM	NUMBER		Operation Sequence Number
INVENTORY_ITEM_ID	NUMBER		Component Id
COST_ELEMENT_ID	NUMBER	Yes	Cost Element Id
APPLIED_VALUE	NUMBER		Applied Value to the Job
APPLIED_QUANTITY	NUMBER		Applied Component Qty
RELIEVED_VALUE	NUMBER		Relieved Value
RELIEVED_QUANTITY	NUMBER		Relieved Quantity
COMP_VARIANCE	NUMBER		Comp variance
LAST_UPDATE_DATE	DATE		Standard Who Column
LAST_UPDATED_BY	NUMBER		Standard Who Column
CREATION_DATE	DATE	Yes	Standard Who Column
CREATED_BY	NUMBER	Yes	Standard Who Column
REQUEST_ID	NUMBER		Concurrent Who Column
PROGRAM_APPLICATION_ID	NUMBER		Concurrent Who Column
PROGRAM_ID	NUMBER		Concurrent Who Column
PROGRAM_UPDATE_DATE	DATE		Concurrent Who Column
LAST_UPDATE_LOGIN	NUMBER		Standard Who Column
TEMP_RELIEVED_VALUE	NUMBER		Temp Relieved Value

Query Text

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


SELECT PAC_PERIOD_ID
,      COST_GROUP_ID
,      WIP_ENTITY_ID
,      LINE_ID
,      OPERATION_SEQ_NUM
,      INVENTORY_ITEM_ID
,      COST_ELEMENT_ID
,      APPLIED_VALUE
,      APPLIED_QUANTITY
,      RELIEVED_VALUE
,      RELIEVED_QUANTITY
,      COMP_VARIANCE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      TEMP_RELIEVED_VALUE
FROM BOM.CST_PAC_REQ_OPER_COST_DETAILS;

Dependencies

[top of page]

BOM.CST_PAC_REQ_OPER_COST_DETAILS does not reference any database object

BOM.CST_PAC_REQ_OPER_COST_DETAILS is referenced by following:

APPS: CST_PAC_REQ_OPER_COST_DETAILS