APPS.AD_ZD_PREP dependencies on DBA_XML_SCHEMAS

Line 334: dba_xml_schemas xmls

330: --
331: -- adding DISTINCT as two tabls might refer same xml schema
332: select distinct xmls.owner, xmls.schema_url
333: from dba_dependencies dep,
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

Line 350: from dba_xml_schemas

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
351: where (
352: /* oracle seeded xml schemas in SYSTEM user */
353: (schema_url in (
354: 'http://isetup.oracle.com/2006/diffresultdata.xsd' ,

Line 1868: from dba_xml_schemas

1864:
1865: -- XML schema owned by custom user
1866: cursor C_XML_SCHEMAS is
1867: select owner, schema_url
1868: from dba_xml_schemas
1869: where owner =x_user;
1870:
1871: -- MVs
1872: cursor C_MVS is