195: + nvl(pl_outside_processing_in,0) ) expense_cost_b
196: from
197: isc_dr_repair_orders_f rof
198: , csd_repair_job_xref crjx
199: , wip_period_balances wpb
200: , ( select wip_entity_id
201: from csd_repair_job_xref xref
202: group by xref.wip_entity_id
203: having count(1) = 1
252: ) expense_cost_b
253: from
254: isc_dr_repair_orders_f rof
255: , csd_repair_job_xref crjx
256: , wip_period_balances wpb
257: , ( select wip_entity_id
258: from csd_repair_job_xref xref
259: group by xref.wip_entity_id
260: having count (1) = 1