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_GL_CM_COST_COMPARISON_V

Object Details

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

View Type

A Business Intelligence System view

Costing info from the GL and OPM tables combined to facilitate comparison.

[View Source]

Columns

Name	Datatype	Length	Comments
ITEM_ID	NUMBER	(10)	ID of the Item
WAREHOUSE_CODE	VARCHAR2	(4)	Warehouse
CALENDAR_CODE	VARCHAR2	(4)	Calendar specified by start date and end date
PERIOD_CODE	VARCHAR2	(4)	Period specified by start date and end date
CDA_COST_MTHD_CODE	VARCHAR2	(4)	Not currently used.
GL_COST_MTHD_CODE	VARCHAR2	(4)	Cost method for accounting cost.
COST_COMPONENT_CLASS_CODE	VARCHAR2	(16)	Cost component class
COST_ANALYSIS_CODE	VARCHAR2	(4)	Analysis Code
COST	NUMBER		Cost
GL_COST	NUMBER		Component Cost

Query Text

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


SELECT ITEM_ID
,      WAREHOUSE_CODE
,      CALENDAR_CODE
,      PERIOD_CODE
,      CDA_COST_MTHD_CODE
,      GL_COST_MTHD_CODE
,      COST_COMPONENT_CLASS_CODE
,      COST_ANALYSIS_CODE
,      COST
,      GL_COST
FROM APPS.PMIBV_GL_CM_COST_COMPARISON_V;

Dependencies

[top of page]

APPS.PMIBV_GL_CM_COST_COMPARISON_V references the following:

APPS: CM_CMPT_DTL; CM_CMPT_MST; GL_ITEM_CST; GL_ITEM_DTL

APPS.PMIBV_GL_CM_COST_COMPARISON_V is not referenced by any database object