VIEW: APPS.QPR_VLB_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, a.vlb_level_value, null, 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.measure9_number, a.measure10_number, a.measure11_number, a.measure12_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, b.rev_at_pol_limit, c.rev_at_pol_limit, d.rev_at_pol_limit, e.rev_at_pol_limit, f.rev_at_pol_limit, g.rev_at_pol_limit FROM qpr_measure_data a, qpr_policy_meas_v b, qpr_policy_meas_v c, qpr_policy_meas_v d, qpr_policy_meas_v e, qpr_policy_meas_v f, qpr_policy_meas_v g WHERE a.measure_type_code = 'SALESDATA' and b.policy_type(+) = 'QPR_CEILING_POLICY_MEASURES' and c.policy_type(+) = 'QPR_FIELD_USER_POLICY_MEASURES' and d.policy_type(+) = 'QPR_TARGET_POLICY_MEASURES' and e.policy_type(+) = 'QPR_REGIONAL_POLICY_MEASURES' and f.policy_type(+) = 'QPR_CORPORATE_POLICY_MEASURES' and g.policy_type(+) = 'QPR_GSA_POLICY_MEASURES' and a.instance_id = b.instance_id(+) and a.ord_level_value = b.ord_level_value(+) and a.instance_id = c.instance_id(+) and a.ord_level_value = c.ord_level_value(+) and a.instance_id = d.instance_id(+) and a.ord_level_value = d.ord_level_value(+) and a.instance_id = e.instance_id(+) and a.ord_level_value = e.ord_level_value(+) and a.instance_id = f.instance_id(+) and a.ord_level_value = f.ord_level_value(+) and a.instance_id = g.instance_id(+) and a.ord_level_value = g.ord_level_value(+)

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
, A.VLB_LEVEL_VALUE
, NULL
, 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.MEASURE9_NUMBER
, A.MEASURE10_NUMBER
, A.MEASURE11_NUMBER
, A.MEASURE12_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
, B.REV_AT_POL_LIMIT
, C.REV_AT_POL_LIMIT
, D.REV_AT_POL_LIMIT
, E.REV_AT_POL_LIMIT
, F.REV_AT_POL_LIMIT
, G.REV_AT_POL_LIMIT
FROM QPR_MEASURE_DATA A
, QPR_POLICY_MEAS_V B
, QPR_POLICY_MEAS_V C
, QPR_POLICY_MEAS_V D
, QPR_POLICY_MEAS_V E
, QPR_POLICY_MEAS_V F
, QPR_POLICY_MEAS_V G
WHERE A.MEASURE_TYPE_CODE = 'SALESDATA'
AND B.POLICY_TYPE(+) = 'QPR_CEILING_POLICY_MEASURES'
AND C.POLICY_TYPE(+) = 'QPR_FIELD_USER_POLICY_MEASURES'
AND D.POLICY_TYPE(+) = 'QPR_TARGET_POLICY_MEASURES'
AND E.POLICY_TYPE(+) = 'QPR_REGIONAL_POLICY_MEASURES'
AND F.POLICY_TYPE(+) = 'QPR_CORPORATE_POLICY_MEASURES'
AND G.POLICY_TYPE(+) = 'QPR_GSA_POLICY_MEASURES'
AND A.INSTANCE_ID = B.INSTANCE_ID(+)
AND A.ORD_LEVEL_VALUE = B.ORD_LEVEL_VALUE(+)
AND A.INSTANCE_ID = C.INSTANCE_ID(+)
AND A.ORD_LEVEL_VALUE = C.ORD_LEVEL_VALUE(+)
AND A.INSTANCE_ID = D.INSTANCE_ID(+)
AND A.ORD_LEVEL_VALUE = D.ORD_LEVEL_VALUE(+)
AND A.INSTANCE_ID = E.INSTANCE_ID(+)
AND A.ORD_LEVEL_VALUE = E.ORD_LEVEL_VALUE(+)
AND A.INSTANCE_ID = F.INSTANCE_ID(+)
AND A.ORD_LEVEL_VALUE = F.ORD_LEVEL_VALUE(+)
AND A.INSTANCE_ID = G.INSTANCE_ID(+)
AND A.ORD_LEVEL_VALUE = G.ORD_LEVEL_VALUE(+)