202: group by xref.wip_entity_id
203: having count(1) = 1
204: ) crjx1
205: , hr_organization_information hoi
206: , gl_sets_of_books gsob
207: where
208: rof.repair_line_id = crjx.repair_line_id
209: and crjx.wip_entity_id = wpb.wip_entity_id
210: and hoi.org_information_context = 'Accounting Information'
259: group by xref.wip_entity_id
260: having count (1) = 1
261: ) crjx1
262: , hr_organization_information hoi
263: , gl_sets_of_books gsob
264: where
265: rof.repair_line_id = crjx.repair_line_id
266: and crjx.wip_entity_id = wpb.wip_entity_id
267: and hoi.org_information_context = 'Accounting Information'