OPERATION   OBJECT_NAME   OPTIONS   CARDINALITY   COST 
 SELECT STATEMENT 
         1   12793 
    
 VIEW 
 giulio_db.null       1   12793 
        
 Filter Predicates 
            
 DASH.AB_RN=1 
        
 WINDOW 
     SORT PUSHED RANK   388   12793 
            
 Filter Predicates 
                
 ROW_NUMBER() OVER ( PARTITION BY CSDC.CARGO_ID,CSH.DELIVERY_ID,CSH.PARCEL_ID,AB.DEAL_TRACKING_NUM ORDER BY INTERNAL_FUNCTION(AB.INS_NUM) DESC )<=1 
            
 HASH JOIN 
     RIGHT OUTER   388   12793 
                
 Access Predicates 
                    
 URP.RNM_PRODUCT(+)=IPI.VALUE 
                
 TABLE ACCESS 
 giulio_db.USER_RNM_PRODUCT   FULL   423   5 
                
 HASH JOIN 
     RIGHT OUTER   387   12788 
                    
 Access Predicates 
                        
 DI.ID_NUMBER(+)=PD.DELIVERY_TERM_INCOTERM 
                    
 TABLE ACCESS 
 giulio_db.DELIVERY_INCOTERMS   FULL   16   3 
                    
 HASH JOIN 
     RIGHT OUTER   387   12785 
                        
 Access Predicates 
                            
 VLT.ID_NUMBER(+)=CSH.VOLUME_TYPE 
                        
 TABLE ACCESS 
 giulio_db.VOLUME_TYPE   FULL   1   3 
                            
 Filter Predicates 
                                
 VLT.ID_NUMBER(+)=8 
                        
 HASH JOIN 
     RIGHT OUTER   387   12782 
                            
 Access Predicates 
                                
 PARCEL.PARCEL_ID(+)=CSH.PARCEL_ID 
                            
 VIEW 
 giulio_db.null       1   8836 
                                
 Filter Predicates 
                                    
 PARCEL.RN(+)=1 
                                
 WINDOW 
     SORT PUSHED RANK   176632   8836 
                                    
 Filter Predicates 
                                        
 ROW_NUMBER() OVER ( PARTITION BY FEE.FEE_ID,FEE.PARCEL_ID ORDER BY INTERNAL_FUNCTION(FEE.INS_NUM) DESC )<=1 
                                    
 HASH JOIN 
         176632   6893 
                                        
 Access Predicates 
                                            
 AND 
                                                
 INS.INS_NUM=FEE.INS_NUM 
                                                
 INS.PARAM_SEQ_NUM=FEE.PARAM_SEQ_NUM 
                                                
 INS.PRICING_SOURCE_ID=FEE.FEE_SEQ_NUM 
                                        
 TABLE ACCESS 
 giulio_db.INS_FEE_PARAM   FULL   155629   3320 
                                            
 Filter Predicates 
                                                
 FEE.FEE_DEF_ID=2 
                                        
 TABLE ACCESS 
 giulio_db.INS_PRICE   FULL   180926   3039 
                                            
 Filter Predicates 
                                                
 AND 
                                                    
 INS.PRICE>0 
                                                    
 INS.PRICING_VOL>0 
                            
 NESTED LOOPS 
         387   3946 
                                
 NESTED LOOPS 
         581   3946 
                                    
 HASH JOIN 
     RIGHT OUTER   581   3197 
                                        
 Access Predicates 
                                            
 PTY.PARTY_ID(+)=AB.EXTERNAL_BUNIT 
                                        
 TABLE ACCESS 
 giulio_db.PARTY   FULL   2532   12 
                                        
 HASH JOIN 
     RIGHT OUTER   581   3185 
                                            
 Access Predicates 
                                                
 BOOKCO.PARTY_ID(+)=AB.INTERNAL_LENTITY 
                                            
 TABLE ACCESS 
 giulio_db.PARTY   FULL   2532   12 
                                            
 NESTED LOOPS 
         581   3173 
                                                
 NESTED LOOPS 
         595   3173 
                                                    
 NESTED LOOPS 
     OUTER   85   2833 
                                                        
 HASH JOIN 
     RIGHT OUTER   85   2819 
                                                            
 Access Predicates 
                                                                
 CI.ID_NUMBER(+)=PD.DELIVERY_TERM_INCOTERM 
                                                            
 TABLE ACCESS 
 giulio_db.CUSTOM_INCOTERMS   FULL   23   3 
                                                            
 HASH JOIN 
     RIGHT OUTER   85   2816 
                                                                
 Access Predicates 
                                                                    
 SGR.ID_NUMBER(+)=GPP.IDX_SUBGROUP 
                                                                
 TABLE ACCESS 
 giulio_db.IDX_SUBGROUP   FULL   480   6 
                                                                
 HASH JOIN 
         85   2810 
                                                                    
 Access Predicates 
                                                                        
 GPP.LOCATION_ID=CSH.LOCATION_ID 
                                                                    
 HASH JOIN 
     OUTER   85   2742 
                                                                        
 Access Predicates 
                                                                            
 TCV.VSL_ID(+)=CC.VESSEL_ID 
                                                                        
 HASH JOIN 
     OUTER   85   2674 
                                                                            
 Access Predicates 
                                                                                
 CC.CARGO_ID(+)=CSDC.CARGO_ID 
                                                                            
 HASH JOIN 
     OUTER   85   2667 
                                                                                
 Access Predicates 
                                                                                    
 NI.DELIVERY_ID(+)=CSH.DELIVERY_ID 
                                                                                
 HASH JOIN 
     OUTER   69   2599 
                                                                                    
 Access Predicates 
                                                                                        
 AND 
                                                                                            
 IPI.INS_NUM(+)=CSH.INS_NUM 
                                                                                            
 IPI.PARAM_SEQ_NUM(+)=CSH.PARAM_SEQ_NUM 
                                                                                    
 HASH JOIN 
         69   2393 
                                                                                        
 Access Predicates 
                                                                                            
 NAT.ACTIVITY_ID=CSDC.ACTIVITY_ID 
                                                                                        
 TABLE ACCESS 
 giulio_db.NOMINATION_ACTIVITY_TYPE   FULL   74   3 
                                                                                        
 NESTED LOOPS 
         69   2390 
                                                                                            
 NESTED LOOPS 
         69   2390 
                                                                                                
 NESTED LOOPS 
     OUTER   69   2321 
                                                                                                    
 NESTED LOOPS 
         69   2150 
                                                                                                        
 HASH JOIN 
     RIGHT OUTER   400   1750 
                                                                                                            
 Access Predicates 
                                                                                                                
 UNIT_ID(+)=CSH.UNIT 
                                                                                                            
 TABLE ACCESS 
 giulio_db.IDX_UNIT   FULL   29   4 
                                                                                                            
 TABLE ACCESS 
 giulio_db.COMM_SCHEDULE_HEADER   FULL   400   1746 
                                                                                                                
 Filter Predicates 
                                                                                                                    
 AND 
                                                                                                                        
 CSH.VOLUME_TYPE=8 
                                                                                                                        
 CSH.DELIVERY_ID<>0 
                                                                                                                        
 CSH.LAST_UPDATE>=TO_DATE(' 2020-03-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss') 
                                                                                                                        
 CSH.BAV_FLAG=1 
                                                                                                        
 TABLE ACCESS 
 giulio_db.PARCEL_DATA   BY INDEX ROWID   1   1 
                                                                                                            
 Filter Predicates 
                                                                                                                
 PD.PARAM_SEQ_NUM=CSH.PARAM_SEQ_NUM 
                                                                                                            
 INDEX 
 giulio_db.PARCEL_DATA_IDX   UNIQUE SCAN   1   0 
                                                                                                                
 Access Predicates 
                                                                                                                    
 AND 
                                                                                                                        
 PD.PARCEL_ID=CSH.PARCEL_ID 
                                                                                                                        
 PD.INS_NUM=CSH.INS_NUM 
                                                                                                    
 TABLE ACCESS 
 giulio_db.TSD_MEASURE   BY INDEX ROWID BATCHED   1   3 
                                                                                                        
 Filter Predicates 
                                                                                                            
 TSD.TSD_MEASURE_TYPE(+)=2 
                                                                                                        
 INDEX 
 giulio_db.TSD_MEASURE_IDX1   RANGE SCAN   1   2 
                                                                                                            
 Access Predicates 
                                                                                                                
 AND 
                                                                                                                    
 TSD.SCHEDULE_ID(+)=CSH.SCHEDULE_ID 
                                                                                                                    
 TSD.MEASUREMENT_TYPE(+)=3 
                                                                                                                    
 TSD.INS_NUM(+)=CSH.INS_NUM 
                                                                                                                    
 TSD.PARAM_SEQ_NUM(+)=CSH.PARAM_SEQ_NUM 
                                                                                                            
 Filter Predicates 
                                                                                                                
 AND 
                                                                                                                    
 TSD.INS_NUM(+)=CSH.INS_NUM 
                                                                                                                    
 TSD.MEASUREMENT_TYPE(+)=3 
                                                                                                                    
 TSD.TSD_DELIVERY_TICKET_ID(+)<>0 
                                                                                                                    
 TSD.PARAM_SEQ_NUM(+)=CSH.PARAM_SEQ_NUM 
                                                                                                
 INDEX 
 giulio_db.COMM_SCHED_DELIV_CMOTION_IDX   UNIQUE SCAN   1   0 
                                                                                                    
 Access Predicates 
                                                                                                        
 CSH.DELIVERY_ID=CSDC.DELIVERY_ID 
                                                                                                    
 Filter Predicates 
                                                                                                        
 CSDC.DELIVERY_ID<>0 
                                                                                            
 TABLE ACCESS 
 giulio_db.COMM_SCHED_DELIVERY_CMOTION   BY INDEX ROWID   1   1 
                                                                                    
 TABLE ACCESS 
 giulio_db.INS_PARAMETER_INFO   FULL   7848   205 
                                                                                        
 Filter Predicates 
                                                                                            
 IPI.TYPE_ID(+)=20078 
                                                                                
 TABLE ACCESS 
 giulio_db.NOM_INFO   FULL   4826   68 
                                                                                    
 Filter Predicates 
                                                                                        
 AND 
                                                                                            
 NI.TYPE_ID(+)=20003 
                                                                                            
 NI.DELIVERY_ID(+)<>0 
                                                                            
 TABLE ACCESS 
 giulio_db.CARGO_CARRIAGE   FULL   1571   7 
                                                                        
 TABLE ACCESS 
 giulio_db.TRANSPORT_CARRIAGE_VESSEL   FULL   8704   68 
                                                                    
 TABLE ACCESS 
 giulio_db.GAS_PHYS_LOCATION   FULL   5305   68 
                                                        
 TABLE ACCESS 
 giulio_db.TSD_DELIVERY_TICKET   BY INDEX ROWID   1   1 
                                                            
 Filter Predicates 
                                                                
 TDT.IS_ACTUAL_TICKET(+)=1 
                                                            
 INDEX 
 giulio_db.TSD_DELIVERY_TICKET_IDX1   UNIQUE SCAN   1   0 
                                                                
 Access Predicates 
                                                                    
 AND 
                                                                        
 TDT.SCHEDULE_ID(+)=TSD.SCHEDULE_ID 
                                                                        
 TSD.TSD_DELIVERY_TICKET_ID=TDT.ID_NUMBER(+) 
                                                    
 INDEX 
 giulio_db.AB_TRAN_INDEX4   RANGE SCAN   7   2 
                                                        
 Access Predicates 
                                                            
 AB.INS_NUM=CSH.INS_NUM 
                                                
 TABLE ACCESS 
 giulio_db.AB_TRAN   BY INDEX ROWID   7   4 
                                    
 INDEX 
 giulio_db.GAS_PHYS_PARAM_IDX2   RANGE SCAN   1   1 
                                        
 Access Predicates 
                                            
 GP.INS_NUM=AB.INS_NUM 
                                
 TABLE ACCESS 
 giulio_db.GAS_PHYS_PARAM   BY INDEX ROWID   1   2 
    
 Other XML 
        
 {info} 
            
 info type="db_version" 
                
 12.1.0.2 
            
 info type="parse_schema" 
            
 "giulio_db" 
            
 info type="plan_hash_full" 
                
 1361085852 
            
 info type="plan_hash" 
                
 4249987402 
            
 info type="plan_hash_2" 
                
 1361085852 
            
 {hint} 
                
 USE_HASH(@"SEL$E935AD9C" "INS"@"SEL$23") 
                
 LEADING(@"SEL$E935AD9C" "FEE"@"SEL$23" "INS"@"SEL$23") 
                
 FULL(@"SEL$E935AD9C" "INS"@"SEL$23") 
                
 FULL(@"SEL$E935AD9C" "FEE"@"SEL$23") 
                
 SWAP_JOIN_INPUTS(@"SEL$32B5AC86" "URP"@"SEL$16") 
                
 SWAP_JOIN_INPUTS(@"SEL$32B5AC86" "DI"@"SEL$10") 
                
 SWAP_JOIN_INPUTS(@"SEL$32B5AC86" "VLT"@"SEL$18") 
                
 SWAP_JOIN_INPUTS(@"SEL$32B5AC86" "PARCEL"@"SEL$22") 
                
 SWAP_JOIN_INPUTS(@"SEL$32B5AC86" "PTY"@"SEL$20") 
                
 SWAP_JOIN_INPUTS(@"SEL$32B5AC86" "BOOKCO"@"SEL$21") 
                
 SWAP_JOIN_INPUTS(@"SEL$32B5AC86" "CI"@"SEL$9") 
                
 SWAP_JOIN_INPUTS(@"SEL$32B5AC86" "SGR"@"SEL$19") 
                
 SWAP_JOIN_INPUTS(@"SEL$32B5AC86" "NAT"@"SEL$4") 
                
 SWAP_JOIN_INPUTS(@"SEL$32B5AC86" "IDX_UNIT"@"SEL$17") 
                
 USE_HASH(@"SEL$32B5AC86" "URP"@"SEL$16") 
                
 USE_HASH(@"SEL$32B5AC86" "DI"@"SEL$10") 
                
 USE_HASH(@"SEL$32B5AC86" "VLT"@"SEL$18") 
                
 USE_HASH(@"SEL$32B5AC86" "PARCEL"@"SEL$22") 
                
 NLJ_BATCHING(@"SEL$32B5AC86" "GP"@"SEL$15") 
                
 USE_NL(@"SEL$32B5AC86" "GP"@"SEL$15") 
                
 USE_HASH(@"SEL$32B5AC86" "PTY"@"SEL$20") 
                
 USE_HASH(@"SEL$32B5AC86" "BOOKCO"@"SEL$21") 
                
 NLJ_BATCHING(@"SEL$32B5AC86" "AB"@"SEL$2") 
                
 USE_NL(@"SEL$32B5AC86" "AB"@"SEL$2") 
                
 USE_NL(@"SEL$32B5AC86" "TDT"@"SEL$14") 
                
 USE_HASH(@"SEL$32B5AC86" "CI"@"SEL$9") 
                
 USE_HASH(@"SEL$32B5AC86" "SGR"@"SEL$19") 
                
 USE_HASH(@"SEL$32B5AC86" "GPP"@"SEL$5") 
                
 USE_HASH(@"SEL$32B5AC86" "TCV"@"SEL$12") 
                
 USE_HASH(@"SEL$32B5AC86" "CC"@"SEL$11") 
                
 USE_HASH(@"SEL$32B5AC86" "NI"@"SEL$6") 
                
 USE_HASH(@"SEL$32B5AC86" "IPI"@"SEL$7") 
                
 USE_HASH(@"SEL$32B5AC86" "NAT"@"SEL$4") 
                
 NLJ_BATCHING(@"SEL$32B5AC86" "CSDC"@"SEL$3") 
                
 USE_NL(@"SEL$32B5AC86" "CSDC"@"SEL$3") 
                
 USE_NL(@"SEL$32B5AC86" "TSD"@"SEL$13") 
                
 USE_NL(@"SEL$32B5AC86" "PD"@"SEL$8") 
                
 USE_HASH(@"SEL$32B5AC86" "IDX_UNIT"@"SEL$17") 
                
 LEADING(@"SEL$32B5AC86" "CSH"@"SEL$2" "IDX_UNIT"@"SEL$17" "PD"@"SEL$8" "TSD"@"SEL$13" "CSDC"@"SEL$3" "NAT"@"SEL$4" "IPI"@"SEL$7" "NI"@"SEL$6" "CC"@"SEL$11" "TCV"@"SEL$12" "GPP"@"SEL$5" "SGR"@"SEL$19" "CI"@"SEL$9" "TDT"@"SEL$14" "AB"@"SEL$2" "BOOKCO"@"SEL$21" "PTY"@"SEL$20" "GP"@"SEL$15" "PARCEL"@"SEL$22" "VLT"@"SEL$18" "DI"@"SEL$10" "URP"@"SEL$16") 
                
 FULL(@"SEL$32B5AC86" "URP"@"SEL$16") 
                
 FULL(@"SEL$32B5AC86" "DI"@"SEL$10") 
                
 FULL(@"SEL$32B5AC86" "VLT"@"SEL$18") 
                
 NO_ACCESS(@"SEL$32B5AC86" "PARCEL"@"SEL$22") 
                
 INDEX(@"SEL$32B5AC86" "GP"@"SEL$15" ("GAS_PHYS_PARAM"."INS_NUM" "GAS_PHYS_PARAM"."PARAM_SEQ_NUM")) 
                
 FULL(@"SEL$32B5AC86" "PTY"@"SEL$20") 
                
 FULL(@"SEL$32B5AC86" "BOOKCO"@"SEL$21") 
                
 INDEX(@"SEL$32B5AC86" "AB"@"SEL$2" ("AB_TRAN"."INS_NUM" "AB_TRAN"."TRAN_TYPE" "AB_TRAN"."TRAN_STATUS")) 
                
 INDEX_RS_ASC(@"SEL$32B5AC86" "TDT"@"SEL$14" ("TSD_DELIVERY_TICKET"."SCHEDULE_ID" "TSD_DELIVERY_TICKET"."ID_NUMBER")) 
                
 FULL(@"SEL$32B5AC86" "CI"@"SEL$9") 
                
 FULL(@"SEL$32B5AC86" "SGR"@"SEL$19") 
                
 FULL(@"SEL$32B5AC86" "GPP"@"SEL$5") 
                
 FULL(@"SEL$32B5AC86" "TCV"@"SEL$12") 
                
 FULL(@"SEL$32B5AC86" "CC"@"SEL$11") 
                
 FULL(@"SEL$32B5AC86" "NI"@"SEL$6") 
                
 FULL(@"SEL$32B5AC86" "IPI"@"SEL$7") 
                
 FULL(@"SEL$32B5AC86" "NAT"@"SEL$4") 
                
 INDEX(@"SEL$32B5AC86" "CSDC"@"SEL$3" ("COMM_SCHED_DELIVERY_CMOTION"."DELIVERY_ID")) 
                
 BATCH_TABLE_ACCESS_BY_ROWID(@"SEL$32B5AC86" "TSD"@"SEL$13") 
                
 INDEX_RS_ASC(@"SEL$32B5AC86" "TSD"@"SEL$13" ("TSD_MEASURE"."SCHEDULE_ID" "TSD_MEASURE"."TSD_DELIVERY_TICKET_ID" "TSD_MEASURE"."MEASUREMENT_TYPE" "TSD_MEASURE"."INS_NUM" "TSD_MEASURE"."PARAM_SEQ_NUM")) 
                
 INDEX_RS_ASC(@"SEL$32B5AC86" "PD"@"SEL$8" ("PARCEL_DATA"."PARCEL_ID" "PARCEL_DATA"."INS_NUM")) 
                
 FULL(@"SEL$32B5AC86" "IDX_UNIT"@"SEL$17") 
                
 FULL(@"SEL$32B5AC86" "CSH"@"SEL$2") 
                
 NO_ACCESS(@"SEL$1" "DASH"@"SEL$1") 
                
 OUTLINE(@"SEL$2") 
                
 OUTLINE(@"SEL$3") 
                
 MERGE(@"SEL$2") 
                
 OUTLINE(@"SEL$64EAE176") 
                
 OUTLINE(@"SEL$4") 
                
 MERGE(@"SEL$64EAE176") 
                
 OUTLINE(@"SEL$54D64B3C") 
                
 OUTLINE(@"SEL$5") 
                
 OUTLINE(@"SEL$6") 
                
 OUTLINE(@"SEL$7") 
                
 MERGE(@"SEL$54D64B3C") 
                
 OUTLINE(@"SEL$A4378260") 
                
 ANSI_REARCH(@"SEL$6") 
                
 OUTLINE(@"SEL$9430E53D") 
                
 ANSI_REARCH(@"SEL$7") 
                
 OUTLINE(@"SEL$463D4B3F") 
                
 MERGE(@"SEL$A4378260") 
                
 OUTLINE(@"SEL$BE56E27A") 
                
 ANSI_REARCH(@"SEL$463D4B3F") 
                
 OUTLINE(@"SEL$DA4F3EA6") 
                
 OUTLINE(@"SEL$8") 
                
 MERGE(@"SEL$BE56E27A") 
                
 OUTLINE(@"SEL$982588C2") 
                
 ANSI_REARCH(@"SEL$8") 
                
 OUTLINE(@"SEL$6EB9CD62") 
                
 OUTLINE(@"SEL$9") 
                
 OUTLINE(@"SEL$10") 
                
 MERGE(@"SEL$982588C2") 
                
 OUTLINE(@"SEL$9E76C603") 
                
 ANSI_REARCH(@"SEL$9") 
                
 OUTLINE(@"SEL$AE1AA755") 
                
 ANSI_REARCH(@"SEL$10") 
                
 OUTLINE(@"SEL$5C036595") 
                
 OUTLINE(@"SEL$11") 
                
 MERGE(@"SEL$9E76C603") 
                
 OUTLINE(@"SEL$D52285CC") 
                
 ANSI_REARCH(@"SEL$5C036595") 
                
 OUTLINE(@"SEL$281D277C") 
                
 ANSI_REARCH(@"SEL$11") 
                
 OUTLINE(@"SEL$259CA972") 
                
 OUTLINE(@"SEL$12") 
                
 MERGE(@"SEL$D52285CC") 
                
 OUTLINE(@"SEL$B0378801") 
                
 ANSI_REARCH(@"SEL$259CA972") 
                
 OUTLINE(@"SEL$DE60A506") 
                
 ANSI_REARCH(@"SEL$12") 
                
 OUTLINE(@"SEL$18CE02B5") 
                
 OUTLINE(@"SEL$13") 
                
 MERGE(@"SEL$B0378801") 
                
 OUTLINE(@"SEL$7D773B2D") 
                
 ANSI_REARCH(@"SEL$18CE02B5") 
                
 OUTLINE(@"SEL$4F58EFE9") 
                
 ANSI_REARCH(@"SEL$13") 
                
 OUTLINE(@"SEL$7DDBFD69") 
                
 OUTLINE(@"SEL$14") 
                
 MERGE(@"SEL$7D773B2D") 
                
 OUTLINE(@"SEL$FA5DE5E1") 
                
 ANSI_REARCH(@"SEL$7DDBFD69") 
                
 OUTLINE(@"SEL$011E636E") 
                
 ANSI_REARCH(@"SEL$14") 
                
 OUTLINE(@"SEL$F1B44A4E") 
                
 MERGE(@"SEL$FA5DE5E1") 
                
 OUTLINE(@"SEL$145D205B") 
                
 ANSI_REARCH(@"SEL$F1B44A4E") 
                
 OUTLINE(@"SEL$8B46FAF6") 
                
 OUTLINE(@"SEL$15") 
                
 MERGE(@"SEL$145D205B") 
                
 OUTLINE(@"SEL$666D9034") 
                
 ANSI_REARCH(@"SEL$15") 
                
 OUTLINE(@"SEL$E56837AD") 
                
 OUTLINE(@"SEL$16") 
                
 OUTLINE(@"SEL$17") 
                
 MERGE(@"SEL$666D9034") 
                
 OUTLINE(@"SEL$B279ED4C") 
                
 ANSI_REARCH(@"SEL$16") 
                
 OUTLINE(@"SEL$49B35EF2") 
                
 ANSI_REARCH(@"SEL$17") 
                
 OUTLINE(@"SEL$8B42D3F7") 
                
 OUTLINE(@"SEL$18") 
                
 MERGE(@"SEL$B279ED4C") 
                
 OUTLINE(@"SEL$9BE11EA0") 
                
 ANSI_REARCH(@"SEL$8B42D3F7") 
                
 OUTLINE(@"SEL$E45C0F26") 
                
 ANSI_REARCH(@"SEL$18") 
                
 OUTLINE(@"SEL$0E8BD44E") 
                
 OUTLINE(@"SEL$19") 
                
 MERGE(@"SEL$9BE11EA0") 
                
 OUTLINE(@"SEL$6F32E129") 
                
 ANSI_REARCH(@"SEL$0E8BD44E") 
                
 OUTLINE(@"SEL$80715F34") 
                
 ANSI_REARCH(@"SEL$19") 
                
 OUTLINE(@"SEL$BC68FEB1") 
                
 OUTLINE(@"SEL$20") 
                
 MERGE(@"SEL$6F32E129") 
                
 OUTLINE(@"SEL$256F2E8E") 
                
 ANSI_REARCH(@"SEL$BC68FEB1") 
                
 OUTLINE(@"SEL$A01E021C") 
                
 ANSI_REARCH(@"SEL$20") 
                
 OUTLINE(@"SEL$0ACCE20D") 
                
 OUTLINE(@"SEL$21") 
                
 MERGE(@"SEL$256F2E8E") 
                
 OUTLINE(@"SEL$730B592B") 
                
 ANSI_REARCH(@"SEL$0ACCE20D") 
                
 OUTLINE(@"SEL$5072BA17") 
                
 ANSI_REARCH(@"SEL$21") 
                
 OUTLINE(@"SEL$CD8D34D0") 
                
 OUTLINE(@"SEL$22") 
                
 MERGE(@"SEL$730B592B") 
                
 OUTLINE(@"SEL$CEDFF275") 
                
 ANSI_REARCH(@"SEL$CD8D34D0") 
                
 OUTLINE(@"SEL$C6966259") 
                
 ANSI_REARCH(@"SEL$22") 
                
 OUTLINE(@"SEL$F096DC0D") 
                
 MERGE(@"SEL$CEDFF275") 
                
 OUTLINE(@"SEL$2A851FBF") 
                
 ANSI_REARCH(@"SEL$F096DC0D") 
                
 OUTLINE(@"SEL$EE4B0203") 
                
 OUTLINE(@"SEL$25") 
                
 MERGE(@"SEL$2A851FBF") 
                
 OUTLINE(@"SEL$E466F6B0") 
                
 ANSI_REARCH(@"SEL$25") 
                
 OUTLINE(@"SEL$9D42376B") 
                
 OUTLINE(@"SEL$23") 
                
 OUTLINE(@"SEL$24") 
                
 OUTLINE_LEAF(@"SEL$1") 
                
 MERGE(@"SEL$E466F6B0") 
                
 OUTLINE_LEAF(@"SEL$32B5AC86") 
                
 MERGE(@"SEL$23") 
                
 OUTLINE_LEAF(@"SEL$E935AD9C") 
                
 ALL_ROWS 
                
 OPT_PARAM('_optimizer_nlj_hj_adaptive_join' 'false') 
                
 OPT_PARAM('_optimizer_gather_feedback' 'false') 
                
 OPT_PARAM('_optimizer_strans_adaptive_pruning' 'false') 
                
 OPT_PARAM('_optimizer_adaptive_plans' 'false') 
                
 OPT_PARAM('_optimizer_dsdir_usage_control' 0) 
                
 OPT_PARAM('_px_adaptive_dist_method' 'off') 
                
 OPT_PARAM('_optimizer_use_feedback' 'false') 
                
 DB_VERSION('12.1.0.2') 
                
 OPTIMIZER_FEATURES_ENABLE('12.1.0.2') 
                
 IGNORE_OPTIM_EMBEDDED_HINTS