DBA Data[Home] [Help]

APPS.QPR_MAINTAIN_AW dependencies on QPR_SCOPES

Line 246: from qpr_scopes a, qpr_hier_levels b, qpr_hierarchies_v c

242: select a.level_id level_id, a.operator operator,
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'