----------------------------------------------------------------------------------------------------------------------------------------------
| Id  | Operation                       | Name                  | Starts | E-Rows | A-Rows |   A-Time   | Buffers |  OMem |  1Mem | Used-Mem |
----------------------------------------------------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT                |                       |      1 |        |      1 |00:00:04.40 |    1008K|       |       |          |
|   1 |  SORT AGGREGATE                 |                       |      1 |      1 |      1 |00:00:04.40 |    1008K|       |       |          |
|   2 |   NESTED LOOPS OUTER            |                       |      1 |     37 |     79 |00:00:04.37 |    1008K|       |       |          |
|*  3 |    HASH JOIN OUTER              |                       |      1 |     37 |     79 |00:00:04.37 |    1008K|  2981K|  2981K| 1015K (0)|
|   4 |     NESTED LOOPS                |                       |      1 |     37 |     79 |00:00:00.94 |    1004K|       |       |          |
|   5 |      NESTED LOOPS               |                       |      1 |    100K|    641K|00:00:00.57 |    2508 |       |       |          |
|   6 |       TABLE ACCESS STORAGE FULL | TMP0_STRATEGY         |      1 |    215 |    215 |00:00:00.01 |       7 |  1025K|  1025K|          |
|*  7 |       INDEX RANGE SCAN          | XIE3STL_ITEM_HDR      |    215 |    469 |    641K|00:00:00.44 |    2501 |  1025K|  1025K|          |
|*  8 |      TABLE ACCESS BY INDEX ROWID| STL_ITEM_HDR          |    641K|      1 |     79 |00:00:03.81 |    1002K|       |       |          |
|   9 |     TABLE ACCESS STORAGE FULL   | OPS_OBLIGATION_DETAIL |      1 |  90983 |  90983 |00:00:00.02 |    3527 |  1025K|  1025K|          |
|* 10 |    INDEX UNIQUE SCAN            | XPKOPS_TRANSFER       |     79 |      1 |     79 |00:00:00.01 |      47 |  1025K|  1025K|          |
----------------------------------------------------------------------------------------------------------------------------------------------

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

   3 - access("STL"."DELIVERY_REF"=TO_CHAR("OPS"."OBLIGATION_DETAIL_NUM"))
   7 - access("STL"."STRATEGY_NUM"="S_NUM")
   8 - filter((INTERNAL_FUNCTION("STL"."CARGO_NUM") AND INTERNAL_FUNCTION("STL"."ITEM_STATUS_IND") AND
              INTERNAL_FUNCTION("STL"."INTERNAL_COMPANY_NUM")))
  10 - access("OT"."TRANSFER_NUM"=CASE  WHEN (("OPS"."TRANSFER_NUM" IS NULL) AND ("STL"."DELIVERY_TYPE_IND"=0)) THEN
              "STL"."DELIVERY_NUM" ELSE "OPS"."TRANSFER_NUM" END )

Note
-----
   - dynamic statistics used: dynamic sampling (level=4)