DBA Data[Home] [Help]

APPS.HRI_OLTP_PMV_WMV_TRN_SUP_BCKT dependencies on HRI_MTDT_DIM_LVL

Line 374: ' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

370: ,:HRI_COMP_TERM_HDC_NA comp_total_term_hdc_na
371: ,:HRI_CURR_TERM_HDC curr_total_term_hdc
372: ,:HRI_COMP_TERM_HDC comp_total_term_hdc
373: FROM
374: ' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
375: (l_parameter_rec.view_by).viewby_table || ' cl
376: ,(' || l_wrkfc_fact_sql || ') wmv
377: ,(' || l_wcnt_chg_fact_sql || ') trn
378: WHERE wmv.vby_id = trn.vby_id (+)

Line 761: ' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

757: ,:HRI_TOT_TERM_HDC_B4 tot_curr_trn_bn4
758: ,:HRI_TOT_TERM_HDC_B5 tot_curr_trn_bn5
759: ,:HRI_TOT_TERM_HDC tot_curr_trn_tot
760: FROM
761: ' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
762: (l_parameter_rec.view_by).viewby_table || ' cl
763: ,(' || l_wrkfc_fact_sql || ') wmv
764: ,(' || l_wcnt_chg_fact_sql || ') trn
765: WHERE wmv.vby_id = trn.vby_id (+)