PLAN_TABLE_OUTPUT
Plan hash value: 1417783543
 
-------------------------------------------------------------------------------------------------------------------------------------
| Id  | Operation                             | Name                | Rows  | Bytes |TempSpc| Cost (%CPU)| Time     | Pstart| Pstop |
-------------------------------------------------------------------------------------------------------------------------------------
|   0 | INSERT STATEMENT                      |                     |   298K|    25M|       | 14495   (1)| 00:03:23 |       |       |
|   1 |  HASH UNIQUE                          |                     |   298K|    25M|    63M| 14495   (1)| 00:03:23 |       |       |
|*  2 |   FILTER                              |                     |       |       |       |            |          |       |       |
|*  3 |    HASH JOIN                          |                     |   298K|    25M|  8832K| 10634   (1)| 00:02:29 |       |       |
|*  4 |     TABLE ACCESS FULL                 | TMP_CCDB_MAP        |   215K|  6304K|       |   354   (2)| 00:00:05 |       |       |
|   5 |     PARTITION RANGE SINGLE            |                     |   298K|    17M|       |  9029   (1)| 00:02:07 |   KEY |   KEY |
|   6 |      TABLE ACCESS BY LOCAL INDEX ROWID| SRC_FAC_DET         |   298K|    17M|       |  9029   (1)| 00:02:07 |   KEY |   KEY |
|*  7 |       INDEX RANGE SCAN                | SRC_FAC_DET_IDX05   |   149K|       |       |   826   (1)| 00:00:12 |   KEY |   KEY |
|*  8 |    INDEX UNIQUE SCAN                  | TMP_MAP_ROWIDS_UK01 |     1 |    38 |       |     1   (0)| 00:00:01 |       |       |
-------------------------------------------------------------------------------------------------------------------------------------
 
Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------
 
   1 - SEL$1
   4 - SEL$1 / CCDB@SEL$1
   6 - SEL$1 / FAC@SEL$1
   7 - SEL$1 / FAC@SEL$1
   8 - SEL$2 / TMP_MAP_ROWIDS@SEL$2
 
Predicate Information (identified by operation id):
---------------------------------------------------
 
   2 - filter( EXISTS (SELECT 0 FROM "CRES2PROD"."TMP_MAP_ROWIDS" "TMP_MAP_ROWIDS" WHERE "GCDS_TYPE_CD"='F' AND "COB_DT"=:B1 
              AND "ROW_ID"=CHARTOROWID(:B3) AND "RUN_ID"=TO_NUMBER(:B2)))
   3 - access("CCDB"."ID_TYPE_CD"=NVL("FAC"."CPTY_TYPE_CD",:B1) AND "CCDB"."ID_VALUE_CD"=NVL("FAC"."CPTY_CD",:B2) AND 
              "CCDB"."PUSHED_CCDB_ID"=NVL("FAC"."CPTY_CCDB_ID",:B2))
   4 - filter("CCDB"."CCDB_ID" IS NOT NULL)
   7 - access("FAC"."COB_DT"=:B1 AND "FAC"."RUN_ID"=TO_NUMBER(:B2))
   8 - access("RUN_ID"=TO_NUMBER(:B2) AND "ROW_ID"=CHARTOROWID(:B3) AND "COB_DT"=:B1 AND "GCDS_TYPE_CD"='F')
 
Column Projection Information (identified by operation id):
-----------------------------------------------------------
 
   1 - (#keys=4) "CCDB"."CLASS_ID"[NUMBER,22], "CCDB"."CTRY_INC_CD"[VARCHAR2,3], 'N'[1], 
       "PK_GLOBAL_MAP_UTILITIES"."FN_FAC_MATURITY_BAND"("FAC"."LAST_REVIEW_DT","FAC"."RENEWAL_DT","FAC"."MATURITY_DT","FAC"."APPROVA
       L_DT")[22]
   2 - "CCDB"."ID_TYPE_CD"[VARCHAR2,40], NVL("FAC"."CPTY_TYPE_CD",:B1)[40], "CCDB"."ID_VALUE_CD"[VARCHAR2,50], 
       NVL("FAC"."CPTY_CD",:B2)[50], "CCDB"."PUSHED_CCDB_ID"[NUMBER,22], NVL("FAC"."CPTY_CCDB_ID",:B2)[32], 
       "CCDB"."CTRY_INC_CD"[VARCHAR2,3], "CCDB"."CLASS_ID"[NUMBER,22], "CCDB"."CCDB_ID"[NUMBER,22], "FAC".ROWID[ROWID,10], 
       "FAC"."COB_DT"[DATE,7], "FAC"."RUN_ID"[NUMBER,22], "FAC"."CPTY_TYPE_CD"[VARCHAR2,40], "FAC"."CPTY_CD"[VARCHAR2,50], 
       "FAC"."APPROVAL_DT"[DATE,7], "FAC"."MATURITY_DT"[DATE,7], "FAC"."RENEWAL_DT"[DATE,7], "FAC"."LAST_REVIEW_DT"[DATE,7], 
       "FAC"."CPTY_CCDB_ID"[NUMBER,22]
   3 - (#keys=3) "CCDB"."ID_TYPE_CD"[VARCHAR2,40], NVL("FAC"."CPTY_TYPE_CD",:B1)[40], "CCDB"."ID_VALUE_CD"[VARCHAR2,50], 
       NVL("FAC"."CPTY_CD",:B2)[50], "CCDB"."PUSHED_CCDB_ID"[NUMBER,22], NVL("FAC"."CPTY_CCDB_ID",:B2)[32], 
       "CCDB"."CTRY_INC_CD"[VARCHAR2,3], "CCDB"."CLASS_ID"[NUMBER,22], "CCDB"."CCDB_ID"[NUMBER,22], "FAC".ROWID[ROWID,10], 
       "FAC"."COB_DT"[DATE,7], "FAC"."RUN_ID"[NUMBER,22], "FAC"."CPTY_TYPE_CD"[VARCHAR2,40], "FAC"."CPTY_CD"[VARCHAR2,50], 
       "FAC"."APPROVAL_DT"[DATE,7], "FAC"."MATURITY_DT"[DATE,7], "FAC"."RENEWAL_DT"[DATE,7], "FAC"."LAST_REVIEW_DT"[DATE,7], 
       "FAC"."CPTY_CCDB_ID"[NUMBER,22]
   4 - "CCDB"."ID_TYPE_CD"[VARCHAR2,40], "CCDB"."ID_VALUE_CD"[VARCHAR2,50], "CCDB"."PUSHED_CCDB_ID"[NUMBER,22], 
       "CCDB"."CCDB_ID"[NUMBER,22], "CCDB"."CLASS_ID"[NUMBER,22], "CCDB"."CTRY_INC_CD"[VARCHAR2,3]
   5 - "FAC".ROWID[ROWID,10], "FAC"."COB_DT"[DATE,7], "FAC"."RUN_ID"[NUMBER,22], "FAC"."CPTY_TYPE_CD"[VARCHAR2,40], 
       "FAC"."CPTY_CD"[VARCHAR2,50], "FAC"."APPROVAL_DT"[DATE,7], "FAC"."MATURITY_DT"[DATE,7], "FAC"."RENEWAL_DT"[DATE,7], 
       "FAC"."LAST_REVIEW_DT"[DATE,7], "FAC"."CPTY_CCDB_ID"[NUMBER,22]
   6 - "FAC".ROWID[ROWID,10], "FAC"."COB_DT"[DATE,7], "FAC"."RUN_ID"[NUMBER,22], "FAC"."CPTY_TYPE_CD"[VARCHAR2,40], 
       "FAC"."CPTY_CD"[VARCHAR2,50], "FAC"."APPROVAL_DT"[DATE,7], "FAC"."MATURITY_DT"[DATE,7], "FAC"."RENEWAL_DT"[DATE,7], 
       "FAC"."LAST_REVIEW_DT"[DATE,7], "FAC"."CPTY_CCDB_ID"[NUMBER,22]
   7 - "FAC".ROWID[ROWID,10], "FAC"."COB_DT"[DATE,7], "FAC"."RUN_ID"[NUMBER,22]
   8 - "TMP_MAP_ROWIDS".ROWID[ROWID,10], "COB_DT"[DATE,7], "RUN_ID"[NUMBER,22], "ROW_ID"[ROWID,10], 
       "GCDS_TYPE_CD"[VARCHAR2,4]