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.

[Home] [Help]

SYSTEM.AD_DDL dependencies on FND_ORACLE_USERID

Line 170: from fnd_oracle_userid where read_only_flag='U';

166: else
167: select ORACLE_USERNAME
168: into
169: oracle_schema
170: from fnd_oracle_userid where read_only_flag='U';
171: end if;
172: end if;
173:
174: log_message('calling private_do_ddl..');

Line 230: p_apps_schema||'.fnd_oracle_userid '||

226: c_statement varchar2(2000);
227: begin
228: c := dbms_sql.open_cursor;
229: c_statement:='select install_group_num from '||
230: p_apps_schema||'.fnd_oracle_userid '||
231: 'where oracle_username = upper(:oracle_schema) '||
232: 'and install_group_num is not null';
233: dbms_sql.parse(c, c_statement, dbms_sql.native);
234: dbms_sql.bind_variable(c,'oracle_schema',oracle_schema,30);

Line 602: davcsap_apps_schema||'.fnd_oracle_userid '||

598: begin
599: print_local_sql := TRUE;
600: c := dbms_sql.open_cursor;
601: c_statement:='select install_group_num from '||
602: davcsap_apps_schema||'.fnd_oracle_userid '||
603: 'where read_only_flag = ''U'' '||
604: 'order by install_group_num';
605: dbms_sql.parse(c, c_statement, dbms_sql.native);
606: dbms_sql.define_column(c,1,l_install_group_num);

Line 798: dctcs_apps_schema||'.fnd_oracle_userid '||

794: begin
795: print_local_sql := TRUE;
796: c := dbms_sql.open_cursor;
797: c_statement:='select distinct install_group_num from '||
798: dctcs_apps_schema||'.fnd_oracle_userid '||
799: 'where read_only_flag = ''U'' '||
800: 'order by install_group_num';
801: dbms_sql.parse(c, c_statement, dbms_sql.native);
802: dbms_sql.define_column(c,1,l_install_group_num);

Line 972: dcv_apps_schema||'.fnd_oracle_userid '||

968: begin
969: print_local_sql := TRUE;
970: c := dbms_sql.open_cursor;
971: c_statement:='select distinct install_group_num from '||
972: dcv_apps_schema||'.fnd_oracle_userid '||
973: 'where read_only_flag = ''U'' '||
974: 'order by install_group_num';
975: dbms_sql.parse(c, c_statement, dbms_sql.native);
976: dbms_sql.define_column(c,1,l_install_group_num);

Line 1204: '.fnd_oracle_userid where oracle_username = USER';

1200: -- use current user. Otherwise, use the APPS schema returned above
1201: --
1202:
1203: c_statement := 'select oracle_username from '||upper(apps_schema)||
1204: '.fnd_oracle_userid where oracle_username = USER';
1205:
1206: begin
1207: EXECUTE IMMEDIATE c_statement
1208: into effective_schema;

Line 1255: fnd_oracle_userid where

1251: select ORACLE_USERNAME
1252: into
1253: oracle_schema
1254: from
1255: fnd_oracle_userid where
1256: read_only_flag='U';
1257: end if;
1258: end if;
1259:

Line 1272: apps_schema||'.fnd_oracle_userid '||

1268: -- Get the name of the first apps schema
1269:
1270: begin
1271: c_statement := 'select oracle_username from '||
1272: apps_schema||'.fnd_oracle_userid '||
1273: 'where install_group_num = 1 and read_only_flag = ''U''';
1274:
1275: EXECUTE IMMEDIATE c_statement
1276: into first_apps_schema;

Line 1298: apps_schema||'.fnd_oracle_userid '||

1294: c_statement varchar2(2000);
1295: begin
1296: c := dbms_sql.open_cursor;
1297: c_statement:='select install_group_num from '||
1298: apps_schema||'.fnd_oracle_userid '||
1299: 'where oracle_username = upper(:oracle_schema) '||
1300: 'and install_group_num is not null';
1301: dbms_sql.parse(c, c_statement, dbms_sql.native);
1302: dbms_sql.bind_variable(c,'oracle_schema',oracle_schema,30);

Line 1338: apps_schema||'.fnd_oracle_userid '||

1334: if install_group_num <> 0 then
1335:
1336: begin
1337: c_statement := 'select oracle_username from '||
1338: apps_schema||'.fnd_oracle_userid '||
1339: 'where install_group_num = '||install_group_num||
1340: ' and read_only_flag = ''U''';
1341:
1342: EXECUTE IMMEDIATE c_statement

Line 2111: 'from '||upper(first_apps_schema)||'.fnd_oracle_userid '||

2107: c_statement := 'select count(*) from dba_objects '||
2108: 'where object_name='''||upper_obj_name||
2109: ''' and object_type='''||upper(object_type)||
2110: ''' and owner in (select oracle_username '||
2111: 'from '||upper(first_apps_schema)||'.fnd_oracle_userid '||
2112: 'where read_only_flag in (''U'',''K'')) '||
2113: 'and status=''INVALID''';
2114:
2115: EXECUTE IMMEDIATE c_statement

Line 2249: fnd_oracle_userid where

2245: select ORACLE_USERNAME
2246: into
2247: oracle_schema
2248: from
2249: fnd_oracle_userid where
2250: read_only_flag='U';
2251: end if;
2252: end if;
2253:

Line 2302: p_apps_schema||'.fnd_oracle_userid '||

2298: c_statement varchar2(2000);
2299: begin
2300: c := dbms_sql.open_cursor;
2301: c_statement:='select install_group_num from '||
2302: p_apps_schema||'.fnd_oracle_userid '||
2303: 'where oracle_username = upper(:oracle_schema) '||
2304: 'and install_group_num is not null';
2305: dbms_sql.parse(c, c_statement, dbms_sql.native);
2306: dbms_sql.bind_variable(c,'oracle_schema',oracle_schema,30);

Line 2407: dcv_apps_schema||'.fnd_oracle_userid '||

2403: begin
2404: print_local_sql := TRUE;
2405: c := dbms_sql.open_cursor;
2406: c_statement:='select distinct install_group_num from '||
2407: dcv_apps_schema||'.fnd_oracle_userid '||
2408: 'where read_only_flag = ''U'' '||
2409: 'order by install_group_num';
2410: dbms_sql.parse(c, c_statement, dbms_sql.native);
2411: dbms_sql.define_column(c,1,l_install_group_num);