PLAN_TABLE_OUTPUT Plan hash value: 2970467700 ------------------------------------------------------------------------------------------------------------------------------ | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ------------------------------------------------------------------------------------------------------------------------------ | 0 | SELECT STATEMENT | | 120M| 27G| | 11296 (8)| 00:02:16 | |* 1 | HASH JOIN | | 120M| 27G| | 11296 (8)| 00:02:16 | | 2 | VIEW | | 8329 | 211K| | 10010 (2)| 00:02:01 | | 3 | HASH GROUP BY | | 8329 | 341K| | 10010 (2)| 00:02:01 | |* 4 | HASH JOIN OUTER | | 8329 | 341K| | 10009 (2)| 00:02:01 | |* 5 | TABLE ACCESS FULL | N_AGREEMENT | 159 | 3975 | | 12 (0)| 00:00:01 | | 6 | VIEW | | 99628 | 1653K| | 9996 (2)| 00:02:00 | |* 7 | FILTER | | | | | | | | 8 | HASH GROUP BY | | 99628 | 4670K| 114M| 9996 (2)| 00:02:00 | |* 9 | HASH JOIN RIGHT OUTER | | 1992K| 91M| 1112K| 787 (3)| 00:00:10 | |* 10 | TABLE ACCESS FULL | TRN_AGREEMENT_TRANSACTION | 42045 | 615K| | 315 (1)| 00:00:04 | |* 11 | TABLE ACCESS FULL | TRN_AGREEMENT_TRANSACTION | 42045 | 1354K| | 316 (1)| 00:00:04 | |* 12 | HASH JOIN | | 2291K| 478M| | 632 (5)| 00:00:08 | | 13 | VIEW | | 16249 | 634K| | 44 (5)| 00:00:01 | | 14 | TRANSPOSE | | | | | | | | 15 | SORT GROUP BY PIVOT | | 16249 | 238K| | 44 (5)| 00:00:01 | | 16 | TABLE ACCESS FULL | N_EVENT | 16249 | 238K| | 42 (0)| 00:00:01 | |* 17 | HASH JOIN | | 265K| 45M| | 575 (3)| 00:00:07 | | 18 | COLLECTION ITERATOR PICKLER FETCH | F_AGR_TRN_TYPE_INFO | 8168 | 16336 | | 29 (0)| 00:00:01 | |* 19 | HASH JOIN | | 62391 | 10M| | 544 (3)| 00:00:07 | | 20 | COLLECTION ITERATOR PICKLER FETCH | F_AGR_TRN_TYPE_INFO | 8168 | 16336 | | 29 (0)| 00:00:01 | |* 21 | HASH JOIN | | 14651 | 2503K| | 514 (3)| 00:00:07 | | 22 | COLLECTION ITERATOR PICKLER FETCH | F_AGR_TRN_TYPE_INFO | 8168 | 16336 | | 29 (0)| 00:00:01 | |* 23 | HASH JOIN | | 3440 | 581K| | 484 (3)| 00:00:06 | | 24 | COLLECTION ITERATOR PICKLER FETCH | F_AGR_TRN_TYPE_INFO | 8168 | 16336 | | 29 (0)| 00:00:01 | |* 25 | HASH JOIN | | 808 | 134K| | 454 (2)| 00:00:06 | |* 26 | HASH JOIN | | 190 | 32110 | | 425 (3)| 00:00:06 | |* 27 | HASH JOIN | | 190 | 22230 | | 353 (3)| 00:00:05 | |* 28 | HASH JOIN | | 190 | 15580 | | 343 (2)| 00:00:05 | |* 29 | HASH JOIN OUTER | | 159 | 9858 | | 335 (2)| 00:00:05 | |* 30 | HASH JOIN | | 159 | 6360 | | 17 (6)| 00:00:01 | |* 31 | TABLE ACCESS FULL | N_AGREEMENT | 159 | 3975 | | 12 (0)| 00:00:01 | | 32 | TABLE ACCESS FULL | N_COUNTRY | 206 | 3090 | | 4 (0)| 00:00:01 | | 33 | VIEW | | 1897 | 41734 | | 318 (2)| 00:00:04 | | 34 | HASH GROUP BY | | 1897 | 28455 | | 318 (2)| 00:00:04 | |* 35 | TABLE ACCESS FULL | TRN_AGREEMENT_TRANSACTION | 42045 | 615K| | 315 (1)| 00:00:04 | |* 36 | TABLE ACCESS FULL | N_AGREEMENT_AMOUNT | 1903 | 38060 | | 8 (0)| 00:00:01 | | 37 | VIEW | | 1903 | 66605 | | 9 (12)| 00:00:01 | | 38 | HASH GROUP BY | | 1903 | 22836 | | 9 (12)| 00:00:01 | | 39 | TABLE ACCESS FULL | N_AGREEMENT_AMOUNT | 2590 | 31080 | | 8 (0)| 00:00:01 | | 40 | TABLE ACCESS FULL | DAG_PROJECT | 1907 | 99164 | | 71 (0)| 00:00:01 | | 41 | COLLECTION ITERATOR PICKLER FETCH| F_AGR_TRN_TYPE_INFO | 8168 | 16336 | | 29 (0)| 00:00:01 | ------------------------------------------------------------------------------------------------------------------------------ Query Block Name / Object Alias (identified by operation id): ------------------------------------------------------------- 1 - SEL$ECAEF1EB 2 - SEL$8A3193DA / W3Y@SEL$1 3 - SEL$8A3193DA 5 - SEL$8A3193DA / AGR@SEL$7 6 - SEL$0EE6DB63 / from$_subquery$_017@SEL$8 7 - SEL$0EE6DB63 10 - SEL$0EE6DB63 / TRN@SEL$10 11 - SEL$0EE6DB63 / TRN@SEL$9 13 - SEL$335DD26A / from$_subquery$_024@SEL$4 14 - SEL$335DD26A 16 - SEL$335DD26A / N_EVENT@SEL$3 18 - SEL$ECAEF1EB / KOKBF$@SEL$E112F6F0 20 - SEL$ECAEF1EB / KOKBF$@SEL$E112F6F0 22 - SEL$ECAEF1EB / KOKBF$@SEL$E112F6F0 24 - SEL$ECAEF1EB / KOKBF$@SEL$E112F6F0 31 - SEL$ECAEF1EB / AGR@SEL$1 32 - SEL$ECAEF1EB / CNT@SEL$1 33 - SEL$6 / LWD@SEL$1 34 - SEL$6 35 - SEL$6 / TRN@SEL$6 36 - SEL$ECAEF1EB / AMT@SEL$1 37 - SEL$5 / AAM@SEL$1 38 - SEL$5 39 - SEL$5 / N_AGREEMENT_AMOUNT@SEL$5 40 - SEL$ECAEF1EB / PRJ@SEL$1 41 - SEL$ECAEF1EB / KOKBF$@SEL$E112F6F0 Outline Data ------------- /*+ BEGIN_OUTLINE_DATA USE_HASH_AGGREGATION(@"SEL$0EE6DB63") SWAP_JOIN_INPUTS(@"SEL$0EE6DB63" "TRN"@"SEL$10") USE_HASH(@"SEL$0EE6DB63" "TRN"@"SEL$10") LEADING(@"SEL$0EE6DB63" "TRN"@"SEL$9" "TRN"@"SEL$10") FULL(@"SEL$0EE6DB63" "TRN"@"SEL$10") FULL(@"SEL$0EE6DB63" "TRN"@"SEL$9") USE_HASH_AGGREGATION(@"SEL$8A3193DA") PX_JOIN_FILTER(@"SEL$8A3193DA" "from$_subquery$_017"@"SEL$8") USE_HASH(@"SEL$8A3193DA" "from$_subquery$_017"@"SEL$8") LEADING(@"SEL$8A3193DA" "AGR"@"SEL$7" "from$_subquery$_017"@"SEL$8") NO_ACCESS(@"SEL$8A3193DA" "from$_subquery$_017"@"SEL$8") FULL(@"SEL$8A3193DA" "AGR"@"SEL$7") USE_HASH_AGGREGATION(@"SEL$6") FULL(@"SEL$6" "TRN"@"SEL$6") USE_HASH_AGGREGATION(@"SEL$5") FULL(@"SEL$5" "N_AGREEMENT_AMOUNT"@"SEL$5") FULL(@"SEL$335DD26A" "N_EVENT"@"SEL$3") SWAP_JOIN_INPUTS(@"SEL$ECAEF1EB" "W3Y"@"SEL$1") SWAP_JOIN_INPUTS(@"SEL$ECAEF1EB" "from$_subquery$_024"@"SEL$4") SWAP_JOIN_INPUTS(@"SEL$ECAEF1EB" "KOKBF$"@"SEL$E112F6F0") SWAP_JOIN_INPUTS(@"SEL$ECAEF1EB" "KOKBF$"@"SEL$E112F6F0") SWAP_JOIN_INPUTS(@"SEL$ECAEF1EB" "KOKBF$"@"SEL$E112F6F0") SWAP_JOIN_INPUTS(@"SEL$ECAEF1EB" "KOKBF$"@"SEL$E112F6F0") USE_HASH(@"SEL$ECAEF1EB" "W3Y"@"SEL$1") USE_HASH(@"SEL$ECAEF1EB" "from$_subquery$_024"@"SEL$4") USE_HASH(@"SEL$ECAEF1EB" "KOKBF$"@"SEL$E112F6F0") USE_HASH(@"SEL$ECAEF1EB" "KOKBF$"@"SEL$E112F6F0") USE_HASH(@"SEL$ECAEF1EB" "KOKBF$"@"SEL$E112F6F0") USE_HASH(@"SEL$ECAEF1EB" "KOKBF$"@"SEL$E112F6F0") USE_HASH(@"SEL$ECAEF1EB" "KOKBF$"@"SEL$E112F6F0") USE_HASH(@"SEL$ECAEF1EB" "PRJ"@"SEL$1") USE_HASH(@"SEL$ECAEF1EB" "AAM"@"SEL$1") USE_HASH(@"SEL$ECAEF1EB" "AMT"@"SEL$1") USE_HASH(@"SEL$ECAEF1EB" "LWD"@"SEL$1") USE_HASH(@"SEL$ECAEF1EB" "CNT"@"SEL$1") LEADING(@"SEL$ECAEF1EB" "AGR"@"SEL$1" "CNT"@"SEL$1" "LWD"@"SEL$1" "AMT"@"SEL$1" "AAM"@"SEL$1" "PRJ"@"SEL$1" "KOKBF$"@"SEL$E112F6F0" "KOKBF$"@"SEL$E112F6F0" "KOKBF$"@"SEL$E112F6F0" "KOKBF$"@"SEL$E112F6F0" "KOKBF$"@"SEL$E112F6F0" "from$_subquery$_024"@"SEL$4" "W3Y"@"SEL$1") NO_ACCESS(@"SEL$ECAEF1EB" "W3Y"@"SEL$1") NO_ACCESS(@"SEL$ECAEF1EB" "from$_subquery$_024"@"SEL$4") FULL(@"SEL$ECAEF1EB" "KOKBF$"@"SEL$E112F6F0") FULL(@"SEL$ECAEF1EB" "KOKBF$"@"SEL$E112F6F0") FULL(@"SEL$ECAEF1EB" "KOKBF$"@"SEL$E112F6F0") FULL(@"SEL$ECAEF1EB" "KOKBF$"@"SEL$E112F6F0") FULL(@"SEL$ECAEF1EB" "KOKBF$"@"SEL$E112F6F0") FULL(@"SEL$ECAEF1EB" "PRJ"@"SEL$1") NO_ACCESS(@"SEL$ECAEF1EB" "AAM"@"SEL$1") FULL(@"SEL$ECAEF1EB" "AMT"@"SEL$1") NO_ACCESS(@"SEL$ECAEF1EB" "LWD"@"SEL$1") FULL(@"SEL$ECAEF1EB" "CNT"@"SEL$1") FULL(@"SEL$ECAEF1EB" "AGR"@"SEL$1") OUTLINE(@"SEL$E112F6F0") OUTLINE(@"SEL$4") OUTLINE(@"SEL$1") OUTLINE(@"SEL$8") OUTLINE(@"SEL$7") OUTLINE(@"SEL$10") OUTLINE(@"SEL$9") OUTLINE(@"SEL$3") OUTLINE(@"SEL$2") MERGE(@"SEL$E112F6F0") MERGE(@"SEL$E112F6F0") MERGE(@"SEL$E112F6F0") MERGE(@"SEL$E112F6F0") MERGE(@"SEL$E112F6F0") MERGE(@"SEL$4") OUTLINE_LEAF(@"SEL$ECAEF1EB") MERGE(@"SEL$8") OUTLINE_LEAF(@"SEL$8A3193DA") MERGE(@"SEL$10") OUTLINE_LEAF(@"SEL$0EE6DB63") OUTLINE_LEAF(@"SEL$6") OUTLINE_LEAF(@"SEL$5") MERGE(@"SEL$3") OUTLINE_LEAF(@"SEL$335DD26A") NO_COST_XML_QUERY_REWRITE XMLINDEX_REWRITE_IN_SELECT XMLINDEX_REWRITE XML_DML_RWT_STMT FORCE_XML_QUERY_REWRITE ALL_ROWS DB_VERSION('11.2.0.1') OPTIMIZER_FEATURES_ENABLE('11.2.0.1') IGNORE_OPTIM_EMBEDDED_HINTS END_OUTLINE_DATA */ Predicate Information (identified by operation id): --------------------------------------------------- 1 - access("AGR"."AGREEMENT_SERIAL"="W3Y"."AGREEMENT_SERIAL") 4 - access("AGR"."AGREEMENT_SERIAL"="FK_AGREEMENT_SERIAL"(+)) 5 - filter("AGR"."STATUS_ID"=2 AND "AGR"."TYPE_ID"=2 AND "AGR"."SECTOR_ID"=1) 7 - filter("TRN"."VALUE_DATE">=MAX("TRN"."VALUE_DATE")) 9 - access("TRN"."FK_AGREEMENT_SERIAL"="FK_AGREEMENT_SERIAL"(+)) 10 - filter("TRN"."TYPE_ID"(+)=2) 11 - filter("TRN"."TYPE_ID"=2 AND "TRN"."VALUE_DATE"<=SYSDATE@!) 12 - access("AGR"."AGREEMENT_SERIAL"="AGREEMENT_SERIAL") 17 - access("AGR"."AGREEMENT_SERIAL"=SYS_OP_ATG(VALUE(KOKBF$),4,5,2)) 19 - access("AGR"."AGREEMENT_SERIAL"=SYS_OP_ATG(VALUE(KOKBF$),4,5,2)) 21 - access("AGR"."AGREEMENT_SERIAL"=SYS_OP_ATG(VALUE(KOKBF$),4,5,2)) 23 - access("AGR"."AGREEMENT_SERIAL"=SYS_OP_ATG(VALUE(KOKBF$),4,5,2)) 25 - access("AGR"."AGREEMENT_SERIAL"=SYS_OP_ATG(VALUE(KOKBF$),4,5,2)) 26 - access("AGR"."FK_PROJECTNUMBER0"="PRJ"."PROJECT_SERIAL") 27 - access("AGR"."AGREEMENT_SERIAL"="AAM"."FK_AGREEMENT_SERIAL") 28 - access("AGR"."AGREEMENT_SERIAL"="AMT"."FK_AGREEMENT_SERIAL") 29 - access("AGR"."AGREEMENT_SERIAL"="LWD"."FK_AGREEMENT_SERIAL"(+)) 30 - access("AGR"."FK_COUNTRYCODE"="CNT"."CODE") 31 - filter("AGR"."STATUS_ID"=2 AND "AGR"."TYPE_ID"=2 AND "AGR"."SECTOR_ID"=1) 35 - filter("TRN"."TYPE_ID"=2) 36 - filter("AMT"."STATUS"='CURRENT') Column Projection Information (identified by operation id): ----------------------------------------------------------- 1 - (#keys=1) "AGR"."AGREEMENT_SERIAL"[NUMBER,22], "W3Y"."W3Y"[NUMBER,22], "SECOND_INTEREST_DUE_DATE"[DATE,7], "AUTHORIZATION_DATE"[DATE,7], "FIRST_INTEREST_DUE_DATE"[DATE,7], VALUE(A0)[248], "CNT"."SHORT_NAME_E"[VARCHAR2,50], VALUE(A0)[248], "AMT"."VALUE"[NUMBER,22], VALUE(A0)[248], "AAM"."AMOUNT_MODIFICATIONS"[NUMBER,22], VALUE(A0)[248], VALUE(A0)[248], "PRJ"."NAME_ARB"[VARCHAR2,200], "LAST_WITHDRAWAL_DATE"[DATE,7], "AGR"."NUMBER0"[NUMBER,22], "LAST_AMOUNT_DATE"[DATE,7] 2 - "W3Y"."W3Y"[NUMBER,22], "W3Y"."AGREEMENT_SERIAL"[NUMBER,22] 3 - (#keys=3) "FK_AGREEMENT_SERIAL"[NUMBER,22], ROWID[ROWID,10], "AGREEMENT_SERIAL"[NUMBER,22], SUM("WAT")[22] 4 - (#keys=1) "AGR"."AGREEMENT_SERIAL"[NUMBER,22], "FK_AGREEMENT_SERIAL"[NUMBER,22], ROWID[ROWID,10], "WAT"[NUMBER,22] 5 - ROWID[ROWID,10], "AGR"."AGREEMENT_SERIAL"[NUMBER,22] 6 - "WAT"[NUMBER,22], "FK_AGREEMENT_SERIAL"[NUMBER,22] 7 - "TRN"."FK_AGREEMENT_SERIAL"[NUMBER,22], "TRN"."AMOUNT"[NUMBER,22] 8 - (#keys=6) "TRN"."FK_AGREEMENT_SERIAL"[NUMBER,22], ROWID[ROWID,10], "TRN"."TYPE_ID"[NUMBER,22], "TRN"."VALUE_DATE"[DATE,7], "TRN"."FK_AGREEMENT_SERIAL"[NUMBER,22], "TRN"."AMOUNT"[NUMBER,22], MAX("TRN"."VALUE_DATE")[7] 9 - (#keys=1) "FK_AGREEMENT_SERIAL"[NUMBER,22], "TRN"."FK_AGREEMENT_SERIAL"[NUMBER,22], "TRN"."VALUE_DATE"[DATE,7], ROWID[ROWID,10], "TRN"."VALUE_DATE"[DATE,7], "TRN"."TYPE_ID"[NUMBER,22], "TRN"."AMOUNT"[NUMBER,22] 10 - "TRN"."VALUE_DATE"[DATE,7], "TRN"."FK_AGREEMENT_SERIAL"[NUMBER,22] 11 - ROWID[ROWID,10], "TRN"."VALUE_DATE"[DATE,7], "TRN"."TYPE_ID"[NUMBER,22], "TRN"."AMOUNT"[NUMBER,22], "TRN"."FK_AGREEMENT_SERIAL"[NUMBER,22] 12 - (#keys=1) "AGR"."AGREEMENT_SERIAL"[NUMBER,22], "SECOND_INTEREST_DUE_DATE"[DATE,7], "AUTHORIZATION_DATE"[DATE,7], "FIRST_INTEREST_DUE_DATE"[DATE,7], VALUE(A0)[248], "CNT"."SHORT_NAME_E"[VARCHAR2,50], VALUE(A0)[248], "AMT"."VALUE"[NUMBER,22], VALUE(A0)[248], "AAM"."AMOUNT_MODIFICATIONS"[NUMBER,22], VALUE(A0)[248], VALUE(A0)[248], "PRJ"."NAME_ARB"[VARCHAR2,200], "LAST_WITHDRAWAL_DATE"[DATE,7], "AGR"."NUMBER0"[NUMBER,22], "LAST_AMOUNT_DATE"[DATE,7] 13 - "AGREEMENT_SERIAL"[NUMBER,22], "AUTHORIZATION_DATE"[DATE,7], "FIRST_INTEREST_DUE_DATE"[DATE,7], "SECOND_INTEREST_DUE_DATE"[DATE,7] 14 - "FK_AGREEMENT_SERIAL"[NUMBER,22], SYS_OP_PIVOT(MAX("DATE0"),1)[7], SYS_OP_PIVOT(MIN("DATE0"),1)[7], SYS_OP_PIVOT(COUNT(*),1)[22], SYS_OP_PIVOT(MAX("DATE0"),2)[7], SYS_OP_PIVOT(MIN("DATE0"),2)[7], SYS_OP_PIVOT(COUNT(*),2)[22], SYS_OP_PIVOT(MAX("DATE0"),3)[7], SYS_OP_PIVOT(MIN("DATE0"),3)[7], SYS_OP_PIVOT(COUNT(*),3)[22], SYS_OP_PIVOT(MAX("DATE0"),4)[7], SYS_OP_PIVOT(MIN("DATE0"),4)[7], SYS_OP_PIVOT(COUNT(*),4)[22], SYS_OP_PIVOT(MAX("DATE0"),5)[7], SYS_OP_PIVOT(MIN("DATE0"),5)[7], SYS_OP_PIVOT(COUNT(*),5)[22], SYS_OP_PIVOT(MAX("DATE0"),6)[7], SYS_OP_PIVOT(MIN("DATE0"),6)[7], SYS_OP_PIVOT(COUNT(*),6)[22], SYS_OP_PIVOT(MAX("DATE0"),7)[7], SYS_OP_PIVOT(MIN("DATE0"),7)[7], SYS_OP_PIVOT(COUNT(*),7)[22], SYS_OP_PIVOT(MAX("DATE0"),8)[7], SYS_OP_PIVOT(MIN("DATE0"),8)[7], SYS_OP_PIVOT(COUNT(*),8)[22], SYS_OP_PIVOT(MAX("DATE0"),9)[7], SYS_OP_PIVOT(MIN("DATE0"),9)[7], SYS_OP_PIVOT(COUNT(*),9)[22], SYS_OP_PIVOT(MAX("DATE0"),10)[7], SYS_OP_PIVOT(MIN("DATE0"),10)[7], SYS_OP_PIVOT(COUNT(*),10)[22], SYS_OP_PIVOT(MAX("DATE0"),11)[7], SYS_OP_PIVOT(MIN("DATE0"),11)[7], SYS_OP_PIVOT(COUNT(*),11)[22], SYS_OP_PIVOT(MAX("DATE0"),12)[7], SYS_OP_PIVOT(MIN("DATE0"),12)[7], SYS_OP_PIVOT(COUNT(*),12)[22], SYS_OP_PIVOT(MAX("DATE0"),13)[7], SYS_OP_PIVOT(MIN("DATE0"),13)[7], SYS_OP_PIVOT(COUNT(*),13)[22], SYS_OP_PIVOT(MAX("DATE0"),14)[7], SYS_OP_PIVOT(MIN("DATE0"),14)[7], SYS_OP_PIVOT(COUNT(*),14)[22] 15 - (#keys=2) "FK_AGREEMENT_SERIAL"[NUMBER,22], CASE WHEN ("TYPE_ID"=1) THEN 1 WHEN ("TYPE_ID"=2) THEN 2 WHEN ("TYPE_ID"=3) THEN 3 WHEN ("TYPE_ID"=4) THEN 4 WHEN ("TYPE_ID"=5) THEN 5 WHEN ("TYPE_ID"=6) THEN 6 WHEN ("TYPE_ID"=7) THEN 7 WHEN ("TYPE_ID"=8) THEN 8 WHEN ("TYPE_ID"=9) THEN 9 WHEN ("TYPE_ID"=10) THEN 10 WHEN ("TYPE_ID"=11) THEN 11 WHEN ("TYPE_ID"=12) THEN 12 WHEN ("TYPE_ID"=13) THEN 13 WHEN ("TYPE_ID"=14) THEN 14 END [2], COUNT(*)[22], MIN("DATE0")[7], MAX("DATE0")[7] 16 - "DATE0"[DATE,7], "FK_AGREEMENT_SERIAL"[NUMBER,22], "TYPE_ID"[NUMBER,22] 17 - (#keys=1) "AGR"."AGREEMENT_SERIAL"[NUMBER,22], VALUE(A0)[248], "CNT"."SHORT_NAME_E"[VARCHAR2,50], VALUE(A0)[248], "AMT"."VALUE"[NUMBER,22], VALUE(A0)[248], "AAM"."AMOUNT_MODIFICATIONS"[NUMBER,22], VALUE(A0)[248], VALUE(A0)[248], "PRJ"."NAME_ARB"[VARCHAR2,200], "LAST_WITHDRAWAL_DATE"[DATE,7], "AGR"."NUMBER0"[NUMBER,22], "LAST_AMOUNT_DATE"[DATE,7] 18 - VALUE(A0)[248] 19 - (#keys=1) "AGR"."AGREEMENT_SERIAL"[NUMBER,22], VALUE(A0)[248], "AMT"."VALUE"[NUMBER,22], VALUE(A0)[248], "AAM"."AMOUNT_MODIFICATIONS"[NUMBER,22], VALUE(A0)[248], VALUE(A0)[248], "PRJ"."NAME_ARB"[VARCHAR2,200], "LAST_WITHDRAWAL_DATE"[DATE,7], "AGR"."NUMBER0"[NUMBER,22], "LAST_AMOUNT_DATE"[DATE,7], "CNT"."SHORT_NAME_E"[VARCHAR2,50] 20 - VALUE(A0)[248] 21 - (#keys=1) "AGR"."AGREEMENT_SERIAL"[NUMBER,22], VALUE(A0)[248], "AAM"."AMOUNT_MODIFICATIONS"[NUMBER,22], VALUE(A0)[248], VALUE(A0)[248], "PRJ"."NAME_ARB"[VARCHAR2,200], "LAST_WITHDRAWAL_DATE"[DATE,7], "AGR"."NUMBER0"[NUMBER,22], "LAST_AMOUNT_DATE"[DATE,7], "CNT"."SHORT_NAME_E"[VARCHAR2,50], "AMT"."VALUE"[NUMBER,22] 22 - VALUE(A0)[248] 23 - (#keys=1) "AGR"."AGREEMENT_SERIAL"[NUMBER,22], VALUE(A0)[248], VALUE(A0)[248], "PRJ"."NAME_ARB"[VARCHAR2,200], "LAST_WITHDRAWAL_DATE"[DATE,7], "AGR"."NUMBER0"[NUMBER,22], "LAST_AMOUNT_DATE"[DATE,7], "CNT"."SHORT_NAME_E"[VARCHAR2,50], "AMT"."VALUE"[NUMBER,22], "AAM"."AMOUNT_MODIFICATIONS"[NUMBER,22] 24 - VALUE(A0)[248] 25 - (#keys=1) "AGR"."AGREEMENT_SERIAL"[NUMBER,22], "PRJ"."NAME_ARB"[VARCHAR2,200], "LAST_WITHDRAWAL_DATE"[DATE,7], "AGR"."NUMBER0"[NUMBER,22], "LAST_AMOUNT_DATE"[DATE,7], "CNT"."SHORT_NAME_E"[VARCHAR2,50], "AMT"."VALUE"[NUMBER,22], "AAM"."AMOUNT_MODIFICATIONS"[NUMBER,22], VALUE(A0)[248] 26 - (#keys=1) "AGR"."AGREEMENT_SERIAL"[NUMBER,22], "LAST_WITHDRAWAL_DATE"[DATE,7], "AGR"."NUMBER0"[NUMBER,22], "LAST_AMOUNT_DATE"[DATE,7], "CNT"."SHORT_NAME_E"[VARCHAR2,50], "AMT"."VALUE"[NUMBER,22], "AAM"."AMOUNT_MODIFICATIONS"[NUMBER,22], "PRJ"."NAME_ARB"[VARCHAR2,200] 27 - (#keys=1) "AGR"."AGREEMENT_SERIAL"[NUMBER,22], "LAST_WITHDRAWAL_DATE"[DATE,7], "AGR"."NUMBER0"[NUMBER,22], "AGR"."FK_PROJECTNUMBER0"[NUMBER,22], "CNT"."SHORT_NAME_E"[VARCHAR2,50], "AMT"."VALUE"[NUMBER,22], "AAM"."AMOUNT_MODIFICATIONS"[NUMBER,22], "LAST_AMOUNT_DATE"[DATE,7] 28 - (#keys=1) "AGR"."AGREEMENT_SERIAL"[NUMBER,22], "LAST_WITHDRAWAL_DATE"[DATE,7], "AGR"."NUMBER0"[NUMBER,22], "AGR"."FK_PROJECTNUMBER0"[NUMBER,22], "CNT"."SHORT_NAME_E"[VARCHAR2,50], "AMT"."VALUE"[NUMBER,22] 29 - (#keys=1) "AGR"."AGREEMENT_SERIAL"[NUMBER,22], "AGR"."NUMBER0"[NUMBER,22], "AGR"."FK_PROJECTNUMBER0"[NUMBER,22], "CNT"."SHORT_NAME_E"[VARCHAR2,50], "LAST_WITHDRAWAL_DATE"[DATE,7] 30 - (#keys=1) "AGR"."NUMBER0"[NUMBER,22], "AGR"."FK_PROJECTNUMBER0"[NUMBER,22], "AGR"."AGREEMENT_SERIAL"[NUMBER,22], "CNT"."SHORT_NAME_E"[VARCHAR2,50] 31 - "AGR"."NUMBER0"[NUMBER,22], "AGR"."FK_PROJECTNUMBER0"[NUMBER,22], "AGR"."FK_COUNTRYCODE"[NUMBER,22], "AGR"."AGREEMENT_SERIAL"[NUMBER,22] 32 - "CNT"."CODE"[NUMBER,22], "CNT"."SHORT_NAME_E"[VARCHAR2,50] 33 - "LAST_WITHDRAWAL_DATE"[DATE,7], "LWD"."FK_AGREEMENT_SERIAL"[NUMBER,22] 34 - (#keys=1) "TRN"."FK_AGREEMENT_SERIAL"[NUMBER,22], MAX("TRN"."VALUE_DATE")[7] 35 - "TRN"."VALUE_DATE"[DATE,7], "TRN"."FK_AGREEMENT_SERIAL"[NUMBER,22] 36 - "AMT"."VALUE"[NUMBER,22], "AMT"."FK_AGREEMENT_SERIAL"[NUMBER,22] 37 - "AAM"."AMOUNT_MODIFICATIONS"[NUMBER,22], "LAST_AMOUNT_DATE"[DATE,7], "AAM"."FK_AGREEMENT_SERIAL"[NUMBER,22] 38 - (#keys=1) "FK_AGREEMENT_SERIAL"[NUMBER,22], COUNT(*)[22], MAX("DATE0")[7] 39 - "DATE0"[DATE,7], "FK_AGREEMENT_SERIAL"[NUMBER,22] 40 - "PRJ"."PROJECT_SERIAL"[NUMBER,22], "PRJ"."NAME_ARB"[VARCHAR2,200] 41 - VALUE(A0)[248]