APPS.AD_ZD_PREP dependencies on XDB$ELEMENT

Line 539: from xdb.xdb$element e

535: )
536: )
537: /* filter out XDB types */
538: and not exists ( select null
539: from xdb.xdb$element e
540: where e.xmldata.property.sqltype = d.referenced_name )
541: and not exists (select null
542: from xdb.xdb$element e
543: where e.xmldata.property.sqlcolltype = d.referenced_name)

Line 542: from xdb.xdb$element e

538: and not exists ( select null
539: from xdb.xdb$element e
540: where e.xmldata.property.sqltype = d.referenced_name )
541: and not exists (select null
542: from xdb.xdb$element e
543: where e.xmldata.property.sqlcolltype = d.referenced_name)
544: union all
545: select d.referenced_owner referenced_owner,
546: d.referenced_name referenced_name

Line 849: from xdb.xdb$element e

845: )
846: )
847: -- /* filter out XDB types */
848: and not exists ( select null
849: from xdb.xdb$element e
850: where e.xmldata.property.sqltype = d.referenced_name )
851: and not exists (select null
852: from xdb.xdb$element e
853: where e.xmldata.property.sqlcolltype = d.referenced_name)

Line 852: from xdb.xdb$element e

848: and not exists ( select null
849: from xdb.xdb$element e
850: where e.xmldata.property.sqltype = d.referenced_name )
851: and not exists (select null
852: from xdb.xdb$element e
853: where e.xmldata.property.sqlcolltype = d.referenced_name)
854:
855: union all
856: select d.referenced_owner referenced_owner,

Line 1116: from xdb.xdb$element e

1112: and o.subname is not null
1113: )
1114: /* filter out XDB types */
1115: and not exists ( select null
1116: from xdb.xdb$element e
1117: where e.xmldata.property.sqltype = d.referenced_name )
1118: and not exists (select null
1119: from xdb.xdb$element e
1120: where e.xmldata.property.sqlcolltype = d.referenced_name)

Line 1119: from xdb.xdb$element e

1115: and not exists ( select null
1116: from xdb.xdb$element e
1117: where e.xmldata.property.sqltype = d.referenced_name )
1118: and not exists (select null
1119: from xdb.xdb$element e
1120: where e.xmldata.property.sqlcolltype = d.referenced_name)
1121:
1122: union all
1123: select d.referenced_owner referenced_owner,

Line 1230: from xdb.xdb$element e

1226: and o.type# = 13
1227: and o.subname is not null
1228: )
1229: and not exists ( select null
1230: from xdb.xdb$element e
1231: where e.xmldata.property.sqltype = d.referenced_name )
1232: and not exists (select null
1233: from xdb.xdb$element e
1234: where e.xmldata.property.sqlcolltype = d.referenced_name);

Line 1233: from xdb.xdb$element e

1229: and not exists ( select null
1230: from xdb.xdb$element e
1231: where e.xmldata.property.sqltype = d.referenced_name )
1232: and not exists (select null
1233: from xdb.xdb$element e
1234: where e.xmldata.property.sqlcolltype = d.referenced_name);
1235:
1236: if(l_count > 0 ) then
1237: -- Note: Evolved types should be created in a proper order and dependent TYPEs should be VALID.