DBA Data[Home] [Help]

APPS.HRI_OLTP_PMV_TRN_BCKT_GRAPH dependencies on HRI_MTDT_DIM_LVL

Line 177: ' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

173: 100 * (qry.curr_separation_hdc - qry.comp_separation_hdc) /
174: qry.comp_separation_hdc)
175: HRI_P_MEASURE1_MP
176: FROM
177: ' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
178: (l_parameter_rec.view_by).viewby_table || ' cl
179: ,(SELECT' || g_rtn ||
180: /* Bug 4068969 - added grp_id and corrected logic for vby_id and order_by */
181: ' DECODE(SIGN(:HRI_NO_SEGMENTS_TO_SHOW - rnk),

Line 309: ' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

305: ((qry.curr_separation_hdc - qry.comp_separation_hdc) /
306: qry.curr_separation_hdc) * 100)
307: HRI_P_MEASURE1_MP
308: FROM
309: ' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
310: (l_parameter_rec.view_by).viewby_table || ' cl
311: ,(SELECT' || g_rtn ||
312: /* Bug 4068969 - added grp_id and corrected logic for vby_id and order_by */
313: ' DECODE(SIGN(:HRI_NO_SEGMENTS_TO_SHOW - rnked_metrics.rnk),