DBA Data[Home] [Help]

APPS.HRI_OLTP_PMV_WRKFC_TRN_SUMMARY dependencies on HRI_MTDT_DIM_LVL

Line 434: ' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

430: ,:HRI_COMP_TRN_VOL comp_total_trn_vol
431: ,:HRI_COMP_TRN_INVOL comp_total_trn_inv
432: ,:HRI_COMP_TRN_VOL + :HRI_COMP_TRN_INVOL comp_total_trn_tot
433: FROM
434: ' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
435: (l_parameter_rec.view_by).viewby_table || ' vby,
436: (' || l_wcnt_chg_fact_sql || ') trn,
437: (' || l_wrkfc_fact_sql || ') wmv
438: WHERE wmv.vby_id = trn.vby_id (+)