VIEW: APPS.QPR_MRG_BAND_MEAS_ALL_V

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, null, a.mgb_level_value, null, a.time_level_value, null, null, null, null, null, a.measure1_number, a.measure2_number, a.measure3_number, a.measure4_number, a.measure5_number, a.measure6_number, a.measure18_number, a.measure19_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 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
, NULL
, A.MGB_LEVEL_VALUE
, NULL
, A.TIME_LEVEL_VALUE
, NULL
, NULL
, NULL
, NULL
, NULL
, A.MEASURE1_NUMBER
, A.MEASURE2_NUMBER
, A.MEASURE3_NUMBER
, A.MEASURE4_NUMBER
, A.MEASURE5_NUMBER
, A.MEASURE6_NUMBER
, A.MEASURE18_NUMBER
, A.MEASURE19_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
FROM QPR_MEASURE_DATA A
WHERE A.MEASURE_TYPE_CODE = 'SALESDATA'