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.AD_ZD_PREP dependencies on FND_ORACLE_USERID

Line 95: from SYSTEM.fnd_oracle_userid

91: L_OUT clob;
92: L_INDEX number;
93: cursor C_EBS_SCHEMA is
94: select trim(oracle_username) oracle_username
95: from SYSTEM.fnd_oracle_userid
96: where read_only_flag in ('A','B', 'E', 'U', 'C')
97: order by 1;
98:
99: begin

Line 338: from fnd_oracle_userid fu

334: dba_xml_schemas xmls
335: where dep.type='TABLE'
336: and dep.owner in
337: (select oracle_username
338: from fnd_oracle_userid fu
339: where fu.read_only_flag in ('A','B', 'E', 'U', 'C') )
340: and dep.referenced_type = 'XML SCHEMA'
341: and dep.referenced_name = xmls.int_objname
342: -- XML schema owner either is SYSTEM or any e-biz user

Line 346: from fnd_oracle_userid fu

342: -- XML schema owner either is SYSTEM or any e-biz user
343: and ((xmls.owner = 'SYSTEM') or
344: xmls.owner in
345: (select oracle_username
346: from fnd_oracle_userid fu
347: where fu.read_only_flag in ('A','B', 'E', 'U', 'C')));
348: */
349: select owner, schema_url
350: from dba_xml_schemas

Line 363: from fnd_oracle_userid fu

359: or
360: owner in
361: (
362: select oracle_username
363: from fnd_oracle_userid fu
364: where fu.read_only_flag in ('A','B', 'E', 'U', 'C')
365: )
366: );
367:

Line 515: -- either referenced owner is registred SYSTEM.fnd_oracle_userids owner

511: and d.name = upper (name)
512: and d.referenced_type = 'TYPE'
513: and d.referenced_name = upper(d.referenced_name)
514: and (
515: -- either referenced owner is registred SYSTEM.fnd_oracle_userids owner
516: d.referenced_owner in
517: ( select oracle_username
518: from SYSTEM.fnd_oracle_userid
519: where read_only_flag in ('A','B', 'E', 'U', 'C')

Line 518: from SYSTEM.fnd_oracle_userid

514: and (
515: -- either referenced owner is registred SYSTEM.fnd_oracle_userids owner
516: d.referenced_owner in
517: ( select oracle_username
518: from SYSTEM.fnd_oracle_userid
519: where read_only_flag in ('A','B', 'E', 'U', 'C')
520: )
521: or
522: exists

Line 532: from SYSTEM.fnd_oracle_userid

528: and referenced_type = 'TYPE'
529: and referenced_owner in
530: (
531: select oracle_username
532: from SYSTEM.fnd_oracle_userid
533: where read_only_flag in ('A','B', 'E', 'U', 'C')
534: )
535: )
536: )

Line 555: from system.fnd_oracle_userid

551: and d.name = p.referenced_name
552: and d.owner = p.referenced_owner
553: and d.referenced_owner in
554: ( select oracle_username
555: from system.fnd_oracle_userid
556: where read_only_flag in ('A','B', 'E', 'U', 'C')
557: )
558: )
559: cycle referenced_owner, referenced_name set cyclemarker to 'Y' default 'N'

Line 825: -- either referenced owner is registred SYSTEM.fnd_oracle_userids owner

821: and d.name = upper (name)
822: and d.referenced_type = 'TYPE'
823: and d.referenced_name = upper(d.referenced_name)
824: and (
825: -- either referenced owner is registred SYSTEM.fnd_oracle_userids owner
826: d.referenced_owner in
827: ( select oracle_username
828: from SYSTEM.fnd_oracle_userid
829: where read_only_flag in ('A','B', 'E', 'U', 'C')

Line 828: from SYSTEM.fnd_oracle_userid

824: and (
825: -- either referenced owner is registred SYSTEM.fnd_oracle_userids owner
826: d.referenced_owner in
827: ( select oracle_username
828: from SYSTEM.fnd_oracle_userid
829: where read_only_flag in ('A','B', 'E', 'U', 'C')
830: )
831: OR
832: exists

Line 842: from SYSTEM.fnd_oracle_userid

838: and referenced_type = 'TYPE'
839: and referenced_owner in
840: (
841: select oracle_username
842: from SYSTEM.fnd_oracle_userid
843: where read_only_flag in ('A','B', 'E', 'U', 'C')
844: )
845: )
846: )

Line 866: from system.fnd_oracle_userid

862: and d.name = p.referenced_name
863: and d.owner = p.referenced_owner
864: and d.referenced_owner in
865: ( select oracle_username
866: from system.fnd_oracle_userid
867: where read_only_flag in ('A','B', 'E', 'U', 'C')
868: )
869: )
870: cycle referenced_owner, referenced_name set cyclemarker to 'Y' default 'N'

Line 1082: -- either referenced owner is registred SYSTEM.fnd_oracle_userids owner

1078: and name = upper ( name )
1079: and referenced_type = 'TYPE'
1080: and referenced_name = upper (referenced_name)
1081: and (
1082: -- either referenced owner is registred SYSTEM.fnd_oracle_userids owner
1083: referenced_owner in
1084: ( select oracle_username
1085: from SYSTEM.fnd_oracle_userid
1086: where read_only_flag in ('A','B', 'E', 'U','C')

Line 1085: from SYSTEM.fnd_oracle_userid

1081: and (
1082: -- either referenced owner is registred SYSTEM.fnd_oracle_userids owner
1083: referenced_owner in
1084: ( select oracle_username
1085: from SYSTEM.fnd_oracle_userid
1086: where read_only_flag in ('A','B', 'E', 'U','C')
1087: )
1088: or
1089: exists

Line 1099: from SYSTEM.fnd_oracle_userid

1095: and referenced_type = 'TYPE'
1096: and referenced_owner in
1097: (
1098: select oracle_username
1099: from SYSTEM.fnd_oracle_userid
1100: where read_only_flag in ('A','B', 'E', 'U', 'C')
1101: )
1102: )
1103: )

Line 1133: from SYSTEM.fnd_oracle_userid

1129: and d.name = p.referenced_name
1130: and d.owner = p.referenced_owner
1131: and d.referenced_owner in
1132: ( select oracle_username
1133: from SYSTEM.fnd_oracle_userid
1134: where read_only_flag in ('A','B', 'E', 'U', 'C')
1135: )
1136: and exists
1137: ( select 1

Line 1202: from SYSTEM.fnd_oracle_userid

1198: and d.referenced_name = upper(d.referenced_name)
1199: and (
1200: d.referenced_owner in
1201: ( select oracle_username
1202: from SYSTEM.fnd_oracle_userid
1203: where read_only_flag in ('A','B', 'E', 'U','C')
1204: )
1205: OR
1206: exists

Line 1216: from SYSTEM.fnd_oracle_userid

1212: and referenced_type = 'TYPE'
1213: and referenced_owner in
1214: (
1215: select oracle_username
1216: from SYSTEM.fnd_oracle_userid
1217: where read_only_flag in ('A','B', 'E', 'U', 'C')
1218: )
1219: )
1220: )

Line 1479: from SYSTEM.fnd_oracle_userid

1475: dba_tables atab
1476: , dba_tab_columns acol
1477: where atab.owner in
1478: ( select oracle_username
1479: from SYSTEM.fnd_oracle_userid
1480: where read_only_flag in ('A','B', 'E', 'U', 'C')
1481: )
1482: and acol.owner = atab.owner
1483: and acol.table_name = atab.table_name

Line 1486: from SYSTEM.fnd_oracle_userid

1482: and acol.owner = atab.owner
1483: and acol.table_name = atab.table_name
1484: and acol.data_type_owner in -- User defined data type (UDT)
1485: ( select oracle_username
1486: from SYSTEM.fnd_oracle_userid
1487: where read_only_flag in ('A','B', 'E', 'U', 'C')
1488: )
1489: order by 1, 2, 3;
1490:

Line 1506: from SYSTEM.fnd_oracle_userid

1502: where acol.owner = atab.owner
1503: and acol.table_name = atab.table_name
1504: and atab.owner IN -- table owner
1505: ( select oracle_username
1506: from SYSTEM.fnd_oracle_userid
1507: where read_only_flag in ('A','B', 'E', 'U', 'C')
1508: )
1509: and acol.data_type_owner='SYSTEM'
1510: and exists

Line 1526: from SYSTEM.fnd_oracle_userid

1522: and prior dep.referenced_type = dep.type
1523: and prior dep.referenced_type = 'TYPE'
1524: and dep.referenced_owner in (
1525: select oracle_username
1526: from SYSTEM.fnd_oracle_userid
1527: where read_only_flag in ('A','B', 'E', 'U', 'C')
1528: )
1529: )
1530: order by 1,2,3;

Line 1611: from SYSTEM.fnd_oracle_userid

1607: from dba_synonyms syn
1608: where syn.owner='PUBLIC'
1609: and syn.table_owner in
1610: (select oracle_username
1611: from SYSTEM.fnd_oracle_userid
1612: where read_only_flag in ('A','B', 'E', 'C', 'U'))
1613: and (syn.table_owner, syn.table_name) in
1614: (select obj.owner, obj.object_name
1615: from dba_objects obj

Line 1653: from system.fnd_oracle_userid

1649: where referenced_owner = 'PUBLIC'
1650: and referenced_type = 'SYNONYM'
1651: and referenced_name = x_synonym_name
1652: and owner in ( select oracle_username
1653: from system.fnd_oracle_userid
1654: where read_only_flag in ('A','B', 'E', 'C', 'U'));
1655:
1656:
1657: begin

Line 1758: from SYSTEM.fnd_oracle_userid

1754: where owner='CTXSYS'
1755: and TYPE='PACKAGE BODY'
1756: and referenced_owner in
1757: ( select oracle_username
1758: from SYSTEM.fnd_oracle_userid
1759: where read_only_flag in ('A','B', 'E', 'U', 'C')
1760: )
1761: and referenced_type in
1762: ( 'TYPE',

Line 1778: from SYSTEM.fnd_oracle_userid

1774: from dba_synonyms aps
1775: where aps.owner = 'CTXSYS'
1776: and aps.table_owner in
1777: ( select oracle_username
1778: from SYSTEM.fnd_oracle_userid
1779: where read_only_flag in ('A','B', 'E', 'U','C')
1780: )
1781: order by 1;
1782:

Line 1842: from SYSTEM.fnd_oracle_userid

1838: and col.owner = tab.owner
1839: and col.table_name = tab.table_name
1840: and col.data_type_owner in -- User defined data type (UDT)
1841: ( select oracle_username
1842: from SYSTEM.fnd_oracle_userid
1843: where read_only_flag in ('A','B', 'E', 'U', 'C')
1844: )
1845: order by 1, 2, 3;
1846:

Line 1934: -- users which are registered in fnd_oracle_userid (Only cost here is performance)

1930:
1931: log(l_module, 'STATEMENT', 'Fix XML schema: ');
1932:
1933: -- This is fine to run XML schema mover for all users as it will pick-up those
1934: -- users which are registered in fnd_oracle_userid (Only cost here is performance)
1935: -- TODO: Wait for DB fix 16286729, otherwise locking issue might occur.
1936: ad_zd_prep.move_xml_schemas;
1937:
1938: -- CASE#3: MV is dependent on function, throw error as this can be fixed automatically.

Line 1981: -- Registers a schema with fnd_oracle_userid with READ_ONLY_FLAG='B'

1977: end FIX_CUSTOM_OBJECTS;
1978:
1979:
1980: --
1981: -- Registers a schema with fnd_oracle_userid with READ_ONLY_FLAG='B'
1982: --
1983: procedure REGISTER_CUSTOM_USER(X_USER varchar2) is
1984: L_STMT varchar2(1000);
1985: begin

Line 2093: from system.fnd_oracle_userid fou

2089: procedure ENABLE_EDITIONS as
2090: l_module varchar2(80) := c_package || 'enable_editions';
2091: cursor c_users is
2092: select fou.oracle_username username
2093: from system.fnd_oracle_userid fou
2094: , dba_users du
2095: where fou.read_only_flag in ('A','B', 'E', 'U', 'C')
2096: and du.editions_enabled = 'N'
2097: and du.username = fou.oracle_username