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.BEN_PLAN_DESIGN_TXNS_API dependencies on PQH_TABLE_ROUTE_VL

Line 2468: from pqh_table_route_vl trt

2464:
2465: cursor c_table_route is
2466: select table_alias
2467: ,display_name
2468: from pqh_table_route_vl trt
2469: where trt.table_alias in
2470: ('PGM', 'PLN', 'OPT', 'PTP', 'EAT'
2471: ,'BNB', 'CLF', 'HWF', 'AGF', 'LSF'
2472: ,'PFF', 'CLA', 'REG', 'BNR', 'BPP'

Line 2528: l_pgm_label pqh_table_route_vl.display_name%type;

2524: l_reused_count number;
2525: l_not_copied_count number;
2526: l_items_to_ignore_count number;
2527:
2528: l_pgm_label pqh_table_route_vl.display_name%type;
2529: l_pln_label pqh_table_route_vl.display_name%type;
2530: l_opt_label pqh_table_route_vl.display_name%type;
2531: l_ptp_label pqh_table_route_vl.display_name%type;
2532: l_eat_label pqh_table_route_vl.display_name%type;

Line 2529: l_pln_label pqh_table_route_vl.display_name%type;

2525: l_not_copied_count number;
2526: l_items_to_ignore_count number;
2527:
2528: l_pgm_label pqh_table_route_vl.display_name%type;
2529: l_pln_label pqh_table_route_vl.display_name%type;
2530: l_opt_label pqh_table_route_vl.display_name%type;
2531: l_ptp_label pqh_table_route_vl.display_name%type;
2532: l_eat_label pqh_table_route_vl.display_name%type;
2533: l_bnb_label pqh_table_route_vl.display_name%type;

Line 2530: l_opt_label pqh_table_route_vl.display_name%type;

2526: l_items_to_ignore_count number;
2527:
2528: l_pgm_label pqh_table_route_vl.display_name%type;
2529: l_pln_label pqh_table_route_vl.display_name%type;
2530: l_opt_label pqh_table_route_vl.display_name%type;
2531: l_ptp_label pqh_table_route_vl.display_name%type;
2532: l_eat_label pqh_table_route_vl.display_name%type;
2533: l_bnb_label pqh_table_route_vl.display_name%type;
2534: l_clf_label pqh_table_route_vl.display_name%type;

Line 2531: l_ptp_label pqh_table_route_vl.display_name%type;

2527:
2528: l_pgm_label pqh_table_route_vl.display_name%type;
2529: l_pln_label pqh_table_route_vl.display_name%type;
2530: l_opt_label pqh_table_route_vl.display_name%type;
2531: l_ptp_label pqh_table_route_vl.display_name%type;
2532: l_eat_label pqh_table_route_vl.display_name%type;
2533: l_bnb_label pqh_table_route_vl.display_name%type;
2534: l_clf_label pqh_table_route_vl.display_name%type;
2535: l_hwf_label pqh_table_route_vl.display_name%type;

Line 2532: l_eat_label pqh_table_route_vl.display_name%type;

2528: l_pgm_label pqh_table_route_vl.display_name%type;
2529: l_pln_label pqh_table_route_vl.display_name%type;
2530: l_opt_label pqh_table_route_vl.display_name%type;
2531: l_ptp_label pqh_table_route_vl.display_name%type;
2532: l_eat_label pqh_table_route_vl.display_name%type;
2533: l_bnb_label pqh_table_route_vl.display_name%type;
2534: l_clf_label pqh_table_route_vl.display_name%type;
2535: l_hwf_label pqh_table_route_vl.display_name%type;
2536: l_agf_label pqh_table_route_vl.display_name%type;

Line 2533: l_bnb_label pqh_table_route_vl.display_name%type;

2529: l_pln_label pqh_table_route_vl.display_name%type;
2530: l_opt_label pqh_table_route_vl.display_name%type;
2531: l_ptp_label pqh_table_route_vl.display_name%type;
2532: l_eat_label pqh_table_route_vl.display_name%type;
2533: l_bnb_label pqh_table_route_vl.display_name%type;
2534: l_clf_label pqh_table_route_vl.display_name%type;
2535: l_hwf_label pqh_table_route_vl.display_name%type;
2536: l_agf_label pqh_table_route_vl.display_name%type;
2537: l_lsf_label pqh_table_route_vl.display_name%type;

Line 2534: l_clf_label pqh_table_route_vl.display_name%type;

2530: l_opt_label pqh_table_route_vl.display_name%type;
2531: l_ptp_label pqh_table_route_vl.display_name%type;
2532: l_eat_label pqh_table_route_vl.display_name%type;
2533: l_bnb_label pqh_table_route_vl.display_name%type;
2534: l_clf_label pqh_table_route_vl.display_name%type;
2535: l_hwf_label pqh_table_route_vl.display_name%type;
2536: l_agf_label pqh_table_route_vl.display_name%type;
2537: l_lsf_label pqh_table_route_vl.display_name%type;
2538: l_pff_label pqh_table_route_vl.display_name%type;

Line 2535: l_hwf_label pqh_table_route_vl.display_name%type;

2531: l_ptp_label pqh_table_route_vl.display_name%type;
2532: l_eat_label pqh_table_route_vl.display_name%type;
2533: l_bnb_label pqh_table_route_vl.display_name%type;
2534: l_clf_label pqh_table_route_vl.display_name%type;
2535: l_hwf_label pqh_table_route_vl.display_name%type;
2536: l_agf_label pqh_table_route_vl.display_name%type;
2537: l_lsf_label pqh_table_route_vl.display_name%type;
2538: l_pff_label pqh_table_route_vl.display_name%type;
2539: l_cla_label pqh_table_route_vl.display_name%type;

Line 2536: l_agf_label pqh_table_route_vl.display_name%type;

2532: l_eat_label pqh_table_route_vl.display_name%type;
2533: l_bnb_label pqh_table_route_vl.display_name%type;
2534: l_clf_label pqh_table_route_vl.display_name%type;
2535: l_hwf_label pqh_table_route_vl.display_name%type;
2536: l_agf_label pqh_table_route_vl.display_name%type;
2537: l_lsf_label pqh_table_route_vl.display_name%type;
2538: l_pff_label pqh_table_route_vl.display_name%type;
2539: l_cla_label pqh_table_route_vl.display_name%type;
2540: l_reg_label pqh_table_route_vl.display_name%type;

Line 2537: l_lsf_label pqh_table_route_vl.display_name%type;

2533: l_bnb_label pqh_table_route_vl.display_name%type;
2534: l_clf_label pqh_table_route_vl.display_name%type;
2535: l_hwf_label pqh_table_route_vl.display_name%type;
2536: l_agf_label pqh_table_route_vl.display_name%type;
2537: l_lsf_label pqh_table_route_vl.display_name%type;
2538: l_pff_label pqh_table_route_vl.display_name%type;
2539: l_cla_label pqh_table_route_vl.display_name%type;
2540: l_reg_label pqh_table_route_vl.display_name%type;
2541: l_bnr_label pqh_table_route_vl.display_name%type;

Line 2538: l_pff_label pqh_table_route_vl.display_name%type;

2534: l_clf_label pqh_table_route_vl.display_name%type;
2535: l_hwf_label pqh_table_route_vl.display_name%type;
2536: l_agf_label pqh_table_route_vl.display_name%type;
2537: l_lsf_label pqh_table_route_vl.display_name%type;
2538: l_pff_label pqh_table_route_vl.display_name%type;
2539: l_cla_label pqh_table_route_vl.display_name%type;
2540: l_reg_label pqh_table_route_vl.display_name%type;
2541: l_bnr_label pqh_table_route_vl.display_name%type;
2542: l_bpp_label pqh_table_route_vl.display_name%type;

Line 2539: l_cla_label pqh_table_route_vl.display_name%type;

2535: l_hwf_label pqh_table_route_vl.display_name%type;
2536: l_agf_label pqh_table_route_vl.display_name%type;
2537: l_lsf_label pqh_table_route_vl.display_name%type;
2538: l_pff_label pqh_table_route_vl.display_name%type;
2539: l_cla_label pqh_table_route_vl.display_name%type;
2540: l_reg_label pqh_table_route_vl.display_name%type;
2541: l_bnr_label pqh_table_route_vl.display_name%type;
2542: l_bpp_label pqh_table_route_vl.display_name%type;
2543: l_ler_label pqh_table_route_vl.display_name%type;

Line 2540: l_reg_label pqh_table_route_vl.display_name%type;

2536: l_agf_label pqh_table_route_vl.display_name%type;
2537: l_lsf_label pqh_table_route_vl.display_name%type;
2538: l_pff_label pqh_table_route_vl.display_name%type;
2539: l_cla_label pqh_table_route_vl.display_name%type;
2540: l_reg_label pqh_table_route_vl.display_name%type;
2541: l_bnr_label pqh_table_route_vl.display_name%type;
2542: l_bpp_label pqh_table_route_vl.display_name%type;
2543: l_ler_label pqh_table_route_vl.display_name%type;
2544: l_psl_label pqh_table_route_vl.display_name%type;

Line 2541: l_bnr_label pqh_table_route_vl.display_name%type;

2537: l_lsf_label pqh_table_route_vl.display_name%type;
2538: l_pff_label pqh_table_route_vl.display_name%type;
2539: l_cla_label pqh_table_route_vl.display_name%type;
2540: l_reg_label pqh_table_route_vl.display_name%type;
2541: l_bnr_label pqh_table_route_vl.display_name%type;
2542: l_bpp_label pqh_table_route_vl.display_name%type;
2543: l_ler_label pqh_table_route_vl.display_name%type;
2544: l_psl_label pqh_table_route_vl.display_name%type;
2545: l_elp_label pqh_table_route_vl.display_name%type;

Line 2542: l_bpp_label pqh_table_route_vl.display_name%type;

2538: l_pff_label pqh_table_route_vl.display_name%type;
2539: l_cla_label pqh_table_route_vl.display_name%type;
2540: l_reg_label pqh_table_route_vl.display_name%type;
2541: l_bnr_label pqh_table_route_vl.display_name%type;
2542: l_bpp_label pqh_table_route_vl.display_name%type;
2543: l_ler_label pqh_table_route_vl.display_name%type;
2544: l_psl_label pqh_table_route_vl.display_name%type;
2545: l_elp_label pqh_table_route_vl.display_name%type;
2546: l_dce_label pqh_table_route_vl.display_name%type;

Line 2543: l_ler_label pqh_table_route_vl.display_name%type;

2539: l_cla_label pqh_table_route_vl.display_name%type;
2540: l_reg_label pqh_table_route_vl.display_name%type;
2541: l_bnr_label pqh_table_route_vl.display_name%type;
2542: l_bpp_label pqh_table_route_vl.display_name%type;
2543: l_ler_label pqh_table_route_vl.display_name%type;
2544: l_psl_label pqh_table_route_vl.display_name%type;
2545: l_elp_label pqh_table_route_vl.display_name%type;
2546: l_dce_label pqh_table_route_vl.display_name%type;
2547: l_gos_label pqh_table_route_vl.display_name%type;

Line 2544: l_psl_label pqh_table_route_vl.display_name%type;

2540: l_reg_label pqh_table_route_vl.display_name%type;
2541: l_bnr_label pqh_table_route_vl.display_name%type;
2542: l_bpp_label pqh_table_route_vl.display_name%type;
2543: l_ler_label pqh_table_route_vl.display_name%type;
2544: l_psl_label pqh_table_route_vl.display_name%type;
2545: l_elp_label pqh_table_route_vl.display_name%type;
2546: l_dce_label pqh_table_route_vl.display_name%type;
2547: l_gos_label pqh_table_route_vl.display_name%type;
2548: l_bng_label pqh_table_route_vl.display_name%type;

Line 2545: l_elp_label pqh_table_route_vl.display_name%type;

2541: l_bnr_label pqh_table_route_vl.display_name%type;
2542: l_bpp_label pqh_table_route_vl.display_name%type;
2543: l_ler_label pqh_table_route_vl.display_name%type;
2544: l_psl_label pqh_table_route_vl.display_name%type;
2545: l_elp_label pqh_table_route_vl.display_name%type;
2546: l_dce_label pqh_table_route_vl.display_name%type;
2547: l_gos_label pqh_table_route_vl.display_name%type;
2548: l_bng_label pqh_table_route_vl.display_name%type;
2549: l_pdl_label pqh_table_route_vl.display_name%type;

Line 2546: l_dce_label pqh_table_route_vl.display_name%type;

2542: l_bpp_label pqh_table_route_vl.display_name%type;
2543: l_ler_label pqh_table_route_vl.display_name%type;
2544: l_psl_label pqh_table_route_vl.display_name%type;
2545: l_elp_label pqh_table_route_vl.display_name%type;
2546: l_dce_label pqh_table_route_vl.display_name%type;
2547: l_gos_label pqh_table_route_vl.display_name%type;
2548: l_bng_label pqh_table_route_vl.display_name%type;
2549: l_pdl_label pqh_table_route_vl.display_name%type;
2550: l_sva_label pqh_table_route_vl.display_name%type;

Line 2547: l_gos_label pqh_table_route_vl.display_name%type;

2543: l_ler_label pqh_table_route_vl.display_name%type;
2544: l_psl_label pqh_table_route_vl.display_name%type;
2545: l_elp_label pqh_table_route_vl.display_name%type;
2546: l_dce_label pqh_table_route_vl.display_name%type;
2547: l_gos_label pqh_table_route_vl.display_name%type;
2548: l_bng_label pqh_table_route_vl.display_name%type;
2549: l_pdl_label pqh_table_route_vl.display_name%type;
2550: l_sva_label pqh_table_route_vl.display_name%type;
2551: l_cpl_label pqh_table_route_vl.display_name%type;

Line 2548: l_bng_label pqh_table_route_vl.display_name%type;

2544: l_psl_label pqh_table_route_vl.display_name%type;
2545: l_elp_label pqh_table_route_vl.display_name%type;
2546: l_dce_label pqh_table_route_vl.display_name%type;
2547: l_gos_label pqh_table_route_vl.display_name%type;
2548: l_bng_label pqh_table_route_vl.display_name%type;
2549: l_pdl_label pqh_table_route_vl.display_name%type;
2550: l_sva_label pqh_table_route_vl.display_name%type;
2551: l_cpl_label pqh_table_route_vl.display_name%type;
2552: l_cbp_label pqh_table_route_vl.display_name%type;

Line 2549: l_pdl_label pqh_table_route_vl.display_name%type;

2545: l_elp_label pqh_table_route_vl.display_name%type;
2546: l_dce_label pqh_table_route_vl.display_name%type;
2547: l_gos_label pqh_table_route_vl.display_name%type;
2548: l_bng_label pqh_table_route_vl.display_name%type;
2549: l_pdl_label pqh_table_route_vl.display_name%type;
2550: l_sva_label pqh_table_route_vl.display_name%type;
2551: l_cpl_label pqh_table_route_vl.display_name%type;
2552: l_cbp_label pqh_table_route_vl.display_name%type;
2553: l_cpt_label pqh_table_route_vl.display_name%type;

Line 2550: l_sva_label pqh_table_route_vl.display_name%type;

2546: l_dce_label pqh_table_route_vl.display_name%type;
2547: l_gos_label pqh_table_route_vl.display_name%type;
2548: l_bng_label pqh_table_route_vl.display_name%type;
2549: l_pdl_label pqh_table_route_vl.display_name%type;
2550: l_sva_label pqh_table_route_vl.display_name%type;
2551: l_cpl_label pqh_table_route_vl.display_name%type;
2552: l_cbp_label pqh_table_route_vl.display_name%type;
2553: l_cpt_label pqh_table_route_vl.display_name%type;
2554: l_fff_label pqh_table_route_vl.display_name%type;

Line 2551: l_cpl_label pqh_table_route_vl.display_name%type;

2547: l_gos_label pqh_table_route_vl.display_name%type;
2548: l_bng_label pqh_table_route_vl.display_name%type;
2549: l_pdl_label pqh_table_route_vl.display_name%type;
2550: l_sva_label pqh_table_route_vl.display_name%type;
2551: l_cpl_label pqh_table_route_vl.display_name%type;
2552: l_cbp_label pqh_table_route_vl.display_name%type;
2553: l_cpt_label pqh_table_route_vl.display_name%type;
2554: l_fff_label pqh_table_route_vl.display_name%type;
2555: l_abr_label pqh_table_route_vl.display_name%type;

Line 2552: l_cbp_label pqh_table_route_vl.display_name%type;

2548: l_bng_label pqh_table_route_vl.display_name%type;
2549: l_pdl_label pqh_table_route_vl.display_name%type;
2550: l_sva_label pqh_table_route_vl.display_name%type;
2551: l_cpl_label pqh_table_route_vl.display_name%type;
2552: l_cbp_label pqh_table_route_vl.display_name%type;
2553: l_cpt_label pqh_table_route_vl.display_name%type;
2554: l_fff_label pqh_table_route_vl.display_name%type;
2555: l_abr_label pqh_table_route_vl.display_name%type;
2556: l_apr_label pqh_table_route_vl.display_name%type;

Line 2553: l_cpt_label pqh_table_route_vl.display_name%type;

2549: l_pdl_label pqh_table_route_vl.display_name%type;
2550: l_sva_label pqh_table_route_vl.display_name%type;
2551: l_cpl_label pqh_table_route_vl.display_name%type;
2552: l_cbp_label pqh_table_route_vl.display_name%type;
2553: l_cpt_label pqh_table_route_vl.display_name%type;
2554: l_fff_label pqh_table_route_vl.display_name%type;
2555: l_abr_label pqh_table_route_vl.display_name%type;
2556: l_apr_label pqh_table_route_vl.display_name%type;
2557: l_vpf_label pqh_table_route_vl.display_name%type;

Line 2554: l_fff_label pqh_table_route_vl.display_name%type;

2550: l_sva_label pqh_table_route_vl.display_name%type;
2551: l_cpl_label pqh_table_route_vl.display_name%type;
2552: l_cbp_label pqh_table_route_vl.display_name%type;
2553: l_cpt_label pqh_table_route_vl.display_name%type;
2554: l_fff_label pqh_table_route_vl.display_name%type;
2555: l_abr_label pqh_table_route_vl.display_name%type;
2556: l_apr_label pqh_table_route_vl.display_name%type;
2557: l_vpf_label pqh_table_route_vl.display_name%type;
2558: l_ccm_label pqh_table_route_vl.display_name%type;

Line 2555: l_abr_label pqh_table_route_vl.display_name%type;

2551: l_cpl_label pqh_table_route_vl.display_name%type;
2552: l_cbp_label pqh_table_route_vl.display_name%type;
2553: l_cpt_label pqh_table_route_vl.display_name%type;
2554: l_fff_label pqh_table_route_vl.display_name%type;
2555: l_abr_label pqh_table_route_vl.display_name%type;
2556: l_apr_label pqh_table_route_vl.display_name%type;
2557: l_vpf_label pqh_table_route_vl.display_name%type;
2558: l_ccm_label pqh_table_route_vl.display_name%type;
2559: l_acp_label pqh_table_route_vl.display_name%type;

Line 2556: l_apr_label pqh_table_route_vl.display_name%type;

2552: l_cbp_label pqh_table_route_vl.display_name%type;
2553: l_cpt_label pqh_table_route_vl.display_name%type;
2554: l_fff_label pqh_table_route_vl.display_name%type;
2555: l_abr_label pqh_table_route_vl.display_name%type;
2556: l_apr_label pqh_table_route_vl.display_name%type;
2557: l_vpf_label pqh_table_route_vl.display_name%type;
2558: l_ccm_label pqh_table_route_vl.display_name%type;
2559: l_acp_label pqh_table_route_vl.display_name%type;
2560: l_egl_label pqh_table_route_vl.display_name%type; /* Bug 4169120 Rate By Criteria */

Line 2557: l_vpf_label pqh_table_route_vl.display_name%type;

2553: l_cpt_label pqh_table_route_vl.display_name%type;
2554: l_fff_label pqh_table_route_vl.display_name%type;
2555: l_abr_label pqh_table_route_vl.display_name%type;
2556: l_apr_label pqh_table_route_vl.display_name%type;
2557: l_vpf_label pqh_table_route_vl.display_name%type;
2558: l_ccm_label pqh_table_route_vl.display_name%type;
2559: l_acp_label pqh_table_route_vl.display_name%type;
2560: l_egl_label pqh_table_route_vl.display_name%type; /* Bug 4169120 Rate By Criteria */
2561:

Line 2558: l_ccm_label pqh_table_route_vl.display_name%type;

2554: l_fff_label pqh_table_route_vl.display_name%type;
2555: l_abr_label pqh_table_route_vl.display_name%type;
2556: l_apr_label pqh_table_route_vl.display_name%type;
2557: l_vpf_label pqh_table_route_vl.display_name%type;
2558: l_ccm_label pqh_table_route_vl.display_name%type;
2559: l_acp_label pqh_table_route_vl.display_name%type;
2560: l_egl_label pqh_table_route_vl.display_name%type; /* Bug 4169120 Rate By Criteria */
2561:
2562: l_selected_for_copy_lbl fnd_new_messages.message_text%type;

Line 2559: l_acp_label pqh_table_route_vl.display_name%type;

2555: l_abr_label pqh_table_route_vl.display_name%type;
2556: l_apr_label pqh_table_route_vl.display_name%type;
2557: l_vpf_label pqh_table_route_vl.display_name%type;
2558: l_ccm_label pqh_table_route_vl.display_name%type;
2559: l_acp_label pqh_table_route_vl.display_name%type;
2560: l_egl_label pqh_table_route_vl.display_name%type; /* Bug 4169120 Rate By Criteria */
2561:
2562: l_selected_for_copy_lbl fnd_new_messages.message_text%type;
2563: l_created_objects_lbl fnd_new_messages.message_text%type;

Line 2560: l_egl_label pqh_table_route_vl.display_name%type; /* Bug 4169120 Rate By Criteria */

2556: l_apr_label pqh_table_route_vl.display_name%type;
2557: l_vpf_label pqh_table_route_vl.display_name%type;
2558: l_ccm_label pqh_table_route_vl.display_name%type;
2559: l_acp_label pqh_table_route_vl.display_name%type;
2560: l_egl_label pqh_table_route_vl.display_name%type; /* Bug 4169120 Rate By Criteria */
2561:
2562: l_selected_for_copy_lbl fnd_new_messages.message_text%type;
2563: l_created_objects_lbl fnd_new_messages.message_text%type;
2564: l_reused_objects_lbl fnd_new_messages.message_text%type;