ID PID OPERATION	OPTIONS	            OBJECT_NAME	    
----------------------------------------------------------------
0 |   |SELECT STATEMENT|		    |	           
1 | 0 |SORT	       |GROUP BY	    |	            
2 | 1 |VIEW	       |		    |                            
3 | 2 |FILTER	       |		    |
4 | 3 |SORT	       |GROUP BY	    |	            
5 | 4 |FILTER	       |  		    |
6 | 5 |TABLE ACCESS    |BY LOCAL INDEX ROWID|COMBINED_RECEIPTS
7 | 6 |NESTED LOOPS    |		    |
8 | 7 |TABLE ACCESS    |FULL	            |RECEIPTS_FACT
9 | 7 |INDEX	       |RANGE SCAN	    |CR_PNR_INDX