View: PMIBV_GL_CM_COST_COMPARISON_V

Product:	PMI - Process Manufacturing Intelligence
Description:	Costing info from the GL and OPM tables combined to facilitate comparison of these two sources of similar data.
Implementation/DBA Data:	APPS.PMIBV_GL_CM_COST_COMPARISON_V

View Text

SELECT COSTDETAIL.ITEM_ID
, COSTDETAIL.WHSE_CODE
, COSTDETAIL.CALENDAR_CODE
, COSTDETAIL.PERIOD_CODE
, COSTDETAIL.COST_MTHD_CODE
, NULL
, COSTMASTER.COST_CMPNTCLS_CODE
, COSTDETAIL.COST_ANALYSIS_CODE
, SUM(COSTDETAIL.CMPNT_COST)
, 0
FROM CM_CMPT_MST COSTMASTER
, CM_CMPT_DTL COSTDETAIL
WHERE COSTMASTER.COST_CMPNTCLS_ID = COSTDETAIL.COST_CMPNTCLS_ID
AND COSTDETAIL.DELETE_MARK = 0 GROUP BY COSTDETAIL.ITEM_ID
, COSTDETAIL.WHSE_CODE
, COSTDETAIL.CALENDAR_CODE
, COSTDETAIL.PERIOD_CODE
, COSTDETAIL.COST_MTHD_CODE
, COSTMASTER.COST_CMPNTCLS_CODE
, COSTDETAIL.COST_ANALYSIS_CODE UNION ALL SELECT COSTDETAIL.ITEM_ID
, COSTDETAIL.WHSE_CODE
, COSTDETAIL.CALENDAR_CODE
, COSTDETAIL.PERIOD_CODE
, NULL
, COSTDETAIL.COST_MTHD_CODE
, COSTMASTER.COST_CMPNTCLS_CODE
, ITEMDETAIL.COST_ANALYSIS_CODE
, 0
, SUM(ITEMDETAIL.CMPTCOST_AMT)
FROM CM_CMPT_MST COSTMASTER
, GL_ITEM_DTL ITEMDETAIL
, GL_ITEM_CST COSTDETAIL
WHERE COSTMASTER.COST_CMPNTCLS_ID = ITEMDETAIL.COST_CMPNTCLS_ID
AND ITEMDETAIL.ITEMCOST_ID = COSTDETAIL.ITEMCOST_ID
AND COSTDETAIL.DELETE_MARK = 0
AND ITEMDETAIL.DELETE_MARK = 0 GROUP BY COSTDETAIL.ITEM_ID
, COSTDETAIL.WHSE_CODE
, COSTDETAIL.CALENDAR_CODE
, COSTDETAIL.PERIOD_CODE
, COSTDETAIL.COST_MTHD_CODE
, COSTMASTER.COST_CMPNTCLS_CODE
, ITEMDETAIL.COST_ANALYSIS_CODE WITH READ ONLY

Columns