APPS.AZ_VALIDATE_ACTIVE dependencies on XMLSEQUENCE

Line 37: TABLE(xmlsequence(extract(d.selection_set,

33: WHERE structure_code =
34: (SELECT extractvalue(VALUE(e),
35: '/H/V[@N="StructureCode"]/text()')
36: FROM az_requests d,
37: TABLE(xmlsequence(extract(d.selection_set,
38: '/EXT/H/V[@N="StructureCode"]/..'))) e
39: WHERE req.job_name = d.job_name
40: AND req.user_id = d.user_id
41: AND req.request_type = d.request_type

Line 66: TABLE(xmlsequence(extract(d.selection_set,

62: WHERE structure_code =
63: (SELECT extractvalue(VALUE(e),
64: '/H/V[@N="StructureCode"]/text()')
65: FROM az_requests d,
66: TABLE(xmlsequence(extract(d.selection_set,
67: '/EXT/H/V[@N="StructureCode"]/..'))) e
68: WHERE req.job_name = d.job_name
69: AND req.user_id = d.user_id
70: AND req.request_type = d.request_type

Line 127: TABLE(xmlsequence(extract(d.selection_set,

123: WHERE strct.structure_code = -- query b
124: (SELECT extractvalue(VALUE(e),
125: '/H/V[@N="StructureCode"]/text()')
126: FROM az_requests d,
127: TABLE(xmlsequence(extract(d.selection_set,
128: '/EXT/H/V[@N="StructureCode"]/..'))) e
129: WHERE req.job_name = d.job_name
130: AND req.user_id = d.user_id
131: AND req.request_type = d.request_type

Line 141: TABLE(xmlsequence(extract(d.selection_set,

137: WHERE structure_code IN
138: (SELECT extractvalue(VALUE(e),
139: '/H/V[@N="StructureCode"]/text()')
140: FROM az_requests d,
141: TABLE(xmlsequence(extract(d.selection_set,
142: '/EXT/H/V[@N="StructureCode"]/..'))) e
143: WHERE d.job_name = req.job_name
144: AND d.request_type = req.request_type
145: AND d.user_id = req.user_id -- 2's first where

Line 150: TABLE(xmlsequence(extract(d.selection_set,

146: AND d.selection_set IS NOT NULL)
147: AND entity_code IN (SELECT extractvalue(VALUE(e),
148: '/H/V[@N="EntityOccuranceCode"]/text()')
149: FROM az_requests d,
150: TABLE(xmlsequence(extract(d.selection_set,
151: '/EXT/H/V[@N="EntityOccuranceCode"]/..'))) e
152: WHERE d.job_name = req.job_name
153: AND d.request_type = req.request_type
154: AND d.user_id = req.user_id -- 2's second where

Line 170: TABLE(xmlsequence(extract(d.selection_set,

166: WHERE structure_code = -- query b
167: (SELECT extractvalue(VALUE(e),
168: '/H/V[@N="StructureCode"]/text()')
169: FROM az_requests d,
170: TABLE(xmlsequence(extract(d.selection_set,
171: '/EXT/H/V[@N="StructureCode"]/..'))) e
172: WHERE req.job_name = d.job_name
173: AND req.user_id = d.user_id
174: AND req.request_type = d.request_type

Line 210: TABLE(xmlsequence(extract(d.selection_set,

206: WHERE strct.structure_code = -- query b
207: (SELECT extractvalue(VALUE(e),
208: '/H/V[@N="StructureCode"]/text()')
209: FROM az_requests d,
210: TABLE(xmlsequence(extract(d.selection_set,
211: '/EXT/H/V[@N="StructureCode"]/..'))) e
212: WHERE req.job_name = d.job_name
213: AND req.user_id = d.user_id
214: AND req.request_type = d.request_type

Line 224: TABLE(xmlsequence(extract(d.selection_set,

220: WHERE structure_code IN
221: (SELECT extractvalue(VALUE(e),
222: '/H/V[@N="StructureCode"]/text()')
223: FROM az_requests d,
224: TABLE(xmlsequence(extract(d.selection_set,
225: '/EXT/H/V[@N="StructureCode"]/..'))) e
226: WHERE d.job_name = req.job_name
227: AND d.request_type = req.request_type
228: AND d.user_id = req.user_id -- 2's first where

Line 233: TABLE(xmlsequence(extract(d.selection_set,

229: AND d.selection_set IS NOT NULL)
230: AND entity_code IN (SELECT extractvalue(VALUE(e),
231: '/H/V[@N="EntityOccuranceCode"]/text()')
232: FROM az_requests d,
233: TABLE(xmlsequence(extract(d.selection_set,
234: '/EXT/H/V[@N="EntityOccuranceCode"]/..'))) e
235: WHERE d.job_name = req.job_name
236: AND d.request_type = req.request_type
237: AND d.user_id = req.user_id -- 2's second where

Line 253: TABLE(xmlsequence(extract(d.selection_set,

249: WHERE structure_code = -- query b
250: (SELECT extractvalue(VALUE(e),
251: '/H/V[@N="StructureCode"]/text()')
252: FROM az_requests d,
253: TABLE(xmlsequence(extract(d.selection_set,
254: '/EXT/H/V[@N="StructureCode"]/..'))) e
255: WHERE req.job_name = d.job_name
256: AND req.user_id = d.user_id
257: AND req.request_type = d.request_type