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.HRI_BPL_TREND_TRM_SQL dependencies on HRI_OLTP_PMV_QUERY_TREND

Line 148: p_measure_columns OUT NOCOPY hri_oltp_pmv_query_trend.trend_measure_cols_type)

144: p_include_sep IN VARCHAR2,
145: p_include_sep_inv IN VARCHAR2,
146: p_include_sep_vol IN VARCHAR2,
147: p_select_sql OUT NOCOPY VARCHAR2,
148: p_measure_columns OUT NOCOPY hri_oltp_pmv_query_trend.trend_measure_cols_type)
149: IS
150: --
151: -- template for bucket column
152: --

Line 320: p_trend_sql_params IN hri_oltp_pmv_query_trend.trend_sql_params_type,

316: --
317: PROCEDURE get_sql
318: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
319: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
320: p_trend_sql_params IN hri_oltp_pmv_query_trend.trend_sql_params_type,
321: p_fact_sql OUT NOCOPY VARCHAR2,
322: p_measure_columns OUT NOCOPY hri_oltp_pmv_query_trend.trend_measure_cols_type)
323: IS
324: --

Line 322: p_measure_columns OUT NOCOPY hri_oltp_pmv_query_trend.trend_measure_cols_type)

318: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
319: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
320: p_trend_sql_params IN hri_oltp_pmv_query_trend.trend_sql_params_type,
321: p_fact_sql OUT NOCOPY VARCHAR2,
322: p_measure_columns OUT NOCOPY hri_oltp_pmv_query_trend.trend_measure_cols_type)
323: IS
324: --
325: l_trend_periods_tbl VARCHAR2(32767);
326: l_select_sql VARCHAR2(32767);