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.CSTBV_PAC_ITEM_COSTS

Object Details

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

View Type

A Business Intelligence System view

This shows the item cost and quantity in a period and cost group. The quantity and cost are computed by summarizing the transactions belonging to a particular cost group in one period.
The COST_LAYER_ID is unique for a period / cost group / item combination.

[View Source]

Columns

Name	Datatype	Length	Mandatory
COST_LAYER_ID	NUMBER		Yes
PAC_PERIOD_ID	NUMBER		Yes
COST_GROUP_ID	NUMBER		Yes
INVENTORY_ITEM_ID	NUMBER		Yes
BUY_QUANTITY	NUMBER
MAKE_QUANTITY	NUMBER
ISSUE_QUANTITY	NUMBER
TOTAL_LAYER_QUANTITY	NUMBER
ITEM_COST	NUMBER
ITEM_BUY_COST	NUMBER
ITEM_MAKE_COST	NUMBER
BEGIN_ITEM_COST	NUMBER
MATERIAL_COST	NUMBER
MATERIAL_OVERHEAD_COST	NUMBER
RESOURCE_COST	NUMBER
OVERHEAD_COST	NUMBER
OUTSIDE_PROCESSING_COST	NUMBER
UNBURDENED_COST	NUMBER
BURDEN_COST	NUMBER
PAC_PERIOD_NAME	VARCHAR2	(15)	Yes
COST_GROUP_NAME	VARCHAR2	(10)	Yes
_KF:ITEM_NAME	CHAR	(15)
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
UPDATED_BY	NUMBER		Yes

Query Text

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


SELECT COST_LAYER_ID
,      PAC_PERIOD_ID
,      COST_GROUP_ID
,      INVENTORY_ITEM_ID
,      BUY_QUANTITY
,      MAKE_QUANTITY
,      ISSUE_QUANTITY
,      TOTAL_LAYER_QUANTITY
,      ITEM_COST
,      ITEM_BUY_COST
,      ITEM_MAKE_COST
,      BEGIN_ITEM_COST
,      MATERIAL_COST
,      MATERIAL_OVERHEAD_COST
,      RESOURCE_COST
,      OVERHEAD_COST
,      OUTSIDE_PROCESSING_COST
,      UNBURDENED_COST
,      BURDEN_COST
,      PAC_PERIOD_NAME
,      COST_GROUP_NAME
,      _KF:ITEM_NAME
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      UPDATED_BY
FROM APPS.CSTBV_PAC_ITEM_COSTS;

Dependencies

[top of page]

APPS.CSTBV_PAC_ITEM_COSTS references the following:

APPS: CST_COST_GROUPS; CST_PAC_ITEM_COSTS; CST_PAC_PERIODS; MTL_SYSTEM_ITEMS

APPS.CSTBV_PAC_ITEM_COSTS is not referenced by any database object