[Home] [Help]
375: SELECT grp.repair_group_id,
376: grp.group_quantity,
377: grp.object_version_number
378: INTO l_repair_group_id, l_group_quantity, l_group_ovn
379: FROM CSD_REPAIR_ORDER_GROUPS grp
380: WHERE EXISTS
381: (SELECT 'x'
382: FROM CSD_REPAIRS rep
383: WHERE rep.repair_group_id = grp.repair_group_id