ORA-01427 error concern

Hi All,

I was trying to run this query and I always got this error:

Usually, this query works when I generate single shipments but when I run the multiple ones I always got this error.

Can you suggest or recommend a way to fix this? Your response is very much appreciated.

Here is the query:

/* Formatted on 10/31/2017 10:58:08 (QP5 v5.227.12220.39754) */
SELECT shpmt.shipment_gid SLI_SHIPMENT_GID,
       (SELECT NVL ('Y', NULL)
          FROM shipment_status ss
         WHERE     ss.shipment_gid = shpmt.shipment_gid
               AND ss.status_type_gid = ss.domain_name || '.SECURE RESOURCES'
               AND ss.status_value_gid IN
                      (ss.domain_name || '.SECURE RESOURCES_ACCEPTED',