--
SELECT       DISTINCT
                   order_number
  , 'GROUP_ID=' || group_id
FROM
    fusion.doo_orchestration_groups dog
  , fusion.doo_fulfill_lines_all    dfla
  , fusion.doo_headers_all          dha
WHERE
    dog.Fulfillment_line_id = dfla.fulfill_line_id
    AND dha.header_id       = dfla.header_id
    AND order_number IN ('&ORDER_NUMBER')
    AND submitted_flag = 'Y'
    AND status         = 'ACTIVE'
ORDER BY
    1
  , 2