tables.groovy

def tabMap = ["AdditnlCondtns1":65,
"AdditnlCondtns2":65,
"DescrGoodsServcs1":100,
"DescrGoodsServcs2":100,
"DocsReqd1":100,
"DocsReqd2":100,
"InstrToPayBank":100,
"ShipPeriod":60]

def i = 0

def printSentence = { t, str -> 
   for(xx in 1..t.value){
        i = xx
        print(str.toString())
        if (i!=(t.value)){
            print(",\n")
        }
    }
 }

for (t in tabMap){
    print('select\n')
    printSentence(t, "    ${->t.key}_${->i}.line ${->t.key}_${->i}");
    print('\n    from CreditDocumentaire c,\n')
    printSentence(t, "        (select line, credit_number from ${->t.key} where linenumber=${->i}) ${->t.key}_${->i}");
    print('\n    where\n')
    printSentence(t, "        c.credit_number =  ${->t.key}_${->i}.credit_number(+)");    
    print(';\n\n')
    
}

tables.sql

...

select
    ShipPeriod_1.line ShipPeriod_1,
    ShipPeriod_2.line ShipPeriod_2,
    ShipPeriod_3.line ShipPeriod_3,
    ShipPeriod_4.line ShipPeriod_4,
    ShipPeriod_5.line ShipPeriod_5,
    ShipPeriod_6.line ShipPeriod_6,
    ShipPeriod_7.line ShipPeriod_7,
    ShipPeriod_8.line ShipPeriod_8,
    ShipPeriod_9.line ShipPeriod_9,
    ShipPeriod_10.line ShipPeriod_10,
    ShipPeriod_11.line ShipPeriod_11,
    ShipPeriod_12.line ShipPeriod_12,
    ShipPeriod_13.line ShipPeriod_13,
    ShipPeriod_14.line ShipPeriod_14,
    ShipPeriod_15.line ShipPeriod_15,
    ShipPeriod_16.line ShipPeriod_16,
    ShipPeriod_17.line ShipPeriod_17,
    ShipPeriod_18.line ShipPeriod_18,
    ShipPeriod_19.line ShipPeriod_19,
    ShipPeriod_20.line ShipPeriod_20,
    ShipPeriod_21.line ShipPeriod_21,
    ShipPeriod_22.line ShipPeriod_22,
    ShipPeriod_23.line ShipPeriod_23,
    ShipPeriod_24.line ShipPeriod_24,
    ShipPeriod_25.line ShipPeriod_25,
    ShipPeriod_26.line ShipPeriod_26,
    ShipPeriod_27.line ShipPeriod_27,
    ShipPeriod_28.line ShipPeriod_28,
    ShipPeriod_29.line ShipPeriod_29,
    ShipPeriod_30.line ShipPeriod_30,
    ShipPeriod_31.line ShipPeriod_31,
    ShipPeriod_32.line ShipPeriod_32,
    ShipPeriod_33.line ShipPeriod_33,
    ShipPeriod_34.line ShipPeriod_34,
    ShipPeriod_35.line ShipPeriod_35,
    ShipPeriod_36.line ShipPeriod_36,
    ShipPeriod_37.line ShipPeriod_37,
    ShipPeriod_38.line ShipPeriod_38,
    ShipPeriod_39.line ShipPeriod_39,
    ShipPeriod_40.line ShipPeriod_40,
    ShipPeriod_41.line ShipPeriod_41,
    ShipPeriod_42.line ShipPeriod_42,
    ShipPeriod_43.line ShipPeriod_43,
    ShipPeriod_44.line ShipPeriod_44,
    ShipPeriod_45.line ShipPeriod_45,
    ShipPeriod_46.line ShipPeriod_46,
    ShipPeriod_47.line ShipPeriod_47,
    ShipPeriod_48.line ShipPeriod_48,
    ShipPeriod_49.line ShipPeriod_49,
    ShipPeriod_50.line ShipPeriod_50,
    ShipPeriod_51.line ShipPeriod_51,
    ShipPeriod_52.line ShipPeriod_52,
    ShipPeriod_53.line ShipPeriod_53,
    ShipPeriod_54.line ShipPeriod_54,
    ShipPeriod_55.line ShipPeriod_55,
    ShipPeriod_56.line ShipPeriod_56,
    ShipPeriod_57.line ShipPeriod_57,
    ShipPeriod_58.line ShipPeriod_58,
    ShipPeriod_59.line ShipPeriod_59,
    ShipPeriod_60.line ShipPeriod_60
    from CreditDocumentaire c,
        (select line, credit_number from ShipPeriod where linenumber=1) ShipPeriod_1,
        (select line, credit_number from ShipPeriod where linenumber=2) ShipPeriod_2,
        (select line, credit_number from ShipPeriod where linenumber=3) ShipPeriod_3,
        (select line, credit_number from ShipPeriod where linenumber=4) ShipPeriod_4,
        (select line, credit_number from ShipPeriod where linenumber=5) ShipPeriod_5,
        (select line, credit_number from ShipPeriod where linenumber=6) ShipPeriod_6,
        (select line, credit_number from ShipPeriod where linenumber=7) ShipPeriod_7,
        (select line, credit_number from ShipPeriod where linenumber=8) ShipPeriod_8,
        (select line, credit_number from ShipPeriod where linenumber=9) ShipPeriod_9,
        (select line, credit_number from ShipPeriod where linenumber=10) ShipPeriod_10,
        (select line, credit_number from ShipPeriod where linenumber=11) ShipPeriod_11,
        (select line, credit_number from ShipPeriod where linenumber=12) ShipPeriod_12,
        (select line, credit_number from ShipPeriod where linenumber=13) ShipPeriod_13,
        (select line, credit_number from ShipPeriod where linenumber=14) ShipPeriod_14,
        (select line, credit_number from ShipPeriod where linenumber=15) ShipPeriod_15,
        (select line, credit_number from ShipPeriod where linenumber=16) ShipPeriod_16,
        (select line, credit_number from ShipPeriod where linenumber=17) ShipPeriod_17,
        (select line, credit_number from ShipPeriod where linenumber=18) ShipPeriod_18,
        (select line, credit_number from ShipPeriod where linenumber=19) ShipPeriod_19,
        (select line, credit_number from ShipPeriod where linenumber=20) ShipPeriod_20,
        (select line, credit_number from ShipPeriod where linenumber=21) ShipPeriod_21,
        (select line, credit_number from ShipPeriod where linenumber=22) ShipPeriod_22,
        (select line, credit_number from ShipPeriod where linenumber=23) ShipPeriod_23,
        (select line, credit_number from ShipPeriod where linenumber=24) ShipPeriod_24,
        (select line, credit_number from ShipPeriod where linenumber=25) ShipPeriod_25,
        (select line, credit_number from ShipPeriod where linenumber=26) ShipPeriod_26,
        (select line, credit_number from ShipPeriod where linenumber=27) ShipPeriod_27,
        (select line, credit_number from ShipPeriod where linenumber=28) ShipPeriod_28,
        (select line, credit_number from ShipPeriod where linenumber=29) ShipPeriod_29,
        (select line, credit_number from ShipPeriod where linenumber=30) ShipPeriod_30,
        (select line, credit_number from ShipPeriod where linenumber=31) ShipPeriod_31,
        (select line, credit_number from ShipPeriod where linenumber=32) ShipPeriod_32,
        (select line, credit_number from ShipPeriod where linenumber=33) ShipPeriod_33,
        (select line, credit_number from ShipPeriod where linenumber=34) ShipPeriod_34,
        (select line, credit_number from ShipPeriod where linenumber=35) ShipPeriod_35,
        (select line, credit_number from ShipPeriod where linenumber=36) ShipPeriod_36,
        (select line, credit_number from ShipPeriod where linenumber=37) ShipPeriod_37,
        (select line, credit_number from ShipPeriod where linenumber=38) ShipPeriod_38,
        (select line, credit_number from ShipPeriod where linenumber=39) ShipPeriod_39,
        (select line, credit_number from ShipPeriod where linenumber=40) ShipPeriod_40,
        (select line, credit_number from ShipPeriod where linenumber=41) ShipPeriod_41,
        (select line, credit_number from ShipPeriod where linenumber=42) ShipPeriod_42,
        (select line, credit_number from ShipPeriod where linenumber=43) ShipPeriod_43,
        (select line, credit_number from ShipPeriod where linenumber=44) ShipPeriod_44,
        (select line, credit_number from ShipPeriod where linenumber=45) ShipPeriod_45,
        (select line, credit_number from ShipPeriod where linenumber=46) ShipPeriod_46,
        (select line, credit_number from ShipPeriod where linenumber=47) ShipPeriod_47,
        (select line, credit_number from ShipPeriod where linenumber=48) ShipPeriod_48,
        (select line, credit_number from ShipPeriod where linenumber=49) ShipPeriod_49,
        (select line, credit_number from ShipPeriod where linenumber=50) ShipPeriod_50,
        (select line, credit_number from ShipPeriod where linenumber=51) ShipPeriod_51,
        (select line, credit_number from ShipPeriod where linenumber=52) ShipPeriod_52,
        (select line, credit_number from ShipPeriod where linenumber=53) ShipPeriod_53,
        (select line, credit_number from ShipPeriod where linenumber=54) ShipPeriod_54,
        (select line, credit_number from ShipPeriod where linenumber=55) ShipPeriod_55,
        (select line, credit_number from ShipPeriod where linenumber=56) ShipPeriod_56,
        (select line, credit_number from ShipPeriod where linenumber=57) ShipPeriod_57,
        (select line, credit_number from ShipPeriod where linenumber=58) ShipPeriod_58,
        (select line, credit_number from ShipPeriod where linenumber=59) ShipPeriod_59,
        (select line, credit_number from ShipPeriod where linenumber=60) ShipPeriod_60
    where
        c.credit_number =  ShipPeriod_1.credit_number(+),
        c.credit_number =  ShipPeriod_2.credit_number(+),
        c.credit_number =  ShipPeriod_3.credit_number(+),
        c.credit_number =  ShipPeriod_4.credit_number(+),
        c.credit_number =  ShipPeriod_5.credit_number(+),
        c.credit_number =  ShipPeriod_6.credit_number(+),
        c.credit_number =  ShipPeriod_7.credit_number(+),
        c.credit_number =  ShipPeriod_8.credit_number(+),
        c.credit_number =  ShipPeriod_9.credit_number(+),
        c.credit_number =  ShipPeriod_10.credit_number(+),
        c.credit_number =  ShipPeriod_11.credit_number(+),
        c.credit_number =  ShipPeriod_12.credit_number(+),
        c.credit_number =  ShipPeriod_13.credit_number(+),
        c.credit_number =  ShipPeriod_14.credit_number(+),
        c.credit_number =  ShipPeriod_15.credit_number(+),
        c.credit_number =  ShipPeriod_16.credit_number(+),
        c.credit_number =  ShipPeriod_17.credit_number(+),
        c.credit_number =  ShipPeriod_18.credit_number(+),
        c.credit_number =  ShipPeriod_19.credit_number(+),
        c.credit_number =  ShipPeriod_20.credit_number(+),
        c.credit_number =  ShipPeriod_21.credit_number(+),
        c.credit_number =  ShipPeriod_22.credit_number(+),
        c.credit_number =  ShipPeriod_23.credit_number(+),
        c.credit_number =  ShipPeriod_24.credit_number(+),
        c.credit_number =  ShipPeriod_25.credit_number(+),
        c.credit_number =  ShipPeriod_26.credit_number(+),
        c.credit_number =  ShipPeriod_27.credit_number(+),
        c.credit_number =  ShipPeriod_28.credit_number(+),
        c.credit_number =  ShipPeriod_29.credit_number(+),
        c.credit_number =  ShipPeriod_30.credit_number(+),
        c.credit_number =  ShipPeriod_31.credit_number(+),
        c.credit_number =  ShipPeriod_32.credit_number(+),
        c.credit_number =  ShipPeriod_33.credit_number(+),
        c.credit_number =  ShipPeriod_34.credit_number(+),
        c.credit_number =  ShipPeriod_35.credit_number(+),
        c.credit_number =  ShipPeriod_36.credit_number(+),
        c.credit_number =  ShipPeriod_37.credit_number(+),
        c.credit_number =  ShipPeriod_38.credit_number(+),
        c.credit_number =  ShipPeriod_39.credit_number(+),
        c.credit_number =  ShipPeriod_40.credit_number(+),
        c.credit_number =  ShipPeriod_41.credit_number(+),
        c.credit_number =  ShipPeriod_42.credit_number(+),
        c.credit_number =  ShipPeriod_43.credit_number(+),
        c.credit_number =  ShipPeriod_44.credit_number(+),
        c.credit_number =  ShipPeriod_45.credit_number(+),
        c.credit_number =  ShipPeriod_46.credit_number(+),
        c.credit_number =  ShipPeriod_47.credit_number(+),
        c.credit_number =  ShipPeriod_48.credit_number(+),
        c.credit_number =  ShipPeriod_49.credit_number(+),
        c.credit_number =  ShipPeriod_50.credit_number(+),
        c.credit_number =  ShipPeriod_51.credit_number(+),
        c.credit_number =  ShipPeriod_52.credit_number(+),
        c.credit_number =  ShipPeriod_53.credit_number(+),
        c.credit_number =  ShipPeriod_54.credit_number(+),
        c.credit_number =  ShipPeriod_55.credit_number(+),
        c.credit_number =  ShipPeriod_56.credit_number(+),
        c.credit_number =  ShipPeriod_57.credit_number(+),
        c.credit_number =  ShipPeriod_58.credit_number(+),
        c.credit_number =  ShipPeriod_59.credit_number(+),
        c.credit_number =  ShipPeriod_60.credit_number(+);