SELECT 'Full Import on Terminal'                         move_code, 
       eqpa_container_type, 
       Count(eqpa_container)                             cont, 
       SUM(Nvl(Decode(eqpa_container_size, '20', 1, 
                                           '40', 2), 0)) teus 
FROM   mtu_2009.id_equipment_all_moves 
WHERE  eqpa_company = 'MTU' 
       AND eqpa_move_date BETWEEN '01-JAN-2009' AND '23-SEP-2012' 
       AND eqpa_move_code = 'DSFULL' 
       AND ( eqpa_company, eqpa_container, eqpa_serial_no ) IN 
           (SELECT a.eqpa_company, 
       a.eqpa_container, 
       Max(a.eqpa_serial_no) 
       FROM   mtu_2009.iv_equipment_all_moves_gv a, 
       mtu_2009.id_equipment_control 
       WHERE  a.eqpa_company = 'MTU' 
       AND a.eqpa_company = eqip_company 
       AND a.eqpa_container = eqpa_container 
       AND a.eqpa_container_type = eqpa_container_type 
       AND a.eqpa_move_date <= SYSDATE 
       AND eqpa_soc = 'L' 
       GROUP  BY a.eqpa_company, 
       a.eqpa_container) 
GROUP  BY eqpa_container_type

--------------------------------------------------------------------------------------------------------
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
Plan hash value: 3829536683

--------------------------------------------------------------------------------
-------------------------

| Id  | Operation              | Name                   | Rows  | Bytes |TempSpc
| Cost (%CPU)| Time     |

--------------------------------------------------------------------------------
-------------------------


PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
|   0 | SELECT STATEMENT       |                        |     1 |    69 |
|   141K  (2)| 00:28:24 |

|   1 |  HASH GROUP BY         |                        |     1 |    69 |
|   141K  (2)| 00:28:24 |

|*  2 |   HASH JOIN RIGHT SEMI |                        |     1 |    69 |    25M
|   141K  (2)| 00:28:24 |

|   3 |    VIEW                | VW_NSO_1               |   681K|    17M|
| 82016   (2)| 00:16:25 |

PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------

|   4 |     HASH GROUP BY      |                        |   681K|    24M|   304M
| 82016   (2)| 00:16:25 |

|   5 |      NESTED LOOPS      |                        |  5644K|   204M|
| 57799   (2)| 00:11:34 |

|*  6 |       INDEX UNIQUE SCAN| EQUIPMENT_CONTROL_KEY  |     1 |     4 |
|     0   (0)| 00:00:01 |

|*  7 |       TABLE ACCESS FULL| ID_EQUIPMENT_ALL_MOVES |  5644K|   183M|

PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
| 57799   (2)| 00:11:34 |

|*  8 |    TABLE ACCESS FULL   | ID_EQUIPMENT_ALL_MOVES |   603K|    24M|
| 57114   (1)| 00:11:26 |

--------------------------------------------------------------------------------
-------------------------


Predicate Information (identified by operation id):
---------------------------------------------------

PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------

   2 - access("EQPA_COMPANY"="$nso_col_1" AND "EQPA_CONTAINER"="$nso_col_2" AND
              "EQPA_SERIAL_NO"="$nso_col_3")
   6 - access("EQIP_COMPANY"='MTU')
   7 - filter("EQPA_SOC"='L' AND "EQPA_COMPANY"='MTU' AND "EQPA_MOVE_DATE"<=SYSD
ATE@!)

   8 - filter("EQPA_MOVE_CODE"='DSFULL' AND "EQPA_COMPANY"='MTU' AND "EQPA_MOVE_
DATE">=TO_DATE('

              2009-01-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND "EQPA_MOVE_DAT

PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
E"<=TO_DATE(' 2012-09-23

              00:00:00', 'syyyy-mm-dd hh24:mi:ss'))

26 rows selected.