DBA Data[Home] [Help]

APPS.QPR_TRANSFORMATION dependencies on QPR_TRANSF_RULES_B

Line 118: from qpr_measure_data csd, qpr_transf_rules_b qtr

114: qtr.LEVEL_VALUE_TO,
115: qtr.LIMIT_DIM_CODE,
116: qtr.LIMIT_DIM_LEVEL,
117: qtr.LIMIT_DIM_LEVEL_VALUE
118: from qpr_measure_data csd, qpr_transf_rules_b qtr
119: where csd.measure_type_code = p_from_dim_meas_code and
120: csd.instance_id=p_instance_id and
121: csd.time_level_value between p_from_date and p_to_date
122: and qtr.transf_header_id = p_transf_header_id and

Line 450: ' from qpr_dimension_values a, qpr_transf_rules_b b ';

446: transf_header_rec.TRANSF_HEADER_ID);
447:
448: l_first:=0;
449: sql1_text := ' select a.dim_value_id as dim_value_id ' ||
450: ' from qpr_dimension_values a, qpr_transf_rules_b b ';
451: sql1_text := sql1_text|| ' where a.dim_code = '|| '''' ||
452: replace(transf_header_rec.from_dim_meas_code, '''', '''''') || '''';
453: sql1_text := sql1_text|| ' and a.hierarchy_code = '|| '''' ||
454: replace(transf_header_rec.from_dim_hier_code, '''', '''''') || '''';