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]

VIEW: APPS.CST_CG_COST_HISTORY_V

Object Details

Object Name:	CST_CG_COST_HISTORY_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BOM.CST_CG_COST_HISTORY_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Comments
INVENTORY_ITEM_ID	NUMBER		Inventory Item Identifier
TRANSACTION_ID	NUMBER		Transaction ID
ORGANIZATION_ID	NUMBER		Organization Identifier
LAYER_ID	NUMBER		Layer ID
TRANSACTION_COSTED_DATE	DATE		Transaction costed date
TRANSACTION_DATE	DATE		Transaction date
PRIOR_COSTED_QUANTITY	NUMBER		Prior Costed Quantity
PRIMARY_QUANTITY	NUMBER		Primary Quantity
NEW_QUANTITY	NUMBER		New quantity
COST_GROUP_ID	NUMBER		Cost group id
TRANSACTION_TYPE	VARCHAR2	(80)	Transaction type
ACTUAL_COST	NUMBER		Actual Cost
ACTUAL_MATERIAL	NUMBER		Material Element Cost
ACTUAL_MATERIAL_OVERHEAD	NUMBER		Material Overhead Element Cost
ACTUAL_RESOURCE	NUMBER		Resource Element Cost
ACTUAL_OUTSIDE_PROCESSING	NUMBER		Outside Processing Element Cost
ACTUAL_OVERHEAD	NUMBER		Overhead Cost
PRIOR_COST	NUMBER		Prior Cost
PRIOR_MATERIAL	NUMBER		Prior material element cost
PRIOR_MATERIAL_OVERHEAD	NUMBER		Prior material overhead cost
PRIOR_RESOURCE	NUMBER		Prior resource element cost
PRIOR_OUTSIDE_PROCESSING	NUMBER		Prior outside processing element cost
PRIOR_OVERHEAD	NUMBER		Prior overhead cost
NEW_COST	NUMBER		New cost
NEW_MATERIAL	NUMBER		New material element cost
NEW_MATERIAL_OVERHEAD	NUMBER		New material overhead element cost
NEW_RESOURCE	NUMBER		New resource element cost
NEW_OUTSIDE_PROCESSING	NUMBER		New outside processing element cost
NEW_OVERHEAD	NUMBER		New overhead cost
CHANGE	VARCHAR2	(1)	Cost element change flag

Query Text

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


SELECT INVENTORY_ITEM_ID
,      TRANSACTION_ID
,      ORGANIZATION_ID
,      LAYER_ID
,      TRANSACTION_COSTED_DATE
,      TRANSACTION_DATE
,      PRIOR_COSTED_QUANTITY
,      PRIMARY_QUANTITY
,      NEW_QUANTITY
,      COST_GROUP_ID
,      TRANSACTION_TYPE
,      ACTUAL_COST
,      ACTUAL_MATERIAL
,      ACTUAL_MATERIAL_OVERHEAD
,      ACTUAL_RESOURCE
,      ACTUAL_OUTSIDE_PROCESSING
,      ACTUAL_OVERHEAD
,      PRIOR_COST
,      PRIOR_MATERIAL
,      PRIOR_MATERIAL_OVERHEAD
,      PRIOR_RESOURCE
,      PRIOR_OUTSIDE_PROCESSING
,      PRIOR_OVERHEAD
,      NEW_COST
,      NEW_MATERIAL
,      NEW_MATERIAL_OVERHEAD
,      NEW_RESOURCE
,      NEW_OUTSIDE_PROCESSING
,      NEW_OVERHEAD
,      CHANGE
FROM APPS.CST_CG_COST_HISTORY_V;

Dependencies

[top of page]

APPS.CST_CG_COST_HISTORY_V references the following:

APPS: CST_QUANTITY_LAYERS; MTL_CST_ACTUAL_COST_DETAILS; MTL_INTERORG_PARAMETERS; MTL_MATERIAL_TRANSACTIONS; MTL_PARAMETERS; MTL_SECONDARY_INVENTORIES; MTL_SYSTEM_ITEMS; MTL_TRANSACTION_TYPES

APPS.CST_CG_COST_HISTORY_V is referenced by following:

APPS: PJM_PROJECT_COST_HISTORY_V