DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.PMIFV_GL_CM_COST_COMPARISON_V

Object Details
Object Name: PMIFV_GL_CM_COST_COMPARISON_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPMI.PMIFV_GL_CM_COST_COMPARISON_V
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


Costing information from both the GL and Process Manufacturing costing tables.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ITEM_NUMBER VARCHAR2 (32)
Name of the item.
WAREHOUSE_CODE VARCHAR2 (4)
Warehouse
CALENDAR_CODE VARCHAR2 (4)
Calendar specified by start date and end date
CALENDAR_DESCRIPTION VARCHAR2 (40)
Costing Calendar description
PERIOD_CODE VARCHAR2 (4)
Period specified by start date and end date
PERIOD_DESCRIPTION VARCHAR2 (40)
Costing Period Description
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_NUMBER
,      WAREHOUSE_CODE
,      CALENDAR_CODE
,      CALENDAR_DESCRIPTION
,      PERIOD_CODE
,      PERIOD_DESCRIPTION
,      CDA_COST_MTHD_CODE
,      GL_COST_MTHD_CODE
,      COST_COMPONENT_CLASS_CODE
,      COST_ANALYSIS_CODE
,      COST
,      GL_COST
FROM APPS.PMIFV_GL_CM_COST_COMPARISON_V;

Dependencies

[top of page]

APPS.PMIFV_GL_CM_COST_COMPARISON_V references the following:

SchemaAPPS
SynonymCM_CLDR_DTL
SynonymCM_CLDR_HDR
SynonymCM_CMPT_DTL
SynonymCM_CMPT_MST
SynonymGL_ITEM_CST
SynonymGL_ITEM_DTL
SynonymIC_ITEM_MST
SynonymIC_ITEM_MST_B
SynonymIC_WHSE_MST
PL/SQL PackagePMI_SECURITY_PKG - show dependent code
SynonymSY_ORGN_MST

APPS.PMIFV_GL_CM_COST_COMPARISON_V is not referenced by any database object