SELECT COUNT (s.shipment_gid)
INTO v_num
  FROM (SELECT   COUNT (sr.i_transaction_no) cnt, s.shipment_gid
            FROM ie_shipmentstatus ss, shipment s, ie_shipment_refnum sr
           WHERE ss.i_transaction_no = sr.i_transaction_no
             AND sr.shipment_refnum_value = s.shipment_gid
             AND ss.status_code_gid = 'SPL.ETA'
        GROUP BY s.shipment_gid
       );

SELECT count(*) INTO variable
FROM (YOUR_CREATE_VIEW_CODE_HERE);

SQL> get p
  1  select x.dpt, count(x.eno) num_of_emps
  2  from (select d.dname dpt, e.empno eno
  3        from dept d, emp e
  4        where d.deptno = e.deptno
  5       ) x
  6* group by x.dpt
SQL> /

DPT            NUM_OF_EMPS
-------------- -----------
ACCOUNTING               3
OPERATIONS               5
RESEARCH                 5
SALES                    1

SQL> edit p

SQL>
SQL> set serveroutput on
SQL> get p
  1  declare
  2    l_dpt dept.dname%type;
  3    l_num_of_emps number;
  4  begin
  5    select x.dpt, count(x.eno) num_of_emps
  6    into l_dpt, l_num_of_emps
  7    from (select d.dname dpt, e.empno eno
  8          from dept d, emp e
  9          where d.deptno = e.deptno
 10            and d.deptno = 10
 11         ) x
 12    group by x.dpt;
 13    dbms_output.put_line(l_dpt || ': ' || l_num_of_emps);
 14* end;
 15  /
ACCOUNTING: 3

PL/SQL procedure successfully completed.

SQL>

table<shipment>
:shipment_gid
:source_location_gid
:location_gid

table<IE_shipmentstatus>
:status_code
:ITransaction_no

table<location>
:location_gid

table<IE_shipmentrefnum>
:shipment_gid
: ITransaction_no

SELECT COUNT(x.shipment_gid) INTO v_num
FROM location l,(SELECT COUNT(sr.i_transaction_no)cnt, s.shipment_gid
             FROM ie_shipmentstatus ss, shipment s, ie_shipment_refnum sr
             WHERE ss.i_transaction_no = sr.i_transaction_no
                   AND sr.shipment_refnum_value = s.shipment_gid
                   AND ss.status_code_gid ='SPL.ETA' 
                   

                   group by s.shipment_gid
             )x
where x.cnt>1
GROUP BY l.location_gid;

SELECT COUNT(x.shipment_gid) 
INTO v_num
FROM
    (SELECT COUNT(sr.i_transaction_no) cnt, s.shipment_gid, l.location_gid
     FROM ie_shipmentstatus ss, shipment s, ie_shipment_refnum sr,
           location l
     WHERE ss.i_transaction_no = sr.i_transaction_no
       AND sr.shipment_refnum_value = s.shipment_gid
       AND ss.status_code_gid ='SPL.ETA' 
       AND s.location_gid = l.location_gid
     GROUP BY s.shipment_gid, l.location_gid
    ) x
WHERE x.cnt > 1
  AND x.location_gid = :location_gid
  AND x.shipment_gid = :shipment_gid;