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 DUAL

Line 115: select substr(vPeriod,0,INSTR(vPeriod,'|')-1) into xRetString from dual;

111: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_REPORT_NAME');
112: vFor := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','FOR');
113: xRetString := '';
114: if (vPeriod is not NULL) then
115: select substr(vPeriod,0,INSTR(vPeriod,'|')-1) into xRetString from dual;
116: xRetString := ' '||vFor||' ' || xRetString;
117: end if;
118: return (vRepName || xRetString);
119:

Line 149: --select fnd_profile.VALUE('AMS_DEFAULT_CURR_CODE') into vCurrency from dual;

145: and language = userenv('LANG');
146: vPeriod := jtfb_dcf.get_parameter_value(p_parameters, 'P_PERIOD');
147: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_REPORT_NAME');
148: xRetString := '';
149: --select fnd_profile.VALUE('AMS_DEFAULT_CURR_CODE') into vCurrency from dual;
150: if (vPeriod is not NULL) then
151: select substr(vPeriod,0,INSTR(vPeriod,'|')-1) into xRetString from dual;
152: --xRetString := ' - ' || xRetString;
153: end if;

Line 151: select substr(vPeriod,0,INSTR(vPeriod,'|')-1) into xRetString from dual;

147: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_REPORT_NAME');
148: xRetString := '';
149: --select fnd_profile.VALUE('AMS_DEFAULT_CURR_CODE') into vCurrency from dual;
150: if (vPeriod is not NULL) then
151: select substr(vPeriod,0,INSTR(vPeriod,'|')-1) into xRetString from dual;
152: --xRetString := ' - ' || xRetString;
153: end if;
154: --return (vRepName ||' (in '||vCurrency||')'|| xRetString);
155: return (vRepName || get_currency(p_parameters) || xRetString);

Line 381: select fnd_profile.VALUE('AMS_DEFAULT_CURR_CODE') into vCurrency from dual;

377: vTo := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','TO');
378:
379: xRetString := 'x';
380: xDisplayType := 'Z';
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;

Line 383: select substr(vDefPeriod,0,INSTR(vDefPeriod,'-',10)-1) into xRetString from dual;

379: xRetString := 'x';
380: xDisplayType := 'Z';
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;

Line 489: select substr(vContext,INSTR(vContext,'-',-1)+1) into xIncr from dual;

485: and language = userenv('LANG');
486: vContext := jtfb_dcf.get_parameter_value(p_parameters, 'pContext');
487: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_REPORT_NAME');
488:
489: select substr(vContext,INSTR(vContext,'-',-1)+1) into xIncr from dual;
490:
491: select start_date ||'-'|| end_date into xPeriod from bim_r_periods where calc_type = 'ROLLING' and period_type = xIncr;
492:
493: return (vRepName||' '||xPeriod );

Line 622: select substr(vDefPeriod,0,INSTR(vDefPeriod,'-',10)-1) into xRetString from dual;

618: vTo := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','TO');
619:
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;