DBA Data[Home] [Help]

APPS.QPR_DEAL_PVT dependencies on QPR_HIERARCHIES_V

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

123: select a.level_id level_id, a.operator operator,
124: a.scope_value scope_value, b.level_ppa_code level_ppa_code,
125: b.level_seq_num level_seq_no, c.hierarchy_ppa_code hierarchy_code,
126: c.dim_code dim_code
127: from qpr_scopes a, qpr_hier_levels b, qpr_hierarchies_v c
128: where b.price_plan_id= qpr_sr_util.g_datamart_tmpl_id
129: and b.hierarchy_level_id=a.level_id
130: and b.hierarchy_id = c.hierarchy_id
131: and a.scope_id= p_scope_id