VIEW: APPS.QPR_POLICY_MEAS_V

Source

View Text - Preformatted

SELECT a.instance_id, a.measure_type_code, a.ord_level_value, a.time_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, b.vlb_level_value, b.dsb_level_value, a.usr1_level_value, a.usr2_level_value, a.usr3_level_value, a.usr4_level_value, a.usr5_level_value, a.measure2_number, a.measure3_number, a.measure4_number, a.measure7_number, a.measure8_number, a.measure9_number, a.measure10_number, a.measure11_number, a.measure12_number, a.measure5_number, a.measure6_number, a.measure13_number, a.measure1_number FROM qpr_measure_data a, qpr_measure_data b WHERE b.measure_type_code = 'SALESDATA' and a.ord_level_value = b.ord_level_value and a.instance_id = b.instance_id and a.measure_type_code in ( 'QPR_GSA_POLICY_MEASURES', 'QPR_CORPORATE_POLICY_MEASURES', 'QPR_REGIONAL_POLICY_MEASURES', 'QPR_TARGET_POLICY_MEASURES', 'QPR_FIELD_USER_POLICY_MEASURES', 'QPR_CEILING_POLICY_MEASURES')

View Text - HTML Formatted

SELECT A.INSTANCE_ID
, A.MEASURE_TYPE_CODE
, A.ORD_LEVEL_VALUE
, A.TIME_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
, B.VLB_LEVEL_VALUE
, B.DSB_LEVEL_VALUE
, A.USR1_LEVEL_VALUE
, A.USR2_LEVEL_VALUE
, A.USR3_LEVEL_VALUE
, A.USR4_LEVEL_VALUE
, A.USR5_LEVEL_VALUE
, A.MEASURE2_NUMBER
, A.MEASURE3_NUMBER
, A.MEASURE4_NUMBER
, A.MEASURE7_NUMBER
, A.MEASURE8_NUMBER
, A.MEASURE9_NUMBER
, A.MEASURE10_NUMBER
, A.MEASURE11_NUMBER
, A.MEASURE12_NUMBER
, A.MEASURE5_NUMBER
, A.MEASURE6_NUMBER
, A.MEASURE13_NUMBER
, A.MEASURE1_NUMBER
FROM QPR_MEASURE_DATA A
, QPR_MEASURE_DATA B
WHERE B.MEASURE_TYPE_CODE = 'SALESDATA'
AND A.ORD_LEVEL_VALUE = B.ORD_LEVEL_VALUE
AND A.INSTANCE_ID = B.INSTANCE_ID
AND A.MEASURE_TYPE_CODE IN ( 'QPR_GSA_POLICY_MEASURES'
, 'QPR_CORPORATE_POLICY_MEASURES'
, 'QPR_REGIONAL_POLICY_MEASURES'
, 'QPR_TARGET_POLICY_MEASURES'
, 'QPR_FIELD_USER_POLICY_MEASURES'
, 'QPR_CEILING_POLICY_MEASURES')