89: UNION
90: -- import ASN
91: SELECT rsh.shipment_header_id
92: FROM rcv_shipment_headers rsh,
93: rcv_headers_interface rhi,
94: rcv_parameters rp
95: WHERE rhi.group_id = DECODE(p_group_id, 0, rhi.group_id, p_group_id)
96: AND rsh.shipment_num = rhi.shipment_num
97: AND rsh.request_id = p_request_id