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.OKS_SETUPRPT_PVT dependencies on DUAL

Line 61: select instr(v_sql_valid,'INTO') into v_into_loc from dual;

57: v_sql_valid := sql_rec.sql_valid;
58:
59:
60: if v_profoval is not null and v_sql_valid is not null then
61: select instr(v_sql_valid,'INTO') into v_into_loc from dual;
62: select instr(v_sql_valid,':VISIBLE_OPTION_VALUE') into v_visoval_loc from dual;
63: select instr(v_sql_valid,':PROFILE_OPTION_VALUE') into v_profoval_loc from dual;
64: select instr(v_sql_valid,'WHERE',-1,1) into v_whr_loc from dual;
65: select instr(v_sql_valid,'FROM',1,1) into v_from_loc from dual;

Line 62: select instr(v_sql_valid,':VISIBLE_OPTION_VALUE') into v_visoval_loc from dual;

58:
59:
60: if v_profoval is not null and v_sql_valid is not null then
61: select instr(v_sql_valid,'INTO') into v_into_loc from dual;
62: select instr(v_sql_valid,':VISIBLE_OPTION_VALUE') into v_visoval_loc from dual;
63: select instr(v_sql_valid,':PROFILE_OPTION_VALUE') into v_profoval_loc from dual;
64: select instr(v_sql_valid,'WHERE',-1,1) into v_whr_loc from dual;
65: select instr(v_sql_valid,'FROM',1,1) into v_from_loc from dual;
66: select instr(v_sql_valid,'ORDER',1,1) into v_orderby_loc from dual;

Line 63: select instr(v_sql_valid,':PROFILE_OPTION_VALUE') into v_profoval_loc from dual;

59:
60: if v_profoval is not null and v_sql_valid is not null then
61: select instr(v_sql_valid,'INTO') into v_into_loc from dual;
62: select instr(v_sql_valid,':VISIBLE_OPTION_VALUE') into v_visoval_loc from dual;
63: select instr(v_sql_valid,':PROFILE_OPTION_VALUE') into v_profoval_loc from dual;
64: select instr(v_sql_valid,'WHERE',-1,1) into v_whr_loc from dual;
65: select instr(v_sql_valid,'FROM',1,1) into v_from_loc from dual;
66: select instr(v_sql_valid,'ORDER',1,1) into v_orderby_loc from dual;
67:

Line 64: select instr(v_sql_valid,'WHERE',-1,1) into v_whr_loc from dual;

60: if v_profoval is not null and v_sql_valid is not null then
61: select instr(v_sql_valid,'INTO') into v_into_loc from dual;
62: select instr(v_sql_valid,':VISIBLE_OPTION_VALUE') into v_visoval_loc from dual;
63: select instr(v_sql_valid,':PROFILE_OPTION_VALUE') into v_profoval_loc from dual;
64: select instr(v_sql_valid,'WHERE',-1,1) into v_whr_loc from dual;
65: select instr(v_sql_valid,'FROM',1,1) into v_from_loc from dual;
66: select instr(v_sql_valid,'ORDER',1,1) into v_orderby_loc from dual;
67:
68:

Line 65: select instr(v_sql_valid,'FROM',1,1) into v_from_loc from dual;

61: select instr(v_sql_valid,'INTO') into v_into_loc from dual;
62: select instr(v_sql_valid,':VISIBLE_OPTION_VALUE') into v_visoval_loc from dual;
63: select instr(v_sql_valid,':PROFILE_OPTION_VALUE') into v_profoval_loc from dual;
64: select instr(v_sql_valid,'WHERE',-1,1) into v_whr_loc from dual;
65: select instr(v_sql_valid,'FROM',1,1) into v_from_loc from dual;
66: select instr(v_sql_valid,'ORDER',1,1) into v_orderby_loc from dual;
67:
68:
69: if v_profoval_loc < v_visoval_loc then

Line 66: select instr(v_sql_valid,'ORDER',1,1) into v_orderby_loc from dual;

62: select instr(v_sql_valid,':VISIBLE_OPTION_VALUE') into v_visoval_loc from dual;
63: select instr(v_sql_valid,':PROFILE_OPTION_VALUE') into v_profoval_loc from dual;
64: select instr(v_sql_valid,'WHERE',-1,1) into v_whr_loc from dual;
65: select instr(v_sql_valid,'FROM',1,1) into v_from_loc from dual;
66: select instr(v_sql_valid,'ORDER',1,1) into v_orderby_loc from dual;
67:
68:
69: if v_profoval_loc < v_visoval_loc then
70: if v_whr_loc <> 0 then