[Home] [Help]
View: PMIBV_GL_CM_COST_COMPARISON_V
Product: | PMI - Process Manufacturing Intelligence (Obsolete) |
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
Name |
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 |