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_DEFAULT_COST_VIEW

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Mandatory	Comments
COST_TYPE_ID	NUMBER	Yes	Cost type identifier
ACTUAL_COST_TYPE_ID	NUMBER	Yes	Cost type identifier or the default cost type identifier
INVENTORY_ITEM_ID	NUMBER	Yes	Inventory item identifier
ORGANIZATION_ID	NUMBER	Yes	Organization identifier
INVENTORY_ASSET_FLAG	NUMBER	Yes	Flag indicating whether the item is asset or expense
LOT_SIZE	NUMBER		Lot Size
BASED_ON_ROLLUP_FLAG	NUMBER		Flag indicating whether cost will be rolled up
SHRINKAGE_RATE	NUMBER		Manufacturing shrinkage rate (for make item only)
DEFAULTED_FLAG	NUMBER	Yes	Flag indicating whether the cost of the item is defaulted from the default cost type during cost roll up
COST_UPDATE_ID	NUMBER		Cost update session identifier
PL_MATERIAL	NUMBER		Previous level material cost
PL_MATERIAL_OVERHEAD	NUMBER		Previous level material overhead cost
PL_RESOURCE	NUMBER		Previous level resource cost
PL_OUTSIDE_PROCESSING	NUMBER		Previous level outside processing cost
PL_OVERHEAD	NUMBER		Previous level overhead cost
TL_MATERIAL	NUMBER		This level material cost
TL_MATERIAL_OVERHEAD	NUMBER		This level material overhead cost
TL_OUTSIDE_PROCESSING	NUMBER		This level outside processing cost
TL_OVERHEAD	NUMBER		This level overhead cost
MATERIAL_COST	NUMBER		Material cost
MATERIAL_OVERHEAD_COST	NUMBER		Material overhead cost
RESOURCE_COST	NUMBER		Resource cost
OUTSIDE_PROCESSING_COST	NUMBER		Outside Processing cost
OVERHEAD_COST	NUMBER		Overhead cost
PL_ITEM_COST	NUMBER		Total previous level cost
TL_ITEM_COST	NUMBER		Total this level cost
ITEM_COST	NUMBER		Total item unit cost
UNBURDENED_COST	NUMBER		Item unit cost minus this level material overhead
BURDEN_COST	NUMBER		This level material overhead

Query Text

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


SELECT COST_TYPE_ID
,      ACTUAL_COST_TYPE_ID
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      INVENTORY_ASSET_FLAG
,      LOT_SIZE
,      BASED_ON_ROLLUP_FLAG
,      SHRINKAGE_RATE
,      DEFAULTED_FLAG
,      COST_UPDATE_ID
,      PL_MATERIAL
,      PL_MATERIAL_OVERHEAD
,      PL_RESOURCE
,      PL_OUTSIDE_PROCESSING
,      PL_OVERHEAD
,      TL_MATERIAL
,      TL_MATERIAL_OVERHEAD
,      TL_OUTSIDE_PROCESSING
,      TL_OVERHEAD
,      MATERIAL_COST
,      MATERIAL_OVERHEAD_COST
,      RESOURCE_COST
,      OUTSIDE_PROCESSING_COST
,      OVERHEAD_COST
,      PL_ITEM_COST
,      TL_ITEM_COST
,      ITEM_COST
,      UNBURDENED_COST
,      BURDEN_COST
FROM APPS.CST_DEFAULT_COST_VIEW;

Dependencies

[top of page]

APPS.CST_DEFAULT_COST_VIEW references the following:

APPS: CST_COST_TYPES; CST_ITEM_COSTS

APPS.CST_DEFAULT_COST_VIEW is not referenced by any database object