View: PMIFV_GL_CM_COST_COMPARISON_V

Product:	PMI - Process Manufacturing Intelligence
Description:	Costing information from both the GL and Process Manufacturing costing tables.
Implementation/DBA Data:	APPS.PMIFV_GL_CM_COST_COMPARISON_V

View Text

SELECT ITEM.ITEM_NO
, COSTDETAIL.WHSE_CODE
, COSTDETAIL.CALENDAR_CODE
, CLDRHDR.CALENDAR_DESC
, COSTDETAIL.PERIOD_CODE
, CLDRDTL.PERIOD_DESC
, COSTDETAIL.COST_MTHD_CODE
, NULL
, COSTMASTER.COST_CMPNTCLS_CODE
, COSTDETAIL.COST_ANALYSIS_CODE
, SUM(COSTDETAIL.CMPNT_COST)
, 0
FROM CM_CMPT_MST COSTMASTER
, IC_ITEM_MST_B ITEM
, CM_CMPT_DTL COSTDETAIL
, IC_WHSE_MST WAREHOUSE
, CM_CLDR_HDR CLDRHDR
, CM_CLDR_DTL CLDRDTL
WHERE ITEM.ITEM_ID = COSTDETAIL.ITEM_ID
AND COSTMASTER.COST_CMPNTCLS_ID = COSTDETAIL.COST_CMPNTCLS_ID
AND COSTDETAIL.WHSE_CODE = WAREHOUSE.WHSE_CODE(+)
AND COSTDETAIL.CALENDAR_CODE = CLDRHDR.CALENDAR_CODE(+)
AND COSTDETAIL.CALENDAR_CODE = CLDRDTL.CALENDAR_CODE(+)
AND COSTDETAIL.PERIOD_CODE = CLDRDTL.PERIOD_CODE(+)
AND COSTDETAIL.DELETE_MARK = 0
AND (WAREHOUSE.ORGN_CODE IS NULL OR WAREHOUSE.ORGN_CODE IN (SELECT SECORG.ORGN_CODE
FROM SY_ORGN_MST SECORG
WHERE PMI_SECURITY_PKG.SHOW_RECORD(SECORG.ORGN_CODE) = 'TRUE')) GROUP BY ITEM.ITEM_NO
, COSTDETAIL.WHSE_CODE
, COSTDETAIL.CALENDAR_CODE
, CLDRHDR.CALENDAR_DESC
, COSTDETAIL.PERIOD_CODE
, CLDRDTL.PERIOD_DESC
, COSTDETAIL.COST_MTHD_CODE
, COSTMASTER.COST_CMPNTCLS_CODE
, COSTDETAIL.COST_ANALYSIS_CODE UNION ALL SELECT ITEM.ITEM_NO
, COSTDETAIL.WHSE_CODE
, COSTDETAIL.CALENDAR_CODE
, CLDRHDR.CALENDAR_DESC
, COSTDETAIL.PERIOD_CODE
, CLDRDTL.PERIOD_DESC
, NULL
, COSTDETAIL.COST_MTHD_CODE
, COSTMASTER.COST_CMPNTCLS_CODE
, ITEMDETAIL.COST_ANALYSIS_CODE
, 0
, SUM(ITEMDETAIL.CMPTCOST_AMT)
FROM CM_CMPT_MST COSTMASTER
, IC_ITEM_MST ITEM
, GL_ITEM_DTL ITEMDETAIL
, GL_ITEM_CST COSTDETAIL
, IC_WHSE_MST WAREHOUSE
, CM_CLDR_HDR CLDRHDR
, CM_CLDR_DTL CLDRDTL
WHERE ITEM.ITEM_ID = COSTDETAIL.ITEM_ID
AND COSTMASTER.COST_CMPNTCLS_ID = ITEMDETAIL.COST_CMPNTCLS_ID
AND ITEMDETAIL.ITEMCOST_ID = COSTDETAIL.ITEMCOST_ID
AND COSTDETAIL.WHSE_CODE = WAREHOUSE.WHSE_CODE(+)
AND COSTDETAIL.CALENDAR_CODE = CLDRHDR.CALENDAR_CODE(+)
AND COSTDETAIL.CALENDAR_CODE = CLDRDTL.CALENDAR_CODE(+)
AND COSTDETAIL.PERIOD_CODE = CLDRDTL.PERIOD_CODE(+)
AND COSTDETAIL.DELETE_MARK = 0
AND ITEMDETAIL.DELETE_MARK = 0
AND (WAREHOUSE.ORGN_CODE IS NULL OR WAREHOUSE.ORGN_CODE IN (SELECT SECORG.ORGN_CODE
FROM SY_ORGN_MST SECORG
WHERE PMI_SECURITY_PKG.SHOW_RECORD(SECORG.ORGN_CODE) = 'TRUE')) GROUP BY ITEM.ITEM_NO
, COSTDETAIL.WHSE_CODE
, COSTDETAIL.CALENDAR_CODE
, CLDRHDR.CALENDAR_DESC
, COSTDETAIL.PERIOD_CODE
, CLDRDTL.PERIOD_DESC
, COSTDETAIL.COST_MTHD_CODE
, COSTMASTER.COST_CMPNTCLS_CODE
, ITEMDETAIL.COST_ANALYSIS_CODE WITH READ ONLY

Columns