eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PMIFV_GL_CM_COST_COMPARISON_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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