DBA Data[Home] [Help]

APPS.HRI_OLTP_PMV_WMV_SUP_BCKT dependencies on HRI_MTDT_DIM_LVL

Line 372: ' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

368: ,NVL(SUM(wmv.comp_total_hdc_na) OVER (), 0) total_comp_hdc_na
369: ,NVL(SUM(wmv.comp_total_hdc_end) OVER (), 0) total_comp_hdc
370: ,NVL(wmv.direct_ind, 0) direct_ind
371: FROM
372: ' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
373: (l_parameter_rec.view_by).viewby_table || ' vby
374: ,(' || l_wrkfc_fact_sql || ') wmv
375: WHERE wmv.vby_id ' || l_dynsql_rec.wrkfc_outer_join || ' = vby.id' || g_rtn ||
376: l_dynsql_rec.viewby_condition ||

Line 593: ' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

589: ,SUM(wmv.comp_total_hdc_b5) OVER () total_comp_hdc_b5
590: ,SUM(wmv.comp_total_hdc_end) OVER () total_comp_hdc
591: ,NVL(wmv.direct_ind, 0) direct_ind
592: FROM
593: ' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
594: (l_parameter_rec.view_by).viewby_table || ' vby,
595: (' || l_wrkfc_fact_sql || ') wmv
596: WHERE wmv.vby_id ' || l_dynsql_rec.wrkfc_outer_join || ' = vby.id' || g_rtn ||
597: l_dynsql_rec.viewby_condition ||