APPS.AZ_VALIDATE_ACTIVE dependencies on AZ_STRUCTURE_APIS_B

Line 89: az_structure_apis_b sapi,

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
91: WHERE strct.structure_code = sset.structure_code
92: AND strct.structure_code = sapi.structure_code
93: AND sset.selection_set_code = ent.selection_set_code

Line 136: FROM az_structure_apis_b

132: AND d.selection_set IS NOT NULL)
133: AND strct.active = 'N'
134: AND api.api_code IN -- 2
135: (SELECT api_code
136: FROM az_structure_apis_b
137: WHERE structure_code IN
138: (SELECT extractvalue(VALUE(e),
139: '/H/V[@N="StructureCode"]/text()')
140: FROM az_requests d,

Line 219: FROM az_structure_apis_b

215: AND d.selection_set IS NOT NULL)
216: AND strct.active = 'N'
217: AND api.api_code IN -- 2
218: (SELECT api_code
219: FROM az_structure_apis_b
220: WHERE structure_code IN
221: (SELECT extractvalue(VALUE(e),
222: '/H/V[@N="StructureCode"]/text()')
223: FROM az_requests d,