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_PROFILES_VISIBLE dependencies on DUAL

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

46: v_profoval := sql_rec.prof_val;
47: v_sql_valid := sql_rec.sql_valid;
48:
49: if v_profoval is not null and v_sql_valid is not null then
50: select instr(v_sql_valid,'INTO') into v_into_loc from dual;
51: select instr(v_sql_valid,':VISIBLE_OPTION_VALUE') into v_visoval_loc from dual;
52: select instr(v_sql_valid,':PROFILE_OPTION_VALUE') into v_profoval_loc from dual;
53: select instr(v_sql_valid,'WHERE',-1,1) into v_whr_loc from dual;
54: select instr(v_sql_valid,'FROM',1,1) into v_from_loc from dual;

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

47: v_sql_valid := sql_rec.sql_valid;
48:
49: if v_profoval is not null and v_sql_valid is not null then
50: select instr(v_sql_valid,'INTO') into v_into_loc from dual;
51: select instr(v_sql_valid,':VISIBLE_OPTION_VALUE') into v_visoval_loc from dual;
52: select instr(v_sql_valid,':PROFILE_OPTION_VALUE') into v_profoval_loc from dual;
53: select instr(v_sql_valid,'WHERE',-1,1) into v_whr_loc from dual;
54: select instr(v_sql_valid,'FROM',1,1) into v_from_loc from dual;
55: --select instr(v_sql_valid,'COLUMN') into v_col_loc from dual;

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

48:
49: if v_profoval is not null and v_sql_valid is not null then
50: select instr(v_sql_valid,'INTO') into v_into_loc from dual;
51: select instr(v_sql_valid,':VISIBLE_OPTION_VALUE') into v_visoval_loc from dual;
52: select instr(v_sql_valid,':PROFILE_OPTION_VALUE') into v_profoval_loc from dual;
53: select instr(v_sql_valid,'WHERE',-1,1) into v_whr_loc from dual;
54: select instr(v_sql_valid,'FROM',1,1) into v_from_loc from dual;
55: --select instr(v_sql_valid,'COLUMN') into v_col_loc from dual;
56: --v_sql_valid := replace(v_sql_valid,substr(v_sql_valid,v_col_loc-1),'');

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

49: if v_profoval is not null and v_sql_valid is not null then
50: select instr(v_sql_valid,'INTO') into v_into_loc from dual;
51: select instr(v_sql_valid,':VISIBLE_OPTION_VALUE') into v_visoval_loc from dual;
52: select instr(v_sql_valid,':PROFILE_OPTION_VALUE') into v_profoval_loc from dual;
53: select instr(v_sql_valid,'WHERE',-1,1) into v_whr_loc from dual;
54: select instr(v_sql_valid,'FROM',1,1) into v_from_loc from dual;
55: --select instr(v_sql_valid,'COLUMN') into v_col_loc from dual;
56: --v_sql_valid := replace(v_sql_valid,substr(v_sql_valid,v_col_loc-1),'');
57: if v_profoval_loc < v_visoval_loc then

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

50: select instr(v_sql_valid,'INTO') into v_into_loc from dual;
51: select instr(v_sql_valid,':VISIBLE_OPTION_VALUE') into v_visoval_loc from dual;
52: select instr(v_sql_valid,':PROFILE_OPTION_VALUE') into v_profoval_loc from dual;
53: select instr(v_sql_valid,'WHERE',-1,1) into v_whr_loc from dual;
54: select instr(v_sql_valid,'FROM',1,1) into v_from_loc from dual;
55: --select instr(v_sql_valid,'COLUMN') into v_col_loc from dual;
56: --v_sql_valid := replace(v_sql_valid,substr(v_sql_valid,v_col_loc-1),'');
57: if v_profoval_loc < v_visoval_loc then
58:

Line 55: --select instr(v_sql_valid,'COLUMN') into v_col_loc from dual;

51: select instr(v_sql_valid,':VISIBLE_OPTION_VALUE') into v_visoval_loc from dual;
52: select instr(v_sql_valid,':PROFILE_OPTION_VALUE') into v_profoval_loc from dual;
53: select instr(v_sql_valid,'WHERE',-1,1) into v_whr_loc from dual;
54: select instr(v_sql_valid,'FROM',1,1) into v_from_loc from dual;
55: --select instr(v_sql_valid,'COLUMN') into v_col_loc from dual;
56: --v_sql_valid := replace(v_sql_valid,substr(v_sql_valid,v_col_loc-1),'');
57: if v_profoval_loc < v_visoval_loc then
58:
59: v_where_ins := replace(v_sql_valid,'WHERE','WHERE '||