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.QPR_PRICE_SALES_MEAS_ALL_V1

Source

View Text - Preformatted


SELECT a.instance_id, a.psg_level_value, a.ord_level_value, a.prd_level_value, a.geo_level_value, a.cus_level_value, a.org_level_value, a.rep_level_value, a.chn_level_value, NULL, NULL, a.time_level_value, qpr_sr_util.ods_uom_conv(a.prd_level_value, a.measure_uom, qpr_maintain_aw.get_base_uom, a.instance_id) * a.measure1_number, qpr_sr_util.ods_curr_conversion(NULL, qpr_maintain_aw.get_currency_code, NULL, a.time_level_value, a.instance_id) * a.measure2_number, qpr_sr_util.ods_curr_conversion(NULL, qpr_maintain_aw.get_currency_code, NULL, a.time_level_value, a.instance_id) *(nvl(a.measure20_number, 0) + a.measure2_number), qpr_sr_util.ods_curr_conversion(NULL, qpr_maintain_aw.get_currency_code, NULL, a.time_level_value, a.instance_id) * a.measure3_number / qpr_sr_util.ods_uom_conv(a.prd_level_value, a.measure_uom, qpr_maintain_aw.get_base_uom, a.instance_id), qpr_sr_util.ods_curr_conversion(NULL, qpr_maintain_aw.get_currency_code, NULL, a.time_level_value, a.instance_id) * a.measure4_number / qpr_sr_util.ods_uom_conv(a.prd_level_value, a.measure_uom, qpr_maintain_aw.get_base_uom, a.instance_id), qpr_sr_util.ods_curr_conversion(NULL, qpr_maintain_aw.get_currency_code, NULL, a.time_level_value, a.instance_id) * a.measure5_number / qpr_sr_util.ods_uom_conv(a.prd_level_value, a.measure_uom, qpr_maintain_aw.get_base_uom, a.instance_id), a.measure6_number, a.measure13_number, a.measure21_number, a.measure22_number, a.measure23_number, a.measure24_number, a.measure25_number, a.measure26_number, a.measure27_number, a.measure28_number, a.measure29_number, a.measure30_number, a.measure1_char, a.measure2_char, a.measure3_char, a.measure4_char, a.measure5_char, measure_uom, qpr_sr_util.ods_curr_conversion(NULL, qpr_maintain_aw.get_currency_code, NULL, a.time_level_value, a.instance_id) * a.measure5_number / qpr_sr_util.ods_uom_conv(a.prd_level_value, a.measure_uom, qpr_maintain_aw.get_base_uom, a.instance_id), qpr_sr_util.ods_curr_conversion(NULL, qpr_maintain_aw.get_currency_code, NULL, a.time_level_value, a.instance_id) * a.measure14_number, qpr_sr_util.ods_curr_conversion(NULL, qpr_maintain_aw.get_currency_code, NULL, a.time_level_value, a.instance_id) * a.measure15_number, measure17_number, decode(nvl(measure1_char, '*'), 'MODEL', qpr_sr_util.ods_uom_conv(a.prd_level_value, a.measure_uom, qpr_maintain_aw.get_base_uom, a.instance_id) * a.measure1_number, decode(nvl(measure1_char, '*'), 'KIT', qpr_sr_util.ods_uom_conv(a.prd_level_value, a.measure_uom, qpr_maintain_aw.get_base_uom, a.instance_id) * a.measure1_number, 0), 0) FROM qpr_measure_data a WHERE a.measure_type_code = 'SALESDATA'

View Text - HTML Formatted

SELECT A.INSTANCE_ID
, A.PSG_LEVEL_VALUE
, A.ORD_LEVEL_VALUE
, A.PRD_LEVEL_VALUE
, A.GEO_LEVEL_VALUE
, A.CUS_LEVEL_VALUE
, A.ORG_LEVEL_VALUE
, A.REP_LEVEL_VALUE
, A.CHN_LEVEL_VALUE
, NULL
, NULL
, A.TIME_LEVEL_VALUE
, QPR_SR_UTIL.ODS_UOM_CONV(A.PRD_LEVEL_VALUE
, A.MEASURE_UOM
, QPR_MAINTAIN_AW.GET_BASE_UOM
, A.INSTANCE_ID) * A.MEASURE1_NUMBER
, QPR_SR_UTIL.ODS_CURR_CONVERSION(NULL
, QPR_MAINTAIN_AW.GET_CURRENCY_CODE
, NULL
, A.TIME_LEVEL_VALUE
, A.INSTANCE_ID) * A.MEASURE2_NUMBER
, QPR_SR_UTIL.ODS_CURR_CONVERSION(NULL
, QPR_MAINTAIN_AW.GET_CURRENCY_CODE
, NULL
, A.TIME_LEVEL_VALUE
, A.INSTANCE_ID) *(NVL(A.MEASURE20_NUMBER
, 0) + A.MEASURE2_NUMBER)
, QPR_SR_UTIL.ODS_CURR_CONVERSION(NULL
, QPR_MAINTAIN_AW.GET_CURRENCY_CODE
, NULL
, A.TIME_LEVEL_VALUE
, A.INSTANCE_ID) * A.MEASURE3_NUMBER / QPR_SR_UTIL.ODS_UOM_CONV(A.PRD_LEVEL_VALUE
, A.MEASURE_UOM
, QPR_MAINTAIN_AW.GET_BASE_UOM
, A.INSTANCE_ID)
, QPR_SR_UTIL.ODS_CURR_CONVERSION(NULL
, QPR_MAINTAIN_AW.GET_CURRENCY_CODE
, NULL
, A.TIME_LEVEL_VALUE
, A.INSTANCE_ID) * A.MEASURE4_NUMBER / QPR_SR_UTIL.ODS_UOM_CONV(A.PRD_LEVEL_VALUE
, A.MEASURE_UOM
, QPR_MAINTAIN_AW.GET_BASE_UOM
, A.INSTANCE_ID)
, QPR_SR_UTIL.ODS_CURR_CONVERSION(NULL
, QPR_MAINTAIN_AW.GET_CURRENCY_CODE
, NULL
, A.TIME_LEVEL_VALUE
, A.INSTANCE_ID) * A.MEASURE5_NUMBER / QPR_SR_UTIL.ODS_UOM_CONV(A.PRD_LEVEL_VALUE
, A.MEASURE_UOM
, QPR_MAINTAIN_AW.GET_BASE_UOM
, A.INSTANCE_ID)
, A.MEASURE6_NUMBER
, A.MEASURE13_NUMBER
, A.MEASURE21_NUMBER
, A.MEASURE22_NUMBER
, A.MEASURE23_NUMBER
, A.MEASURE24_NUMBER
, A.MEASURE25_NUMBER
, A.MEASURE26_NUMBER
, A.MEASURE27_NUMBER
, A.MEASURE28_NUMBER
, A.MEASURE29_NUMBER
, A.MEASURE30_NUMBER
, A.MEASURE1_CHAR
, A.MEASURE2_CHAR
, A.MEASURE3_CHAR
, A.MEASURE4_CHAR
, A.MEASURE5_CHAR
, MEASURE_UOM
, QPR_SR_UTIL.ODS_CURR_CONVERSION(NULL
, QPR_MAINTAIN_AW.GET_CURRENCY_CODE
, NULL
, A.TIME_LEVEL_VALUE
, A.INSTANCE_ID) * A.MEASURE5_NUMBER / QPR_SR_UTIL.ODS_UOM_CONV(A.PRD_LEVEL_VALUE
, A.MEASURE_UOM
, QPR_MAINTAIN_AW.GET_BASE_UOM
, A.INSTANCE_ID)
, QPR_SR_UTIL.ODS_CURR_CONVERSION(NULL
, QPR_MAINTAIN_AW.GET_CURRENCY_CODE
, NULL
, A.TIME_LEVEL_VALUE
, A.INSTANCE_ID) * A.MEASURE14_NUMBER
, QPR_SR_UTIL.ODS_CURR_CONVERSION(NULL
, QPR_MAINTAIN_AW.GET_CURRENCY_CODE
, NULL
, A.TIME_LEVEL_VALUE
, A.INSTANCE_ID) * A.MEASURE15_NUMBER
, MEASURE17_NUMBER
, DECODE(NVL(MEASURE1_CHAR
, '*')
, 'MODEL'
, QPR_SR_UTIL.ODS_UOM_CONV(A.PRD_LEVEL_VALUE
, A.MEASURE_UOM
, QPR_MAINTAIN_AW.GET_BASE_UOM
, A.INSTANCE_ID) * A.MEASURE1_NUMBER
, DECODE(NVL(MEASURE1_CHAR
, '*')
, 'KIT'
, QPR_SR_UTIL.ODS_UOM_CONV(A.PRD_LEVEL_VALUE
, A.MEASURE_UOM
, QPR_MAINTAIN_AW.GET_BASE_UOM
, A.INSTANCE_ID) * A.MEASURE1_NUMBER
, 0)
, 0)
FROM QPR_MEASURE_DATA A
WHERE A.MEASURE_TYPE_CODE = 'SALESDATA'