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.AMS_DCF_TITLE dependencies on BIM_R_FD_DIM_SUM_MV

Line 385: from bim_r_fd_dim_sum_mv where year||'-'||qtr = xRetString and rownum < 2;

381: select fnd_profile.VALUE('AMS_DEFAULT_CURR_CODE') into vCurrency from dual;
382: if (vDefPeriod is not NULL) then
383: select substr(vDefPeriod,0,INSTR(vDefPeriod,'-',10)-1) into xRetString from dual;
384: select year, qtr into xYear, xQtr
385: from bim_r_fd_dim_sum_mv where year||'-'||qtr = xRetString and rownum < 2;
386: xRetString := xQtr;
387: end if;
388:
389: if (vContext is not NULL) then

Line 392: from bim_r_fd_dim_sum_mv where year||'-'||qtr||'-'||month||'-'||display_type = vContext

388:
389: if (vContext is not NULL) then
390: if (vSource = 'AMS_BIN_MARKETING_BUDGETS') then
391: select year, qtr,month,display_type into xYear, xQtr, xMonth,xDisplayType
392: from bim_r_fd_dim_sum_mv where year||'-'||qtr||'-'||month||'-'||display_type = vContext
393: and rownum < 2;
394: if (xDisplayType <> 'Z') then
395: select to_char(start_date,fnd_profile.VALUE('ICX_DATE_FORMAT_MASK')) ||' ' ||vTo||' '||
396: to_char(end_date,fnd_profile.VALUE('ICX_DATE_FORMAT_MASK')) into xPeriod

Line 410: from bim_r_fd_dim_sum_mv where year||'-'||qtr||'-'||month||'-'||display_type = vContext

406: end if;
407: end if;
408: elsif (vSource = 'AMS_BIN_MARKET_ACTIV') then
409: select year, qtr,month,display_type into xYear, xQtr, xMonth,xDisplayType
410: from bim_r_fd_dim_sum_mv where year||'-'||qtr||'-'||month||'-'||display_type = vContext
411: and rownum < 2;
412: if (xDisplayType <> 'Z') then
413: select to_char(start_date,fnd_profile.VALUE('ICX_DATE_FORMAT_MASK')) ||' ' ||vTo||' '||
414: to_char(end_date,fnd_profile.VALUE('ICX_DATE_FORMAT_MASK')) into xPeriod

Line 624: from bim_r_fd_dim_sum_mv where year||'-'||qtr = xRetString and rownum < 2;

620: xRetString := 'x';
621: if (vDefPeriod is not NULL) then
622: select substr(vDefPeriod,0,INSTR(vDefPeriod,'-',10)-1) into xRetString from dual;
623: select year, qtr into xYear, xQtr
624: from bim_r_fd_dim_sum_mv where year||'-'||qtr = xRetString and rownum < 2;
625: xRetString := xQtr;
626: end if;
627:
628: if (vContext is not NULL) then

Line 631: from bim_r_fd_dim_sum_mv where year||'-'||qtr||'-'||month||'-'||display_type = vContext

627:
628: if (vContext is not NULL) then
629: if (vSource = 'AMS_BIN_MARKETING_BUDGETS') then
630: select year, qtr,month,display_type into xYear, xQtr, xMonth,xDisplayType
631: from bim_r_fd_dim_sum_mv where year||'-'||qtr||'-'||month||'-'||display_type = vContext
632: and rownum < 2;
633: if (xDisplayType <> 'Z') then
634: select to_char(start_date,fnd_profile.VALUE('ICX_DATE_FORMAT_MASK')) ||' ' ||vTo||' '||
635: to_char(end_date,fnd_profile.VALUE('ICX_DATE_FORMAT_MASK')) into xPeriod

Line 649: from bim_r_fd_dim_sum_mv where year||'-'||qtr||'-'||month||'-'||display_type = vContext

645: end if;
646: end if;
647: elsif (vSource = 'AMS_BIN_MARKET_ACTIV') then
648: select year, qtr,month,display_type into xYear, xQtr, xMonth,xDisplayType
649: from bim_r_fd_dim_sum_mv where year||'-'||qtr||'-'||month||'-'||display_type = vContext
650: and rownum < 2;
651: if (xDisplayType <> 'Z') then
652: select to_char(start_date,fnd_profile.VALUE('ICX_DATE_FORMAT_MASK')) ||' ' ||vTo||' '||
653: to_char(end_date,fnd_profile.VALUE('ICX_DATE_FORMAT_MASK')) into xPeriod