SELECT *
   FROM (SELECT ROWNUM AS RX, T.*
           FROM (SELECT PVS.POB_VENDOR_SHIPMENT_ID,
                        PVS.POB_VENDOR_SHIPMENT_NUM,
                        PVS.SHIPPING_COMPANY,
                        PVS.DOCK_DOOR_NUM,
                        PVS.TRAILER_NUM,
                        PVS.SHIP_DATE,
                        PVS.PRO_NUM,
                        PVS.POB_SHIP_TERM_ID,
                        PST.SHIP_TERM_NAME,
                        RS.RMA_STAT_NAME,
                        1 AS NO_OF_RECORDS
                   FROM POB_VENDOR_SHIPMENT PVS,
                        POB_VENDOR_SHIPMENT_DTL PVSD,
                        POB_SHIP_TERM PST,
                        POB_SHIP_ADDRESS PSA,
                        RMA_STAT RS,
                        (SELECT POB.POB_IDEN, PL.CONTAINER_LPN
                           FROM POB, POB_LPN PL, POB_VENDOR_SHIPMENT_DTL PVSD
                          WHERE PVSD.CONTAINER_LPN = PL.CONTAINER_LPN
                            AND PL.VENDOR_POB_ID = POB.POB_ID) VENDORNAME
                  WHERE PVSD.POB_VENDOR_SHIPMENT_ID(+) = PVS.POB_VENDOR_SHIPMENT_ID
                    AND PVS.POB_SHIP_TERM_ID = PST.POB_SHIP_TERM_ID(+)
                    AND PSA.POB_SHIP_ADDRESS_ID = PVS.PROCESS_POB_SHIP_ADDRESS_ID
                    AND PSA.POB_ID = 39
                    AND PVS.POB_ID = 39
                    AND RS.RMA_STAT_ID = PVS.SHIPMENT_STATUS
                    AND UPPER(PVS.POB_VENDOR_SHIPMENT_NUM) LIKE UPPER('ARTDS10620%')
                  GROUP BY PVS.POB_VENDOR_SHIPMENT_ID,
                           PVS.POB_VENDOR_SHIPMENT_NUM,
                           PVS.SHIPPING_COMPANY,
                           PVS.DOCK_DOOR_NUM,
                           PVS.TRAILER_NUM,
                           PVS.SHIP_DATE,
                           PVS.PRO_NUM,
                           PVS.POB_SHIP_TERM_ID,
                           PST.SHIP_TERM_NAME,
                           RS.RMA_STAT_NAME
                  ORDER BY PVS.SHIP_DATE) T)
  WHERE rx <= 20
    AND rx > 0

SELECT STATEMENT, GOAL = ALL_ROWS			Cost=569	Cardinality=2241	Bytes=479574
 VIEW	Object owner=MASYS		Cost=569	Cardinality=2241	Bytes=479574
  COUNT					
   VIEW	Object owner=MASYS		Cost=569	Cardinality=2241	Bytes=450441
    SORT GROUP BY			Cost=569	Cardinality=2241	Bytes=331668
     NESTED LOOPS OUTER			Cost=568	Cardinality=2241	Bytes=331668
      NESTED LOOPS OUTER			Cost=567	Cardinality=1391	Bytes=198913
       NESTED LOOPS			Cost=566	Cardinality=1391	Bytes=172484
        HASH JOIN			Cost=564	Cardinality=1391	Bytes=139100
         TABLE ACCESS FULL	Object owner=MASYS	Object name=POB_VENDOR_SHIPMENT	Cost=3	Cardinality=8	Bytes=448
         MERGE JOIN CARTESIAN			Cost=560	Cardinality=3178	Bytes=139832
          NESTED LOOPS			Cost=511	Cardinality=177	Bytes=6195
           NESTED LOOPS			Cost=511	Cardinality=177	Bytes=5487
            TABLE ACCESS FULL	Object owner=MASYS	Object name=POB_VENDOR_SHIPMENT_DTL	Cost=15	Cardinality=165	Bytes=1320
            TABLE ACCESS BY INDEX ROWID	Object owner=MASYS	Object name=POB_LPN	Cost=3	Cardinality=1	Bytes=23
             INDEX RANGE SCAN	Object owner=MASYS	Object name=PL_CLPN_IDX	Cost=2	Cardinality=1	
           INDEX UNIQUE SCAN	Object owner=MASYS	Object name=PKPOB	Cost=0	Cardinality=1	Bytes=4
          BUFFER SORT			Cost=560	Cardinality=18	Bytes=162
           TABLE ACCESS BY INDEX ROWID	Object owner=MASYS	Object name=POB_SHIP_ADDRESS	Cost=9	Cardinality=18	Bytes=162
            INDEX RANGE SCAN	Object owner=MASYS	Object name=XAK1POB_SHIP_ADDRESS	Cost=1	Cardinality=18	
        TABLE ACCESS BY INDEX ROWID	Object owner=MASYS	Object name=RMA_STAT	Cost=1	Cardinality=1	Bytes=24
         INDEX UNIQUE SCAN	Object owner=MASYS	Object name=XPKRMA_STAT	Cost=0	Cardinality=1	
       TABLE ACCESS BY INDEX ROWID	Object owner=MASYS	Object name=POB_SHIP_TERM	Cost=1	Cardinality=1	Bytes=19
        INDEX UNIQUE SCAN	Object owner=MASYS	Object name=XPKPOB_SHIP_TERM	Cost=0	Cardinality=1	
      INDEX RANGE SCAN	Object owner=MASYS	Object name=PVSD_PVSID_IDX	Cost=0	Cardinality=2	Bytes=10