APPS.AMS_DCF_TITLE dependencies on BIM_R_CAMP_ACT_BIN_MV

Line 522: select to_char(current_count_value,'999,999,999,999') into xCount from bim_r_camp_act_bin_mv a

518: and language = userenv('LANG');
519: vPeriod := jtfb_dcf.get_parameter_value(p_parameters, 'P_AGGREGATE_BY');
520: --vReportName := jtfb_dcf.get_parameter_value(p_parameters, 'P_REP_NAME');
521: if (vPeriod = 'INCREMENT') then
522: select to_char(current_count_value,'999,999,999,999') into xCount from bim_r_camp_act_bin_mv a
523: where a.aggregate_by = 'INCREMENT'
524: and a.year is not null
525: and a.qtr is not null
526: and a.month is not null

Line 529: select /*+ index_desc(A, BIM_R_CAMP_ACT_BIN_MV_N4) */

525: and a.qtr is not null
526: and a.month is not null
527: AND a.display_type is not null and rownum < 2;
528: else
529: select /*+ index_desc(A, BIM_R_CAMP_ACT_BIN_MV_N4) */
530: TO_CHAR(A.current_count_value,'999,999,999,999') into xCount
531: from BIM_R_CAMP_ACT_BIN_MV A
532: where A.AGGREGATE_BY = 'MONTH' AND A.YEAR IS NOT NULL
533: AND A.QTR IS NOT NULL AND A.MONTH IS NOT NULL

Line 531: from BIM_R_CAMP_ACT_BIN_MV A

527: AND a.display_type is not null and rownum < 2;
528: else
529: select /*+ index_desc(A, BIM_R_CAMP_ACT_BIN_MV_N4) */
530: TO_CHAR(A.current_count_value,'999,999,999,999') into xCount
531: from BIM_R_CAMP_ACT_BIN_MV A
532: where A.AGGREGATE_BY = 'MONTH' AND A.YEAR IS NOT NULL
533: AND A.QTR IS NOT NULL AND A.MONTH IS NOT NULL
534: AND A.DISPLAY_TYPE IS NOT NULL
535: and rownum <2;

Line 537: -- from (select current_count_value cv from bim_r_camp_act_bin_mv a

533: AND A.QTR IS NOT NULL AND A.MONTH IS NOT NULL
534: AND A.DISPLAY_TYPE IS NOT NULL
535: and rownum <2;
536: --select to_char(a.cv,'999,999,999,999') into xCount
537: -- from (select current_count_value cv from bim_r_camp_act_bin_mv a
538: -- where a.aggregate_by = 'MONTH'
539: -- and a.year is not null
540: -- and a.qtr is not null
541: -- and a.month is not null