DBA Data[Home] [Help]

VIEW: APPS.PMIBV_GL_CM_COST_COMPARISON_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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