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

Object Details

Object Name:	PMIBV_ITEM_COST_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PMI.PMIBV_ITEM_COST_V
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

Costing info for an item. Costing info is retrieved from CM tables, OPM equivalent of the item_cost_from_GL view which retrieves data from the GL tables.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
COST_LEVEL	NUMBER	(5)	Yes	Cost source. 0=Directly entered or Routing/Burden costs calculated by Cost Rollup process or Actual Cost Process, 1= Costs via Ingredient calculated by Cost Rollup Process.
COMPONENT_COST	NUMBER		Yes	Component cost
BURDEN_INDICATOR	NUMBER	(5)	Yes	Indicates if costs came from burdens 0=No 1=Yes
ROLLOVER_INDICATOR	NUMBER	(5)	Yes	Indicates if costs have been updated to GL area and hence frozen or not - 0=No 1=Yes, updated.
TOTAL_QTY	NUMBER			Written by Actual Cost Process. Usually the total transaction quantity of the item used in calculating the actual cost but not used currently by other programs.
COSTCALC_ORIG	NUMBER	(5)		Cost calculation origin for actual costs only; 0 = Actual Cost Calculation, 1 = Cost Development Process
RMCALC_TYPE	NUMBER	(5)		Raw Material Cost Calculation Type (applicable under actual costs only, =0 otherwise) 1-PMAC, 2-PWAC, 3-PPAC, 4-LSTT, 5 -LSTI
ROLLUP_REF_NO	NUMBER	(10)		Reference number of the Cost Rollup process that calculated this cost
FORMULA_EFF_ID	NUMBER	(10)		Effectivity used in determining Product(hence formula, routing - if any) during Cost Rollup Process
COMPONENT_COST_ID	NUMBER	(10)	Yes	Surrogate ID for the Cost Component
ITEM_ID	NUMBER	(10)		Surrogate for item for which the cost is specified
WHSE_CODE	VARCHAR2	(4)		Warehouse for which the cost is specified
CALENDAR_CODE	VARCHAR2	(4)		Cost Calendar for which the cost is specified
PERIOD_CODE	VARCHAR2	(4)		Costing Period for which the cost is specified
COST_MTHD_CODE	VARCHAR2	(4)		Cost Method for which the cost is specified
COST_CMPNTCLS_ID	NUMBER	(10)	Yes	Surrogate for component class
COST_ANALYSIS_CODE	VARCHAR2	(32)	Yes	Analysis code
CREATED_BY	VARCHAR2	(32)	Yes	Standard who column
CREATION_DATE	VARCHAR2	(240)	Yes	Standard who column
LAST_UPDATE_DATE	NUMBER	(10)	Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(5)	Yes	Standard who column
COST_CMPNTCLS_CODE	NUMBER	(10)	Yes	Cost component class
COST_CMPNTCLS_DESC	NUMBER	(5)	Yes	Cost component class description
SORT_SEQUENCE	NUMBER	(5)	Yes	Sequence the component costs are sorted by on Cost details screen
USAGE_IND	VARCHAR2	(32)		Component Usage indicator. 1=material 2=burden(overhead) 3=routing 4=GL expense allocation 5=Standard Cost adjustment
PRIMARY_COMPONENT_CLASS_ID	NUMBER	(5)	Yes	Primary cost component class. This field will be used to identify the primary cost component class that this component class is associated with. Default is Primary Class.
PRODUCT_COST_IND	NUMBER	(15)	Yes	This field indicates whether the component class will affect the cost of a product or not. Valid values are: 0 = Not a product cost , 1 = Product Cost.
UPDATE_COST_IND	DATE		Yes	This field indicates whether the component cost will be updated to the GL area. Valid Values are 0 = Do not update to GL area, 1 = Update to GL Area.
CMPNT_GROUP	DATE		Yes	Component Group this component class belongs to. FK to cm_cmpt_grp.cmpnt_group
PPV_IND	NUMBER	(15)	Yes	Indicates if PPV calculations should use this component cost or not. 1=include in PPV calculations. 0=Do not include in PPV calculations.

Query Text

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


SELECT COST_LEVEL
,      COMPONENT_COST
,      BURDEN_INDICATOR
,      ROLLOVER_INDICATOR
,      TOTAL_QTY
,      COSTCALC_ORIG
,      RMCALC_TYPE
,      ROLLUP_REF_NO
,      FORMULA_EFF_ID
,      COMPONENT_COST_ID
,      ITEM_ID
,      WHSE_CODE
,      CALENDAR_CODE
,      PERIOD_CODE
,      COST_MTHD_CODE
,      COST_CMPNTCLS_ID
,      COST_ANALYSIS_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      COST_CMPNTCLS_CODE
,      COST_CMPNTCLS_DESC
,      SORT_SEQUENCE
,      USAGE_IND
,      PRIMARY_COMPONENT_CLASS_ID
,      PRODUCT_COST_IND
,      UPDATE_COST_IND
,      CMPNT_GROUP
,      PPV_IND
FROM APPS.PMIBV_ITEM_COST_V;

Dependencies

[top of page]

APPS.PMIBV_ITEM_COST_V references the following:

APPS: CM_CMPT_DTL; CM_CMPT_MST

APPS.PMIBV_ITEM_COST_V is not referenced by any database object