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

Object Details

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

View Type

A Business Intelligence System view

This shows the details of the cost of an item in a period and cost group. The costs are stored by element and level.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
COST_LAYER_ID	NUMBER		Yes	cost layer identifier
COST_ELEMENT_ID	NUMBER		Yes	cost element identifier
LEVEL_TYPE_ID	NUMBER		Yes	level type identifier
PAC_PERIOD_ID	NUMBER		Yes	period identifier
COST_GROUP_ID	NUMBER		Yes	cost group identifier
INVENTORY_ITEM_ID	NUMBER		Yes	item identifier
ORGANIZATION_ID	NUMBER			organization identifier
ITEM_COST	NUMBER		Yes	item elemental cost
ITEM_BUY_COST	NUMBER			elemental item buy cost for this period
ITEM_MAKE_COST	NUMBER			The elemental make item cost at the end of the period
COST_ELEMENT_NAME	VARCHAR2	(50)	Yes	cost element
_LA:LEVEL_TYPE	CHAR	(50)		level type
PAC_PERIOD_NAME	VARCHAR2	(15)	Yes	period name
COST_GROUP_NAME	VARCHAR2	(10)	Yes	cost group
_KF:ITEM_NAME	CHAR	(15)		item name
CREATION_DATE	DATE		Yes	creation date
CREATED_BY	NUMBER		Yes	created by
LAST_UPDATE_DATE	DATE		Yes	last update date
UPDATED_BY	NUMBER		Yes	updated by

Query Text

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


SELECT COST_LAYER_ID
,      COST_ELEMENT_ID
,      LEVEL_TYPE_ID
,      PAC_PERIOD_ID
,      COST_GROUP_ID
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      ITEM_COST
,      ITEM_BUY_COST
,      ITEM_MAKE_COST
,      COST_ELEMENT_NAME
,      _LA:LEVEL_TYPE
,      PAC_PERIOD_NAME
,      COST_GROUP_NAME
,      _KF:ITEM_NAME
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      UPDATED_BY
FROM APPS.CSTFV_PAC_ITEM_COST_DETAILS;

Dependencies

[top of page]

APPS.CSTFV_PAC_ITEM_COST_DETAILS references the following:

APPS: CST_COST_ELEMENTS; CST_COST_GROUPS; CST_PAC_ITEM_COSTS; CST_PAC_ITEM_COST_DETAILS; CST_PAC_PERIODS; MTL_SYSTEM_ITEMS

APPS.CSTFV_PAC_ITEM_COST_DETAILS is not referenced by any database object