APPS.AZ_VALIDATE_ACTIVE dependencies on AZ_STRUCTURES_B

Line 14: FROM az_structures_b

10: (SELECT selection_set_code
11: FROM az_selection_sets_b
12: WHERE user_id <> 1
13: AND structure_code IN (SELECT structure_code
14: FROM az_structures_b
15: WHERE active = 'N'));
16: COMMIT;
17:
18: END validate_selsets;

Line 32: FROM az_structures_b strct

28:
29: UPDATE az_requests req
30: SET req.active = (
31: SELECT decode(strct.active, 'N', 'N', NULL, 'N', 'Y')
32: FROM az_structures_b strct
33: WHERE structure_code =
34: (SELECT extractvalue(VALUE(e),
35: '/H/V[@N="StructureCode"]/text()')
36: FROM az_requests d,

Line 61: FROM az_structures_b strct

57:
58: UPDATE az_requests req
59: SET req.active = (
60: SELECT decode(strct.active, 'N', 'N', NULL, 'N', 'Y')
61: FROM az_structures_b strct
62: WHERE structure_code =
63: (SELECT extractvalue(VALUE(e),
64: '/H/V[@N="StructureCode"]/text()')
65: FROM az_requests d,

Line 86: FROM az_structures_b strct,

82: UPDATE az_apis
83: SET active = 'Y'
84: WHERE api_code IN (
85: SELECT DISTINCT api.api_code
86: FROM az_structures_b strct,
87: az_selection_sets_b sset,
88: az_selection_set_entities_b ent,
89: az_structure_apis_b sapi,
90: az_apis api

Line 122: FROM az_structures_b strct, az_apis api

118:
119: UPDATE az_requests req
120: SET req.active = (
121: SELECT decode(COUNT(api.active), 0, 'N', 'R')
122: FROM az_structures_b strct, az_apis api
123: WHERE strct.structure_code = -- query b
124: (SELECT extractvalue(VALUE(e),
125: '/H/V[@N="StructureCode"]/text()')
126: FROM az_requests d,

Line 165: FROM az_structures_b strct

161:
162: UPDATE az_requests req
163: SET req.active = (decode(
164: (SELECT 'Y'
165: FROM az_structures_b strct
166: WHERE structure_code = -- query b
167: (SELECT extractvalue(VALUE(e),
168: '/H/V[@N="StructureCode"]/text()')
169: FROM az_requests d,

Line 205: FROM az_structures_b strct, az_apis api

201:
202: UPDATE az_requests req
203: SET req.active = (
204: SELECT decode(COUNT(api.active), 0, 'N', 'R')
205: FROM az_structures_b strct, az_apis api
206: WHERE strct.structure_code = -- query b
207: (SELECT extractvalue(VALUE(e),
208: '/H/V[@N="StructureCode"]/text()')
209: FROM az_requests d,

Line 248: FROM az_structures_b strct

244:
245: UPDATE az_requests req
246: SET req.active = (decode(
247: (SELECT 'Y'
248: FROM az_structures_b strct
249: WHERE structure_code = -- query b
250: (SELECT extractvalue(VALUE(e),
251: '/H/V[@N="StructureCode"]/text()')
252: FROM az_requests d,