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.

APPS.QPR_MAINTAIN_AW dependencies on QPR_SR_UTIL

Line 247: where b.price_plan_id= qpr_sr_util.g_datamart_tmpl_id

243: a.scope_value scope_value, b.level_ppa_code level_ppa_code,
244: b.level_seq_num level_seq_num, c.hierarchy_ppa_code hierarchy_ppa_code,
245: c.dim_code dim_code
246: from qpr_scopes a, qpr_hier_levels b, qpr_hierarchies_v c
247: where b.price_plan_id= qpr_sr_util.g_datamart_tmpl_id
248: and b.hierarchy_level_id=a.level_id
249: and b.hierarchy_id = c.hierarchy_id
250: and a.parent_entity_type = 'DATAMART'
251: and a.parent_id = p_price_plan_id;

Line 480: and c.price_plan_id = qpr_sr_util.g_datamart_tmpl_id

476: from qpr_cubes a, qpr_measures b, qpr_measures c
477: where a.cube_id=b.cube_id and
478: b.price_plan_id=p_plan_id
479: and b.measure_ppa_code = c.measure_ppa_code
480: and c.price_plan_id = qpr_sr_util.g_datamart_tmpl_id
481: and b.meas_type='INPUT'
482: order by a.cube_id, c.measure_id;
483:
484: cursor c_xml_load_log is