DBA Data[Home] [Help]

APPS.HRI_OLTP_PMV_WMV_TRN_SUMMRY dependencies on HRI_MTDT_DIM_LVL

Line 379: ' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

375: ,:HRI_COMP_TERM_VOL comp_total_trn_vol
376: ,:HRI_COMP_TERM_INVOL comp_total_trn_inv
377: ,:HRI_COMP_TERM_VOL + :HRI_COMP_TERM_INVOL comp_total_trn_tot
378: FROM
379: ' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
380: (l_parameter_rec.view_by).viewby_table || ' vby' || g_rtn
381: || ',( ' || l_wrkfc_fact_sql || ' ) wmv' || g_rtn
382: || ',( ' || l_wcnt_chg_fact_sql || ' ) trn' || g_rtn
383: || 'WHERE wmv.vby_id = trn.vby_id (+)