1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102
|
select codsoc ,datmod ,utimod ,codent ,segment ,codsoc_phy ,niveau1 ,niveau2 ,niveau3 ,niveau4 ,niveau5 ,niveau6 ,niveau7 ,niveau8 ,niveau9 ,niveau10 ,mode_me ,propag from mev where codsoc = 100 and codent = 'PARAV' and segment = ' ' ;
select codsoc ,datmod ,utimod ,codpar ,codfct ,libpar ,para1 ,para2 ,para3 ,parm1 ,parm2 ,parn1 ,parn2 ,parn3 ,parn4 ,parn5 ,pard1 ,pard2 ,pard3 ,actif from parav where codsoc = 100 and codfct = 'QCMOE7' order by codsoc ASC,codfct ASC,codpar ASC;
select codsoc ,datmod ,utimod ,codpar ,codfct ,libpar ,para1 ,para2 ,para3 ,parm1 ,parm2 ,parn1 ,parn2 ,parn3 ,parn4 ,parn5 ,pard1 ,pard2 ,pard3 ,actif from parav where codsoc = 100 and codfct = ' ' order by codsoc ASC,codfct ASC,codpar ASC;
select fct ,uti ,datact ,heuact ,datdeb ,heudeb ,datfin ,heufin ,page ,st1 ,st2 ,fprint ,batch ,nbi ,forma ,afct ,auti ,numero ,nbc ,dir ,tfc ,automanu ,edit ,maq ,nomprc ,ord ,contin ,code_maq ,datmod ,utimod ,codsoc ,nommaq ,numpere ,codpled ,etape ,posext ,eshs ,nummes ,attr from ut_spl where codsoc = 100 and numero = 2976 ;
update ut_spl set fct = 'QCMOE7' ,uti = 'GNC' ,datact = '20120215' ,heuact = '1208' ,datdeb = '20120215' ,heudeb = '1209' ,datfin = '20120215' ,heufin = '1209' ,page = 6 ,st1 = 3 ,st2 = ' ' ,fprint = 'ISUC37' ,batch = 'EXPS5C' ,nbi = 1 ,forma = 'S5' ,afct = 'QCMO' ,auti = ' ' ,numero = 2976 ,nbc = 1 ,dir = '#trt@ap$spl:' ,tfc = 'Analyse de dispo metro. J+1 RE CB' ,automanu = 'M' ,edit = 'O' ,maq = ' ' ,nomprc = '2976QCMOE7' ,ord = 1 ,contin = 'N' ,code_maq = ' ' ,datmod = '20120215' ,utimod = 'GNC' ,codsoc = 100 ,nommaq = '#TRT@ap$maq:qdispodlc.j1' ,numpere = 0 ,codpled = ' ' ,etape = 0 ,posext = 0 ,eshs = 'ES' ,nummes = 0 ,attr = 0 where codsoc = 100 and numero = 2976 ;
select fct ,tit ,cat ,eshs ,typut_fct ,fic ,batch ,fprint ,forma ,app ,modfct ,par ,trace ,tir ,maq ,codsoc ,option_fon ,cod_fct_pere from ut_fct where codsoc = 100 and fct = 'QCMOE7' ;
update ut_spl set fct = 'QCMOE7' ,uti = 'GNC' ,datact = '20120215' ,heuact = '1208' ,datdeb = '20120215' ,heudeb = '1209' ,datfin = '20120215' ,heufin = '1209' ,page = 6 ,st1 = 3 ,st2 = ' ' ,fprint = 'ISUC37' ,batch = 'EXPS5C' ,nbi = 1 ,forma = 'S5' ,afct = 'QCMO' ,auti = ' ' ,numero = 2976 ,nbc = 1 ,dir = '#trt@ap$spl:' ,tfc = 'Analyse de dispo metro. J+1 RE CB' ,automanu = 'M' ,edit = 'O' ,maq = ' ' ,nomprc = '2976QCMOE7' ,ord = 1 ,contin = 'N' ,code_maq = ' ' ,datmod = '20120215' ,utimod = 'GNC' ,codsoc = 100 ,nommaq = '#TRT@ap$maq:qdispodlc.j1' ,numpere = 0 ,codpled = ' ' ,etape = 51 ,posext = 0 ,eshs = 'ES' ,nummes = 0 ,attr = 0 where codsoc = 100 and numero = 2976 ;
update ut_spl set fct = 'QCMOE7' ,uti = 'GNC' ,datact = '20120215' ,heuact = '1208' ,datdeb = '20120215' ,heudeb = '1209' ,datfin = '20120215' ,heufin = '1209' ,page = 6 ,st1 = 3 ,st2 = ' ' ,fprint = 'ISUC37' ,batch = 'EXPS5C' ,nbi = 1 ,forma = 'S5' ,afct = 'QCMO' ,auti = ' ' ,numero = 2976 ,nbc = 1 ,dir = '#trt@ap$spl:' ,tfc = 'Analyse de dispo metro. J+1 RE CB' ,automanu = 'M' ,edit = 'O' ,maq = ' ' ,nomprc = '2976QCMOE7' ,ord = 1 ,contin = 'N' ,code_maq = ' ' ,datmod = '20120215' ,utimod = 'GNC' ,codsoc = 100 ,nommaq = '#TRT@ap$maq:qdispodlc.j1' ,numpere = 0 ,codpled = ' ' ,etape = 100 ,posext = 0 ,eshs = 'ES' ,nummes = 0 ,attr = 0 where codsoc = 100 and numero = 2976 ;
update ut_spl set fct = 'QCMOE7' ,uti = 'GNC' ,datact = '20120215' ,heuact = '1208' ,datdeb = '20120215' ,heudeb = '1209' ,datfin = '20120215' ,heufin = '1209' ,page = 6 ,st1 = 3 ,st2 = ' ' ,fprint = 'ISUC37' ,batch = 'EXPS5C' ,nbi = 1 ,forma = 'S5' ,afct = 'QCMO' ,auti = ' ' ,numero = 2976 ,nbc = 1 ,dir = '#trt@ap$spl:' ,tfc = 'Analyse de dispo metro. J+1 RE CB' ,automanu = 'M' ,edit = 'O' ,maq = ' ' ,nomprc = '2976QCMOE7' ,ord = 1 ,contin = 'N' ,code_maq = ' ' ,datmod = '20120215' ,utimod = 'GNC' ,codsoc = 100 ,nommaq = '#TRT@ap$maq:qdispodlc.j1' ,numpere = 0 ,codpled = ' ' ,etape = 130 ,posext = 0 ,eshs = 'ES' ,nummes = 0 ,attr = 0 where codsoc = 100 and numero = 2976 ;
select numero ,numpar ,automanu ,param ,datmod ,utimod ,codsoc ,nomtable ,nomchp from ut_par where codsoc = 100 and numero = 2976 and numpar >= 0 order by codsoc ASC,numero ASC,numpar ASC;
update ut_spl set fct = 'QCMOE7' ,uti = 'GNC' ,datact = '20120215' ,heuact = '1208' ,datdeb = '20120215' ,heudeb = '1209' ,datfin = '20120215' ,heufin = '1209' ,page = 6 ,st1 = 3 ,st2 = ' ' ,fprint = 'ISUC37' ,batch = 'EXPS5C' ,nbi = 1 ,forma = 'S5' ,afct = 'QCMO' ,auti = ' ' ,numero = 2976 ,nbc = 1 ,dir = '#trt@ap$spl:' ,tfc = 'Analyse de dispo metro. J+1 RE CB' ,automanu = 'M' ,edit = 'O' ,maq = ' ' ,nomprc = '2976QCMOE7' ,ord = 1 ,contin = 'N' ,code_maq = ' ' ,datmod = '20120215' ,utimod = 'GNC' ,codsoc = 100 ,nommaq = '#TRT@ap$maq:qdispodlc.j1' ,numpere = 0 ,codpled = ' ' ,etape = 131 ,posext = 0 ,eshs = 'ES' ,nummes = 0 ,attr = 0 where codsoc = 100 and numero = 2976 ;
update ut_spl set fct = 'QCMOE7' ,uti = 'GNC' ,datact = '20120215' ,heuact = '1208' ,datdeb = '20120215' ,heudeb = '1209' ,datfin = '20120215' ,heufin = '1209' ,page = 6 ,st1 = 3 ,st2 = ' ' ,fprint = 'ISUC37' ,batch = 'EXPS5C' ,nbi = 1 ,forma = 'S5' ,afct = 'QCMO' ,auti = ' ' ,numero = 2976 ,nbc = 1 ,dir = '#trt@ap$spl:' ,tfc = 'Analyse de dispo metro. J+1 RE CB' ,automanu = 'M' ,edit = 'O' ,maq = ' ' ,nomprc = '2976QCMOE7' ,ord = 1 ,contin = 'N' ,code_maq = ' ' ,datmod = '20120215' ,utimod = 'GNC' ,codsoc = 100 ,nommaq = '#TRT@ap$maq:qdispodlc.j1' ,numpere = 0 ,codpled = ' ' ,etape = 200 ,posext = 0 ,eshs = 'ES' ,nummes = 0 ,attr = 0 where codsoc = 100 and numero = 2976 ;
update ut_spl set fct = 'QCMOE7' ,uti = 'GNC' ,datact = '20120215' ,heuact = '1208' ,datdeb = '20120215' ,heudeb = '1209' ,datfin = '20120215' ,heufin = '1209' ,page = 6 ,st1 = 3 ,st2 = ' ' ,fprint = 'ISUC37' ,batch = 'EXPS5C' ,nbi = 1 ,forma = 'S5' ,afct = 'QCMO' ,auti = ' ' ,numero = 2976 ,nbc = 1 ,dir = '#trt@ap$spl:' ,tfc = 'Analyse de dispo metro. J+1 RE CB' ,automanu = 'M' ,edit = 'O' ,maq = ' ' ,nomprc = '2976QCMOE7' ,ord = 1 ,contin = 'N' ,code_maq = ' ' ,datmod = '20120215' ,utimod = 'GNC' ,codsoc = 100 ,nommaq = '#TRT@ap$maq:qdispodlc.j1' ,numpere = 0 ,codpled = ' ' ,etape = 230 ,posext = 0 ,eshs = 'ES' ,nummes = 0 ,attr = 0 where codsoc = 100 and numero = 2976 ;
update ut_spl set fct = 'QCMOE7' ,uti = 'GNC' ,datact = '20120215' ,heuact = '1208' ,datdeb = '20120215' ,heudeb = '1209' ,datfin = '20120215' ,heufin = '1209' ,page = 6 ,st1 = 3 ,st2 = ' ' ,fprint = 'ISUC37' ,batch = 'EXPS5C' ,nbi = 1 ,forma = 'S5' ,afct = 'QCMO' ,auti = ' ' ,numero = 2976 ,nbc = 1 ,dir = '#trt@ap$spl:' ,tfc = 'Analyse de dispo metro. J+1 RE CB' ,automanu = 'M' ,edit = 'O' ,maq = ' ' ,nomprc = '2976QCMOE7' ,ord = 1 ,contin = 'N' ,code_maq = ' ' ,datmod = '20120215' ,utimod = 'GNC' ,codsoc = 100 ,nommaq = '#TRT@ap$maq:qdispodlc.j1' ,numpere = 0 ,codpled = ' ' ,etape = 231 ,posext = 0 ,eshs = 'ES' ,nummes = 0 ,attr = 0 where codsoc = 100 and numero = 2976 ;
update ut_spl set fct = 'QCMOE7' ,uti = 'GNC' ,datact = '20120215' ,heuact = '1208' ,datdeb = '20120215' ,heudeb = '1209' ,datfin = '20120215' ,heufin = '1209' ,page = 6 ,st1 = 3 ,st2 = ' ' ,fprint = 'ISUC37' ,batch = 'EXPS5C' ,nbi = 1 ,forma = 'S5' ,afct = 'QCMO' ,auti = ' ' ,numero = 2976 ,nbc = 1 ,dir = '#trt@ap$spl:' ,tfc = 'Analyse de dispo metro. J+1 RE CB' ,automanu = 'M' ,edit = 'O' ,maq = ' ' ,nomprc = '2976QCMOE7' ,ord = 1 ,contin = 'N' ,code_maq = ' ' ,datmod = '20120215' ,utimod = 'GNC' ,codsoc = 100 ,nommaq = '#TRT@ap$maq:qdispodlc.j1' ,numpere = 0 ,codpled = ' ' ,etape = 260 ,posext = 0 ,eshs = 'ES' ,nummes = 0 ,attr = 0 where codsoc = 100 and numero = 2976 ;
update ut_spl set fct = 'QCMOE7' ,uti = 'GNC' ,datact = '20120215' ,heuact = '1208' ,datdeb = '20120215' ,heudeb = '1209' ,datfin = '20120215' ,heufin = '1209' ,page = 6 ,st1 = 3 ,st2 = ' ' ,fprint = 'ISUC37' ,batch = 'EXPS5C' ,nbi = 1 ,forma = 'S5' ,afct = 'QCMO' ,auti = ' ' ,numero = 2976 ,nbc = 1 ,dir = '#trt@ap$spl:' ,tfc = 'Analyse de dispo metro. J+1 RE CB' ,automanu = 'M' ,edit = 'O' ,maq = ' ' ,nomprc = '2976QCMOE7' ,ord = 1 ,contin = 'N' ,code_maq = ' ' ,datmod = '20120215' ,utimod = 'GNC' ,codsoc = 100 ,nommaq = '#TRT@ap$maq:qdispodlc.j1' ,numpere = 0 ,codpled = ' ' ,etape = 261 ,posext = 0 ,eshs = 'ES' ,nummes = 0 ,attr = 0 where codsoc = 100 and numero = 2976 ;
update ut_spl set fct = 'QCMOE7' ,uti = 'GNC' ,datact = '20120215' ,heuact = '1208' ,datdeb = '20120215' ,heudeb = '1209' ,datfin = '20120215' ,heufin = '1209' ,page = 6 ,st1 = 3 ,st2 = ' ' ,fprint = 'ISUC37' ,batch = 'EXPS5C' ,nbi = 1 ,forma = 'S5' ,afct = 'QCMO' ,auti = ' ' ,numero = 2976 ,nbc = 1 ,dir = '#trt@ap$spl:' ,tfc = 'Analyse de dispo metro. J+1 RE CB' ,automanu = 'M' ,edit = 'O' ,maq = ' ' ,nomprc = '2976QCMOE7' ,ord = 1 ,contin = 'N' ,code_maq = ' ' ,datmod = '20120215' ,utimod = 'GNC' ,codsoc = 100 ,nommaq = '#TRT@ap$maq:qdispodlc.j1' ,numpere = 0 ,codpled = ' ' ,etape = 300 ,posext = 0 ,eshs = 'ES' ,nummes = 0 ,attr = 0 where codsoc = 100 and numero = 2976 ;
update ut_spl set fct = 'QCMOE7' ,uti = 'GNC' ,datact = '20120215' ,heuact = '1208' ,datdeb = '20120215' ,heudeb = '1209' ,datfin = '20120215' ,heufin = '1209' ,page = 6 ,st1 = 3 ,st2 = ' ' ,fprint = 'ISUC37' ,batch = 'EXPS5C' ,nbi = 1 ,forma = 'S5' ,afct = 'QCMO' ,auti = ' ' ,numero = 2976 ,nbc = 1 ,dir = '#trt@ap$spl:' ,tfc = 'Analyse de dispo metro. J+1 RE CB' ,automanu = 'M' ,edit = 'O' ,maq = ' ' ,nomprc = '2976QCMOE7' ,ord = 1 ,contin = 'N' ,code_maq = ' ' ,datmod = '20120215' ,utimod = 'GNC' ,codsoc = 100 ,nommaq = '#TRT@ap$maq:qdispodlc.j1' ,numpere = 0 ,codpled = ' ' ,etape = 350 ,posext = 0 ,eshs = 'ES' ,nummes = 0 ,attr = 0 where codsoc = 100 and numero = 2976 ;
update ut_spl set fct = 'QCMOE7' ,uti = 'GNC' ,datact = '20120215' ,heuact = '1208' ,datdeb = '20120215' ,heudeb = '1209' ,datfin = '20120215' ,heufin = '1209' ,page = 6 ,st1 = 3 ,st2 = ' ' ,fprint = 'ISUC37' ,batch = 'EXPS5C' ,nbi = 1 ,forma = 'S5' ,afct = 'QCMO' ,auti = ' ' ,numero = 2976 ,nbc = 1 ,dir = '#trt@ap$spl:' ,tfc = 'Analyse de dispo metro. J+1 RE CB' ,automanu = 'M' ,edit = 'O' ,maq = ' ' ,nomprc = '2976QCMOE7' ,ord = 1 ,contin = 'N' ,code_maq = ' ' ,datmod = '20120215' ,utimod = 'GNC' ,codsoc = 100 ,nommaq = '#TRT@ap$maq:qdispodlc.j1' ,numpere = 0 ,codpled = ' ' ,etape = 351 ,posext = 0 ,eshs = 'ES' ,nummes = 0 ,attr = 0 where codsoc = 100 and numero = 2976 ;
update ut_spl set fct = 'QCMOE7' ,uti = 'GNC' ,datact = '20120215' ,heuact = '1208' ,datdeb = '20120215' ,heudeb = '1209' ,datfin = '20120215' ,heufin = '1209' ,page = 6 ,st1 = 3 ,st2 = ' ' ,fprint = 'ISUC37' ,batch = 'EXPS5C' ,nbi = 1 ,forma = 'S5' ,afct = 'QCMO' ,auti = ' ' ,numero = 2976 ,nbc = 1 ,dir = '#trt@ap$spl:' ,tfc = 'Analyse de dispo metro. J+1 RE CB' ,automanu = 'M' ,edit = 'O' ,maq = ' ' ,nomprc = '2976QCMOE7' ,ord = 1 ,contin = 'N' ,code_maq = ' ' ,datmod = '20120215' ,utimod = 'GNC' ,codsoc = 100 ,nommaq = '#TRT@ap$maq:qdispodlc.j1' ,numpere = 0 ,codpled = ' ' ,etape = 400 ,posext = 0 ,eshs = 'ES' ,nummes = 0 ,attr = 0 where codsoc = 100 and numero = 2976 ;
update ut_spl set fct = 'QCMOE7' ,uti = 'GNC' ,datact = '20120215' ,heuact = '1208' ,datdeb = '20120215' ,heudeb = '1209' ,datfin = '20120215' ,heufin = '1209' ,page = 6 ,st1 = 3 ,st2 = ' ' ,fprint = 'ISUC37' ,batch = 'EXPS5C' ,nbi = 1 ,forma = 'S5' ,afct = 'QCMO' ,auti = ' ' ,numero = 2976 ,nbc = 1 ,dir = '#trt@ap$spl:' ,tfc = 'Analyse de dispo metro. J+1 RE CB' ,automanu = 'M' ,edit = 'O' ,maq = ' ' ,nomprc = '2976QCMOE7' ,ord = 1 ,contin = 'N' ,code_maq = ' ' ,datmod = '20120215' ,utimod = 'GNC' ,codsoc = 100 ,nommaq = '#TRT@ap$maq:qdispodlc.j1' ,numpere = 0 ,codpled = ' ' ,etape = 410 ,posext = 0 ,eshs = 'ES' ,nummes = 0 ,attr = 0 where codsoc = 100 and numero = 2976 ;
update ut_spl set fct = 'QCMOE7' ,uti = 'GNC' ,datact = '20120215' ,heuact = '1208' ,datdeb = '20120215' ,heudeb = '1209' ,datfin = '20120215' ,heufin = '1209' ,page = 6 ,st1 = 3 ,st2 = ' ' ,fprint = 'ISUC37' ,batch = 'EXPS5C' ,nbi = 1 ,forma = 'S5' ,afct = 'QCMO' ,auti = ' ' ,numero = 2976 ,nbc = 1 ,dir = '#trt@ap$spl:' ,tfc = 'Analyse de dispo metro. J+1 RE CB' ,automanu = 'M' ,edit = 'O' ,maq = ' ' ,nomprc = '2976QCMOE7' ,ord = 1 ,contin = 'N' ,code_maq = ' ' ,datmod = '20120215' ,utimod = 'GNC' ,codsoc = 100 ,nommaq = '#TRT@ap$maq:qdispodlc.j1' ,numpere = 0 ,codpled = ' ' ,etape = 411 ,posext = 0 ,eshs = 'ES' ,nummes = 0 ,attr = 0 where codsoc = 100 and numero = 2976 ;
update ut_spl set fct = 'QCMOE7' ,uti = 'GNC' ,datact = '20120215' ,heuact = '1208' ,datdeb = '20120215' ,heudeb = '1209' ,datfin = '20120215' ,heufin = '1209' ,page = 6 ,st1 = 3 ,st2 = ' ' ,fprint = 'ISUC37' ,batch = 'EXPS5C' ,nbi = 1 ,forma = 'S5' ,afct = 'QCMO' ,auti = ' ' ,numero = 2976 ,nbc = 1 ,dir = '#trt@ap$spl:' ,tfc = 'Analyse de dispo metro. J+1 RE CB' ,automanu = 'M' ,edit = 'O' ,maq = ' ' ,nomprc = '2976QCMOE7' ,ord = 1 ,contin = 'N' ,code_maq = ' ' ,datmod = '20120215' ,utimod = 'GNC' ,codsoc = 100 ,nommaq = '#TRT@ap$maq:qdispodlc.j1' ,numpere = 0 ,codpled = ' ' ,etape = 420 ,posext = 0 ,eshs = 'ES' ,nummes = 0 ,attr = 0 where codsoc = 100 and numero = 2976 ;
select codtbl ,cletbl ,lib1 ,lib2 ,lib3 ,lir ,num1 ,num2 ,num3 ,dec1 ,dec2 ,dec3 ,datmod ,utimod ,codsoc ,lib4 ,lib5 ,lib6 ,lib7 ,lib8 ,lib9 ,lib10 ,num4 ,num5 ,num6 ,num7 ,num8 ,num9 ,num10 ,dec4 ,dec5 ,dec6 ,dec7 ,dec8 ,dec9 ,dec10 ,dat1 ,dat2 ,dat3 ,dat4 ,dat5 ,dat6 ,dat7 ,dat8 ,dat9 ,dat10 ,filtre_tbl ,z40l_1 ,z40l_2 ,z40l_3 ,z40l_4 ,z40l_5 ,z40l_6 ,z40l_7 ,z40l_8 ,z40l_9 ,z40l_10 from tbl where codsoc = 100 and codtbl = 'vin' order by codsoc ASC,codtbl ASC,cletbl ASC;
select codtbl ,cletbl ,lib1 ,lib2 ,lib3 ,lir ,num1 ,num2 ,num3 ,dec1 ,dec2 ,dec3 ,datmod ,utimod ,codsoc ,lib4 ,lib5 ,lib6 ,lib7 ,lib8 ,lib9 ,lib10 ,num4 ,num5 ,num6 ,num7 ,num8 ,num9 ,num10 ,dec4 ,dec5 ,dec6 ,dec7 ,dec8 ,dec9 ,dec10 ,dat1 ,dat2 ,dat3 ,dat4 ,dat5 ,dat6 ,dat7 ,dat8 ,dat9 ,dat10 ,filtre_tbl ,z40l_1 ,z40l_2 ,z40l_3 ,z40l_4 ,z40l_5 ,z40l_6 ,z40l_7 ,z40l_8 ,z40l_9 ,z40l_10 from tbl where codsoc = 100 and codtbl = 'cbe' and cletbl = 'DEVNAT' ;
select codtbl ,cletbl ,lib1 ,lib2 ,lib3 ,lir ,num1 ,num2 ,num3 ,dec1 ,dec2 ,dec3 ,datmod ,utimod ,codsoc ,lib4 ,lib5 ,lib6 ,lib7 ,lib8 ,lib9 ,lib10 ,num4 ,num5 ,num6 ,num7 ,num8 ,num9 ,num10 ,dec4 ,dec5 ,dec6 ,dec7 ,dec8 ,dec9 ,dec10 ,dat1 ,dat2 ,dat3 ,dat4 ,dat5 ,dat6 ,dat7 ,dat8 ,dat9 ,dat10 ,filtre_tbl ,z40l_1 ,z40l_2 ,z40l_3 ,z40l_4 ,z40l_5 ,z40l_6 ,z40l_7 ,z40l_8 ,z40l_9 ,z40l_10 from tbl where codsoc = 100 and codtbl = 'cbe' and cletbl = 'PARAM' ;
select codtbl ,cletbl ,lib1 ,lib2 ,lib3 ,lir ,num1 ,num2 ,num3 ,dec1 ,dec2 ,dec3 ,datmod ,utimod ,codsoc ,lib4 ,lib5 ,lib6 ,lib7 ,lib8 ,lib9 ,lib10 ,num4 ,num5 ,num6 ,num7 ,num8 ,num9 ,num10 ,dec4 ,dec5 ,dec6 ,dec7 ,dec8 ,dec9 ,dec10 ,dat1 ,dat2 ,dat3 ,dat4 ,dat5 ,dat6 ,dat7 ,dat8 ,dat9 ,dat10 ,filtre_tbl ,z40l_1 ,z40l_2 ,z40l_3 ,z40l_4 ,z40l_5 ,z40l_6 ,z40l_7 ,z40l_8 ,z40l_9 ,z40l_10 from tbl where codsoc = 100 and codtbl = 'cbe' and cletbl = 'STOCKS' ;
select fct ,uti ,datact ,heuact ,datdeb ,heudeb ,datfin ,heufin ,page ,st1 ,st2 ,fprint ,batch ,nbi ,forma ,afct ,auti ,numero ,nbc ,dir ,tfc ,automanu ,edit ,maq ,nomprc ,ord ,contin ,code_maq ,datmod ,utimod ,codsoc ,nommaq ,numpere ,codpled ,etape ,posext ,eshs ,nummes ,attr from ut_spl where codsoc = 100 and numero = 2976 ;
select typtie ,sigtie ,nomtie ,adrcom ,cpttie ,nombqe ,codbqe ,guiche ,cptbqe ,clerib ,coddpt ,modrgl ,delrgl ,codqua ,tauesc ,encmax ,encass ,anccde ,encfac ,enceff ,encenc ,perfac ,nbrfac ,edicot ,facrel ,posfis ,forfai ,editrt ,indsup ,codinc ,datmod ,utimod ,typfac ,famtie ,codbar ,coddev ,sigrep ,siggrp ,codlan ,mincde ,sigdep ,sigtra ,modliv ,relica ,sigach ,propri ,socges ,delrea ,blocliv ,libloc ,surfac ,surfres ,colec ,typtpv ,commer ,machin ,bqedom ,bqetra ,plafon ,fil ,codreg ,modtra ,codzn1 ,codzn2 ,codzn3 ,codzn4 ,codzn5 ,codzn6 ,codzn7 ,codzn8 ,codzn9 ,codzn10 ,codzn11 ,codzn12 ,codzn13 ,codzn14 ,codzn15 ,codzn16 ,codett ,datcre ,typgrp ,typrep ,cnufd ,nbcai ,indcat ,dreftar ,enseigne ,indref ,nbrjour ,numfil ,minfra ,dateve ,p_tietcp ,p_tiesig ,p_3ctcod ,p_3g1cod ,p_3g2cod ,p_3g3cod ,p_3g4cod ,p_3g5cod ,p_ribcodp ,codsoc ,p_tietpa ,p_tiespay ,p_3fccod ,p_tiebap ,p_tieintgr ,p_tielet ,etbcod ,etsstatut ,datexp ,calrea ,p_tiegrp ,moyrgl ,p_tiebim ,datinc ,indtim ,sigtrs ,guidrgl ,telven ,p_tieesc ,achvte_cat ,codcat ,datprc_cde ,nbjcde ,delsec ,codsoc_phy from tie where codsoc = 100 and typtie = 'SOC' and sigtie = 'CEDILAC' ;
select sigtie ,typtie ,typadr ,numadr ,sigadr ,typtie1 ,typadr1 ,numadr1 ,datmod ,utimod ,codsoc from lad where codsoc = 100 and sigtie = 'CEDILAC' and typtie = 'SOC' and typadr = 'COM' and numadr = 1 ;
select sigadr ,typtie ,typadr ,numadr ,libadr ,adress ,adrsui ,locali ,codpos ,cenpos ,codpay ,contac ,foncti ,tel ,telex ,fax ,siret ,codape ,codsec ,codtrn ,codatv ,indsup ,datmod ,utimod ,commen1 ,commen2 ,commen3 ,commen4 ,commen5 ,ouvre ,ferme ,ouvre1 ,ferme1 ,ouvre2 ,ferme2 ,ouvre3 ,ferme3 ,ouvre4 ,ferme4 ,ouvre5 ,ferme5 ,ouvre6 ,ferme6 ,ouvre7 ,ferme7 ,ouvre8 ,ferme8 ,ouvre9 ,ferme9 ,ouvre10 ,ferme10 ,ouvre11 ,ferme11 ,ouvre12 ,ferme12 ,ouvre13 ,ferme13 ,codciv ,tvainter ,insee ,cnufd ,cifd ,adredi ,indean ,codser ,delrea ,gespal ,codsoc ,ean13 ,codpos_10 ,codlan ,libadr50 ,ligadr50_1 ,ligadr50_2 ,ligadr50_3 ,locali50 ,cenpos50 ,posfis ,sigdep ,sigtra ,sigtrs ,libmou ,modtra ,modliv1 ,modloc ,delliv ,relica ,dedoub ,codzn1 ,codzn2 ,codzn3 ,codzn4 ,codzn5 ,codzn6 ,codzn7 ,codzn8 ,codzn9 ,codzn10 ,codzn11 ,codzn12 ,codzn13 ,codzn14 ,codzn15 ,codzn16 ,codzn17 ,codzn18 ,codzn19 ,codzn20 ,prenom ,ligadr50_4 ,statut6 ,datcre ,gsm ,telprof ,datnai from adr where codsoc = 100 and sigadr = 'CEDILAC' and typtie = 'SOC' and typadr = 'COM' and numadr = 1 ;
select codsoc ,cpttie ,p_ribcod ,p_ribdev ,p_4bqcbq ,p_4bqgui ,p_ribnom ,p_ribloc ,p_ribcpt ,p_ribcle ,p_ribprinc ,datmod ,utimod ,p_ribtyp ,p_4bqbnk ,p_4bqgch ,p_ribncp ,p_ribcrib ,p_ribdeb ,p_ribfin ,p_ribtitulaire ,bic ,iban from rib where codsoc = 100 and cpttie = 'CEDILAC' and p_ribcod = '001' ;
select codtbl ,cletbl ,lib1 ,lib2 ,lib3 ,lir ,num1 ,num2 ,num3 ,dec1 ,dec2 ,dec3 ,datmod ,utimod ,codsoc ,lib4 ,lib5 ,lib6 ,lib7 ,lib8 ,lib9 ,lib10 ,num4 ,num5 ,num6 ,num7 ,num8 ,num9 ,num10 ,dec4 ,dec5 ,dec6 ,dec7 ,dec8 ,dec9 ,dec10 ,dat1 ,dat2 ,dat3 ,dat4 ,dat5 ,dat6 ,dat7 ,dat8 ,dat9 ,dat10 ,filtre_tbl ,z40l_1 ,z40l_2 ,z40l_3 ,z40l_4 ,z40l_5 ,z40l_6 ,z40l_7 ,z40l_8 ,z40l_9 ,z40l_10 from tbl where codsoc = 1 and codtbl = 'pay' and cletbl = 'FR' ;
select uti ,nom ,eshs ,lan ,niv ,qua ,uni ,nbe ,affi ,codut_ter ,fprint ,batch ,dir ,poste ,trace ,ser ,datmod ,utimod ,codsoc ,statut ,codlan ,email256 ,tz from ut_uti where codsoc = 100 and uti = 'GNC' ;
select codfct ,codpled ,titedt ,maqedt ,batch ,fprint ,indimpi ,nbcop ,commen1 ,commen2 ,datmod ,utimod ,ligwhere1 ,ligwhere2 ,ligwhere3 ,code_maq ,format ,vue_util ,codsoc ,eshs ,nommaq ,niv ,codlan ,attpled ,nummes ,attr from ut_pled where codsoc = 100 and codfct = 'QCMOE7' and codpled = '1C' and codlan = 'FRA' ;
select codfct ,codpled ,numord ,datmod ,utimod ,nomchp ,typchp ,critlir ,numtri ,sais_tri ,critdeb ,critfin ,critcom ,sais_crit ,codsoc ,codlan from ut_pledc where codsoc = 100 and codfct = 'QCMOE7' and codpled = '1C' and codlan = 'FRA' and nomchp LIKE 'z40l_1%' order by codsoc ASC,codfct ASC,codpled ASC,codlan ASC,nomchp ASC;
select codfct ,codpled ,numord ,datmod ,utimod ,nomchp ,typchp ,critlir ,numtri ,sais_tri ,critdeb ,critfin ,critcom ,sais_crit ,codsoc ,codlan from ut_pledc where codsoc = 100 and codfct = 'QCMOE7' and codpled = '1C' and codlan = 'FRA' and nomchp LIKE 'datexp%' order by codsoc ASC,codfct ASC,codpled ASC,codlan ASC,nomchp ASC;
select codfct ,codpled ,numord ,datmod ,utimod ,nomchp ,typchp ,critlir ,numtri ,sais_tri ,critdeb ,critfin ,critcom ,sais_crit ,codsoc ,codlan from ut_pledc where codsoc = 100 and codfct = 'QCMOE7' and codpled = '1C' and codlan = 'FRA' and nomchp LIKE 'achvte%' order by codsoc ASC,codfct ASC,codpled ASC,codlan ASC,nomchp ASC;
select codfct ,codpled ,numord ,datmod ,utimod ,nomchp ,typchp ,critlir ,numtri ,sais_tri ,critdeb ,critfin ,critcom ,sais_crit ,codsoc ,codlan from ut_pledc where codsoc = 100 and codfct = 'QCMOE7' and codpled = '1C' and codlan = 'FRA' and nomchp LIKE 'typeve%' order by codsoc ASC,codfct ASC,codpled ASC,codlan ASC,nomchp ASC;
select codfct ,codpled ,numord ,datmod ,utimod ,nomchp ,typchp ,critlir ,numtri ,sais_tri ,critdeb ,critfin ,critcom ,sais_crit ,codsoc ,codlan from ut_pledc where codsoc = 100 and codfct = 'QCMOE7' and codpled = '1C' and codlan = 'FRA' and nomchp LIKE 'typeve%' order by codsoc ASC,codfct ASC,codpled ASC,codlan ASC,nomchp ASC;
select codfct ,codpled ,numord ,datmod ,utimod ,nomchp ,typchp ,critlir ,numtri ,sais_tri ,critdeb ,critfin ,critcom ,sais_crit ,codsoc ,codlan from ut_pledc where codsoc = 100 and codfct = 'QCMOE7' and codpled = '1C' and codlan = 'FRA' and nomchp LIKE 'typeve%' order by codsoc ASC,codfct ASC,codpled ASC,codlan ASC,nomchp ASC;
select codfct ,codpled ,numord ,datmod ,utimod ,nomchp ,typchp ,critlir ,numtri ,sais_tri ,critdeb ,critfin ,critcom ,sais_crit ,codsoc ,codlan from ut_pledc where codsoc = 100 and codfct = 'QCMOE7' and codpled = '1C' and codlan = 'FRA' and nomchp LIKE 'codpro%' order by codsoc ASC,codfct ASC,codpled ASC,codlan ASC,nomchp ASC;
select codfct ,codpled ,numord ,datmod ,utimod ,nomchp ,typchp ,critlir ,numtri ,sais_tri ,critdeb ,critfin ,critcom ,sais_crit ,codsoc ,codlan from ut_pledc where codsoc = 100 and codfct = 'QCMOE7' and codpled = '1C' and codlan = 'FRA' and nomchp LIKE 'codpro%' order by codsoc ASC,codfct ASC,codpled ASC,codlan ASC,nomchp ASC;
select codfct ,codpled ,numord ,datmod ,utimod ,nomchp ,typchp ,critlir ,numtri ,sais_tri ,critdeb ,critfin ,critcom ,sais_crit ,codsoc ,codlan from ut_pledc where codsoc = 100 and codfct = 'QCMOE7' and codpled = '1C' and codlan = 'FRA' and nomchp LIKE 'sigdep%' order by codsoc ASC,codfct ASC,codpled ASC,codlan ASC,nomchp ASC;
select codfct ,codpled ,numord ,datmod ,utimod ,nomchp ,typchp ,critlir ,numtri ,sais_tri ,critdeb ,critfin ,critcom ,sais_crit ,codsoc ,codlan from ut_pledc where codsoc = 100 and codfct = 'QCMOE7' and codpled = '1C' and codlan = 'FRA' and nomchp LIKE 'codpro%' order by codsoc ASC,codfct ASC,codpled ASC,codlan ASC,nomchp ASC;
select codfct ,codpled ,numord ,datmod ,utimod ,nomchp ,typchp ,critlir ,numtri ,sais_tri ,critdeb ,critfin ,critcom ,sais_crit ,codsoc ,codlan from ut_pledc where codsoc = 100 and codfct = 'QCMOE7' and codpled = '1C' and codlan = 'FRA' and nomchp LIKE 'z40l_1%' order by codsoc ASC,codfct ASC,codpled ASC,codlan ASC,nomchp ASC;
select codfct ,codpled ,numord ,datmod ,utimod ,nomchp ,typchp ,critlir ,numtri ,sais_tri ,critdeb ,critfin ,critcom ,sais_crit ,codsoc ,codlan from ut_pledc where codsoc = 100 and codfct = 'QCMOE7' and codpled = '1C' and codlan = 'FRA' and nomchp LIKE 'datexp%' order by codsoc ASC,codfct ASC,codpled ASC,codlan ASC,nomchp ASC;
select codpev ,libpev ,achvte ,typeve ,codosk ,achvto ,typevo ,depaut ,majcnt ,majenc ,ordre1 ,ordre2 ,ordre3 ,saiqte ,achvts ,typevs ,ordeve ,ordevs ,ordevo ,evoobl ,codosk_d ,codosk_v ,codosk_vd ,ordre4 ,ordre5 ,ordre6 ,ordre7 ,ordre8 ,ordre9 ,ordre10 ,engage ,ridatliv ,ridatexp ,moduni ,annule ,typtie ,datmod ,utimod ,etaevo ,invalidati ,refprod ,pevoevo ,codeta ,valeta ,codett ,forcev ,gesstk ,nbjliv ,nbjexp ,codppe1 ,para1 ,parn1 ,codppe2 ,para2 ,parn2 ,codppe3 ,para3 ,parn3 ,codppe4 ,para4 ,parn4 ,codppe5 ,para5 ,parn5 ,codppe6 ,para6 ,parn6 ,soleta ,codppe7 ,para7 ,parn7 ,codppe8 ,para8 ,parn8 ,codppe9 ,para9 ,parn9 ,codppe10 ,para10 ,parn10 ,codppe11 ,para11 ,parn11 ,codppe12 ,para12 ,parn12 ,codsoc from pev where codsoc = 100 and codpev = 'QCMOE7' ;
select codtbl ,cletbl ,lib1 ,lib2 ,lib3 ,lir ,num1 ,num2 ,num3 ,dec1 ,dec2 ,dec3 ,datmod ,utimod ,codsoc ,lib4 ,lib5 ,lib6 ,lib7 ,lib8 ,lib9 ,lib10 ,num4 ,num5 ,num6 ,num7 ,num8 ,num9 ,num10 ,dec4 ,dec5 ,dec6 ,dec7 ,dec8 ,dec9 ,dec10 ,dat1 ,dat2 ,dat3 ,dat4 ,dat5 ,dat6 ,dat7 ,dat8 ,dat9 ,dat10 ,filtre_tbl ,z40l_1 ,z40l_2 ,z40l_3 ,z40l_4 ,z40l_5 ,z40l_6 ,z40l_7 ,z40l_8 ,z40l_9 ,z40l_10 from tbl where codsoc = 100 and codtbl = 'zon' and cletbl LIKE 'PRO%' order by codsoc ASC,codtbl ASC,cletbl ASC;
select codtbl ,cletbl ,lib1 ,lib2 ,lib3 ,lir ,num1 ,num2 ,num3 ,dec1 ,dec2 ,dec3 ,datmod ,utimod ,codsoc ,lib4 ,lib5 ,lib6 ,lib7 ,lib8 ,lib9 ,lib10 ,num4 ,num5 ,num6 ,num7 ,num8 ,num9 ,num10 ,dec4 ,dec5 ,dec6 ,dec7 ,dec8 ,dec9 ,dec10 ,dat1 ,dat2 ,dat3 ,dat4 ,dat5 ,dat6 ,dat7 ,dat8 ,dat9 ,dat10 ,filtre_tbl ,z40l_1 ,z40l_2 ,z40l_3 ,z40l_4 ,z40l_5 ,z40l_6 ,z40l_7 ,z40l_8 ,z40l_9 ,z40l_10 from tbl where codsoc = 100 and codtbl = 'zon' and cletbl LIKE 'OST%' order by codsoc ASC,codtbl ASC,cletbl ASC;
update ut_spl set fct = 'QCMOE7' ,uti = 'GNC' ,datact = '20120215' ,heuact = '1208' ,datdeb = '20120215' ,heudeb = '1209' ,datfin = '20120215' ,heufin = '1209' ,page = 6 ,st1 = 3 ,st2 = ' ' ,fprint = 'ISUC37' ,batch = 'EXPS5C' ,nbi = 1 ,forma = 'S5' ,afct = 'QCMO' ,auti = ' ' ,numero = 2976 ,nbc = 1 ,dir = '#trt@ap$spl:' ,tfc = 'Analyse de dispo metro. J+1 RE CB' ,automanu = 'M' ,edit = 'O' ,maq = ' ' ,nomprc = '2976QCMOE7' ,ord = 1 ,contin = 'N' ,code_maq = ' ' ,datmod = '20120215' ,utimod = 'GNC' ,codsoc = 100 ,nommaq = '#TRT@ap$maq:qdispodlc.j1' ,numpere = 0 ,codpled = ' ' ,etape = 421 ,posext = 0 ,eshs = 'ES' ,nummes = 0 ,attr = 0 where codsoc = 100 and numero = 2976 ;
update ut_spl set fct = 'QCMOE7' ,uti = 'GNC' ,datact = '20120215' ,heuact = '1208' ,datdeb = '20120215' ,heudeb = '1209' ,datfin = '20120215' ,heufin = '1209' ,page = 6 ,st1 = 3 ,st2 = ' ' ,fprint = 'ISUC37' ,batch = 'EXPS5C' ,nbi = 1 ,forma = 'S5' ,afct = 'QCMO' ,auti = ' ' ,numero = 2976 ,nbc = 1 ,dir = '#trt@ap$spl:' ,tfc = 'Analyse de dispo metro. J+1 RE CB' ,automanu = 'M' ,edit = 'O' ,maq = ' ' ,nomprc = '2976QCMOE7' ,ord = 1 ,contin = 'N' ,code_maq = ' ' ,datmod = '20120215' ,utimod = 'GNC' ,codsoc = 100 ,nommaq = '#TRT@ap$maq:qdispodlc.j1' ,numpere = 0 ,codpled = ' ' ,etape = 440 ,posext = 0 ,eshs = 'ES' ,nummes = 0 ,attr = 0 where codsoc = 100 and numero = 2976 ;
select codtbl ,cletbl ,lib1 ,lib2 ,lib3 ,lir ,num1 ,num2 ,num3 ,dec1 ,dec2 ,dec3 ,datmod ,utimod ,codsoc ,lib4 ,lib5 ,lib6 ,lib7 ,lib8 ,lib9 ,lib10 ,num4 ,num5 ,num6 ,num7 ,num8 ,num9 ,num10 ,dec4 ,dec5 ,dec6 ,dec7 ,dec8 ,dec9 ,dec10 ,dat1 ,dat2 ,dat3 ,dat4 ,dat5 ,dat6 ,dat7 ,dat8 ,dat9 ,dat10 ,filtre_tbl ,z40l_1 ,z40l_2 ,z40l_3 ,z40l_4 ,z40l_5 ,z40l_6 ,z40l_7 ,z40l_8 ,z40l_9 ,z40l_10 from tbl where codsoc = 100 and codtbl = 'zon' and cletbl LIKE 'EVE%' order by codsoc ASC,codtbl ASC,cletbl ASC;
select codtbl ,cletbl ,lib1 ,lib2 ,lib3 ,lir ,num1 ,num2 ,num3 ,dec1 ,dec2 ,dec3 ,datmod ,utimod ,codsoc ,lib4 ,lib5 ,lib6 ,lib7 ,lib8 ,lib9 ,lib10 ,num4 ,num5 ,num6 ,num7 ,num8 ,num9 ,num10 ,dec4 ,dec5 ,dec6 ,dec7 ,dec8 ,dec9 ,dec10 ,dat1 ,dat2 ,dat3 ,dat4 ,dat5 ,dat6 ,dat7 ,dat8 ,dat9 ,dat10 ,filtre_tbl ,z40l_1 ,z40l_2 ,z40l_3 ,z40l_4 ,z40l_5 ,z40l_6 ,z40l_7 ,z40l_8 ,z40l_9 ,z40l_10 from tbl where codsoc = 100 and codtbl = 'zon' and cletbl LIKE 'EVP%' order by codsoc ASC,codtbl ASC,cletbl ASC;
select codpro ,motcle ,fampro ,sfapro ,ssfpro ,nompro ,gencod ,coddou ,typpro ,exicot ,codtva ,coduni ,qtemin ,codtax ,codtax2 ,sigdep ,codrea ,suistk ,prostk ,delpre ,suistt ,claabc ,datmar ,poids ,haute ,large ,longue ,volume ,codtar ,design1 ,design2 ,design3 ,typtar ,sigfou ,datmod ,utimod ,refpro ,numvar ,tpsmon ,indcom ,va ,vl ,coduvc ,codue ,nbucue ,pcb ,unipcb ,spcb ,unispcb ,codzn1 ,codzn2 ,codzn3 ,codzn4 ,codzn5 ,codzn6 ,codzn7 ,codzn8 ,codzn9 ,codzn10 ,codzn11 ,codzn12 ,codzn13 ,codzn14 ,codzn15 ,codzn16 ,unicol ,colec1 ,stck1 ,colec2 ,stck2 ,colec3 ,stck3 ,colec4 ,stck4 ,colec5 ,stck5 ,colec6 ,stck6 ,colec7 ,stck7 ,colec8 ,stck8 ,colec9 ,stck9 ,design4 ,design5 ,design6 ,design7 ,design8 ,design9 ,design10 ,design11 ,design12 ,coddev ,codblocage ,poidsnet ,typaff ,qotite ,unista ,prosta ,indcts ,indris ,valpvr ,pdspvr ,volpvr ,numlsk ,codsoc ,delrea ,datcre ,etbcod ,etsstatut ,codconv ,claabcp ,delper ,suiins ,suiice ,nomise ,uniice ,typifa ,uniper ,delgar ,unigar ,achice ,typice ,sigice ,verice ,prorub ,teecod ,teeuni ,teeprx ,modlot ,codpay ,ttaice ,codmdl ,proref ,suiref ,repart ,codunic ,typref ,datfinmar ,natpro ,rglarr ,margemini ,mcalcvc ,nbjcvc ,nivrot ,modappro ,codsoc_phy ,sssfp1 ,sssfp2 ,sssfp3 ,sssfp4 ,sssfp5 ,sssfp6 ,sssfp7 from pro where codsoc = 100 and codpro = '213230002' ;
select achvte ,typeve ,numeve ,numpos ,numlig ,datliv ,codsta ,numadr ,modliv ,sigtra ,modtra ,sigdep ,numlot ,qteliv ,qtecde ,typevo ,numevo ,numpoo ,numlio ,nbrcol ,datmod ,utimod ,achvto ,achvts ,typevs ,numevs ,numposs ,numlis ,perliv ,datval ,datexp ,perval ,perexp ,annliv ,annval ,annexp ,qtesup1 ,qtesup2 ,qtesup3 ,indver ,delliv ,deleng ,dateng ,codemp ,numadr_dep ,libcom ,qteperdu ,ordevs ,indapr ,typliv ,sigliv ,codsoc ,modloc ,codtrn ,codpro ,codrgp ,qtesup4 ,qtesup5 ,qtesup6 ,numadr_i ,achvteise ,typise ,numise ,numipa ,numisp ,sigtrs ,batvol ,cmpnie ,nlta ,datdep ,datarr ,heuarr ,heudep ,codfct ,codpev from evl where codsoc = 100 and achvte = 'V' and typeve = 'CDE' and numeve = 1367250 and numpos = 11 and numlig = 1 ;
select sigdep ,codpro ,libstk ,codemp ,coduni ,datcre ,datper ,datpmp ,pump ,valpump ,datdpa ,dpa ,valdpa ,codrea ,codcrb ,css ,cso ,cpc ,cqe ,perinv ,numinv ,datinv ,datpin ,c01 ,c02 ,c03 ,c04 ,c05 ,c06 ,c07 ,c08 ,c09 ,c10 ,c11 ,c12 ,c13 ,c14 ,datmsk ,nummsk ,datmod ,utimod ,qtemin ,qotite ,typaff ,codsoc ,suistk ,codsoc_phy ,statut ,nompor ,lmodcol ,clsinv ,modent ,modsor ,gesnumlot ,gesnumser ,typfifo ,tolfifo ,unttolfifo ,tolpds ,retention ,durdlv ,untdurdlv ,durdluo ,untdurdluo ,durdlc ,untdurdlc ,codemp1 ,codemp2 ,nbremp ,gespick ,occmax1 ,cnttyp ,cntcod ,clavol ,lcodmag ,nbremp1 ,mcalcvc ,nbjcvc ,nivrot ,modappro ,sigtie_ser ,delrea ,delsup ,delpre ,delsec ,claabc ,claabcp ,typtie_ser from dsk where codsoc = 100 and codpro = '213230002' and sigdep = ' ' ;
select codtbl ,cletbl ,lib1 ,lib2 ,lib3 ,lir ,num1 ,num2 ,num3 ,dec1 ,dec2 ,dec3 ,datmod ,utimod ,codsoc ,lib4 ,lib5 ,lib6 ,lib7 ,lib8 ,lib9 ,lib10 ,num4 ,num5 ,num6 ,num7 ,num8 ,num9 ,num10 ,dec4 ,dec5 ,dec6 ,dec7 ,dec8 ,dec9 ,dec10 ,dat1 ,dat2 ,dat3 ,dat4 ,dat5 ,dat6 ,dat7 ,dat8 ,dat9 ,dat10 ,filtre_tbl ,z40l_1 ,z40l_2 ,z40l_3 ,z40l_4 ,z40l_5 ,z40l_6 ,z40l_7 ,z40l_8 ,z40l_9 ,z40l_10 from tbl where codsoc = 1 and codtbl = 'dev' and cletbl = 'FRF' ;
select codpro ,motcle ,fampro ,sfapro ,ssfpro ,nompro ,gencod ,coddou ,typpro ,exicot ,codtva ,coduni ,qtemin ,codtax ,codtax2 ,sigdep ,codrea ,suistk ,prostk ,delpre ,suistt ,claabc ,datmar ,poids ,haute ,large ,longue ,volume ,codtar ,design1 ,design2 ,design3 ,typtar ,sigfou ,datmod ,utimod ,refpro ,numvar ,tpsmon ,indcom ,va ,vl ,coduvc ,codue ,nbucue ,pcb ,unipcb ,spcb ,unispcb ,codzn1 ,codzn2 ,codzn3 ,codzn4 ,codzn5 ,codzn6 ,codzn7 ,codzn8 ,codzn9 ,codzn10 ,codzn11 ,codzn12 ,codzn13 ,codzn14 ,codzn15 ,codzn16 ,unicol ,colec1 ,stck1 ,colec2 ,stck2 ,colec3 ,stck3 ,colec4 ,stck4 ,colec5 ,stck5 ,colec6 ,stck6 ,colec7 ,stck7 ,colec8 ,stck8 ,colec9 ,stck9 ,design4 ,design5 ,design6 ,design7 ,design8 ,design9 ,design10 ,design11 ,design12 ,coddev ,codblocage ,poidsnet ,typaff ,qotite ,unista ,prosta ,indcts ,indris ,valpvr ,pdspvr ,volpvr ,numlsk ,codsoc ,delrea ,datcre ,etbcod ,etsstatut ,codconv ,claabcp ,delper ,suiins ,suiice ,nomise ,uniice ,typifa ,uniper ,delgar ,unigar ,achice ,typice ,sigice ,verice ,prorub ,teecod ,teeuni ,teeprx ,modlot ,codpay ,ttaice ,codmdl ,proref ,suiref ,repart ,codunic ,typref ,datfinmar ,natpro ,rglarr ,margemini ,mcalcvc ,nbjcvc ,nivrot ,modappro ,codsoc_phy ,sssfp1 ,sssfp2 ,sssfp3 ,sssfp4 ,sssfp5 ,sssfp6 ,sssfp7 from pro where codsoc = 100 and codpro = '213230002' ;
select sigdep ,codpro ,libstk ,codemp ,coduni ,datcre ,datper ,datpmp ,pump ,valpump ,datdpa ,dpa ,valdpa ,codrea ,codcrb ,css ,cso ,cpc ,cqe ,perinv ,numinv ,datinv ,datpin ,c01 ,c02 ,c03 ,c04 ,c05 ,c06 ,c07 ,c08 ,c09 ,c10 ,c11 ,c12 ,c13 ,c14 ,datmsk ,nummsk ,datmod ,utimod ,qtemin ,qotite ,typaff ,codsoc ,suistk ,codsoc_phy ,statut ,nompor ,lmodcol ,clsinv ,modent ,modsor ,gesnumlot ,gesnumser ,typfifo ,tolfifo ,unttolfifo ,tolpds ,retention ,durdlv ,untdurdlv ,durdluo ,untdurdluo ,durdlc ,untdurdlc ,codemp1 ,codemp2 ,nbremp ,gespick ,occmax1 ,cnttyp ,cntcod ,clavol ,lcodmag ,nbremp1 ,mcalcvc ,nbjcvc ,nivrot ,modappro ,sigtie_ser ,delrea ,delsup ,delpre ,delsec ,claabc ,claabcp ,typtie_ser from dsk where codsoc = 100 and codpro = '213230002' and sigdep = '99' ;
select sigdep ,codpro ,numlot ,libstk ,codemp ,datcre ,datper ,c01 ,c02 ,c03 ,c04 ,c05 ,c06 ,c07 ,c08 ,c09 ,c10 ,c11 ,c12 ,c13 ,c14 ,datmsk ,nummsk ,pump ,datpmp ,valpump ,dpa ,datdpa ,valdpa ,datmod ,utimod ,coduni ,codrea ,codcrb ,css ,cso ,cpc ,cqe ,perinv ,numinv ,datinv ,datpin ,codsoc ,qtelsk from lsk where codsoc = 100 and sigdep = '99' and codpro = '213230002' order by codsoc ASC,sigdep ASC,codpro ASC,numlot ASC;
select codut_mes ,lan ,libut_mes ,gra ,val ,bip ,trace ,affi ,soft ,typut_mes ,datmod ,utimod ,codsoc ,codlan from ut_mes where codsoc = 1 and codut_mes = 'ELT_PASTRO' and codlan = 'FRA' ;
select typtie ,sigtie ,nomtie ,adrcom ,cpttie ,nombqe ,codbqe ,guiche ,cptbqe ,clerib ,coddpt ,modrgl ,delrgl ,codqua ,tauesc ,encmax ,encass ,anccde ,encfac ,enceff ,encenc ,perfac ,nbrfac ,edicot ,facrel ,posfis ,forfai ,editrt ,indsup ,codinc ,datmod ,utimod ,typfac ,famtie ,codbar ,coddev ,sigrep ,siggrp ,codlan ,mincde ,sigdep ,sigtra ,modliv ,relica ,sigach ,propri ,socges ,delrea ,blocliv ,libloc ,surfac ,surfres ,colec ,typtpv ,commer ,machin ,bqedom ,bqetra ,plafon ,fil ,codreg ,modtra ,codzn1 ,codzn2 ,codzn3 ,codzn4 ,codzn5 ,codzn6 ,codzn7 ,codzn8 ,codzn9 ,codzn10 ,codzn11 ,codzn12 ,codzn13 ,codzn14 ,codzn15 ,codzn16 ,codett ,datcre ,typgrp ,typrep ,cnufd ,nbcai ,indcat ,dreftar ,enseigne ,indref ,nbrjour ,numfil ,minfra ,dateve ,p_tietcp ,p_tiesig ,p_3ctcod ,p_3g1cod ,p_3g2cod ,p_3g3cod ,p_3g4cod ,p_3g5cod ,p_ribcodp ,codsoc ,p_tietpa ,p_tiespay ,p_3fccod ,p_tiebap ,p_tieintgr ,p_tielet ,etbcod ,etsstatut ,datexp ,calrea ,p_tiegrp ,moyrgl ,p_tiebim ,datinc ,indtim ,sigtrs ,guidrgl ,telven ,p_tieesc ,achvte_cat ,codcat ,datprc_cde ,nbjcde ,delsec ,codsoc_phy from tie where codsoc = 100 and typtie = 'DEP' and sigtie = '99' ;
select typtie ,sigtie ,nomtie ,adrcom ,cpttie ,nombqe ,codbqe ,guiche ,cptbqe ,clerib ,coddpt ,modrgl ,delrgl ,codqua ,tauesc ,encmax ,encass ,anccde ,encfac ,enceff ,encenc ,perfac ,nbrfac ,edicot ,facrel ,posfis ,forfai ,editrt ,indsup ,codinc ,datmod ,utimod ,typfac ,famtie ,codbar ,coddev ,sigrep ,siggrp ,codlan ,mincde ,sigdep ,sigtra ,modliv ,relica ,sigach ,propri ,socges ,delrea ,blocliv ,libloc ,surfac ,surfres ,colec ,typtpv ,commer ,machin ,bqedom ,bqetra ,plafon ,fil ,codreg ,modtra ,codzn1 ,codzn2 ,codzn3 ,codzn4 ,codzn5 ,codzn6 ,codzn7 ,codzn8 ,codzn9 ,codzn10 ,codzn11 ,codzn12 ,codzn13 ,codzn14 ,codzn15 ,codzn16 ,codett ,datcre ,typgrp ,typrep ,cnufd ,nbcai ,indcat ,dreftar ,enseigne ,indref ,nbrjour ,numfil ,minfra ,dateve ,p_tietcp ,p_tiesig ,p_3ctcod ,p_3g1cod ,p_3g2cod ,p_3g3cod ,p_3g4cod ,p_3g5cod ,p_ribcodp ,codsoc ,p_tietpa ,p_tiespay ,p_3fccod ,p_tiebap ,p_tieintgr ,p_tielet ,etbcod ,etsstatut ,datexp ,calrea ,p_tiegrp ,moyrgl ,p_tiebim ,datinc ,indtim ,sigtrs ,guidrgl ,telven ,p_tieesc ,achvte_cat ,codcat ,datprc_cde ,nbjcde ,delsec ,codsoc_phy from tie where codsoc = 100 and typtie = 'REP' and sigtie = 'S800' ;
select achvte ,typeve ,numeve ,sigtie ,typtie ,numver ,dateve ,datval ,datcre ,datliv ,typevo ,numevo ,nbrfac ,typfac ,codurg ,codeta ,codctg ,refext ,numcnt ,coddev ,pardev ,numadr ,modliv ,sigtra ,modtra ,nbrrel ,numrel ,dataco ,monaco ,tauesc ,datcli ,codblo ,datblo ,exicvc ,exicvm ,exitxt ,cumht ,cumttc ,sigrep ,codana ,modrgl ,delrgl ,coddpt ,codqua ,totcol ,sigdep ,datmod ,utimod ,posfis ,totht ,codtva ,cumpr ,libcom ,taurem ,monrem ,codana1 ,codana2 ,taucom ,typrem ,achvto ,perfac ,camion ,indapr ,totttc ,datedi ,indedi ,indsol ,achvts ,typevs ,numevs ,pereve ,perliv ,indepu ,codbar ,datexp ,perval ,perexp ,anneve ,annliv ,annval ,annexp ,achbch ,typbch ,numbch ,indint ,delliv ,deleng ,sigmag ,datrgl ,codtrn ,codpos ,monremfac ,taurem2 ,taurem3 ,dateng ,sigact ,geleve ,poshie ,editrt ,sigval ,ordevs ,batiment ,typliv ,sigliv ,numatt ,codsoc ,modloc ,facrel ,codass ,edicts ,relica ,etbcod ,etsstatut ,achvtt ,codsit1 ,numvoy ,numfil ,tauagio ,monesc ,monagio ,tauescd ,ncotat ,tauca ,p_ribcod ,p_ecrnum ,codeop ,numadr_i ,achvteise ,typise ,numise ,sigtrs ,numlcr ,batvol ,cmpnie ,nlta ,datdep ,datarr ,heuarr ,heudep ,guidrgl ,achvte_cat ,codcat ,heuexp1 ,heuexp2 ,heueve ,heuvali ,heuliv1 ,heuliv2 ,typgel ,numgel ,codrgm ,codvhc ,chrono ,numctc ,typcpr ,codcb ,statut6 from eve where codsoc = 100 and achvte = 'V' and typeve = 'CDE' and numeve = 1367250 ;
select codtbl ,cletbl ,lib1 ,lib2 ,lib3 ,lir ,num1 ,num2 ,num3 ,dec1 ,dec2 ,dec3 ,datmod ,utimod ,codsoc ,lib4 ,lib5 ,lib6 ,lib7 ,lib8 ,lib9 ,lib10 ,num4 ,num5 ,num6 ,num7 ,num8 ,num9 ,num10 ,dec4 ,dec5 ,dec6 ,dec7 ,dec8 ,dec9 ,dec10 ,dat1 ,dat2 ,dat3 ,dat4 ,dat5 ,dat6 ,dat7 ,dat8 ,dat9 ,dat10 ,filtre_tbl ,z40l_1 ,z40l_2 ,z40l_3 ,z40l_4 ,z40l_5 ,z40l_6 ,z40l_7 ,z40l_8 ,z40l_9 ,z40l_10 from tbl where codsoc = 1 and codtbl = 'mrg' and cletbl = 'BO' ;
select codtbl ,cletbl ,lib1 ,lib2 ,lib3 ,lir ,num1 ,num2 ,num3 ,dec1 ,dec2 ,dec3 ,datmod ,utimod ,codsoc ,lib4 ,lib5 ,lib6 ,lib7 ,lib8 ,lib9 ,lib10 ,num4 ,num5 ,num6 ,num7 ,num8 ,num9 ,num10 ,dec4 ,dec5 ,dec6 ,dec7 ,dec8 ,dec9 ,dec10 ,dat1 ,dat2 ,dat3 ,dat4 ,dat5 ,dat6 ,dat7 ,dat8 ,dat9 ,dat10 ,filtre_tbl ,z40l_1 ,z40l_2 ,z40l_3 ,z40l_4 ,z40l_5 ,z40l_6 ,z40l_7 ,z40l_8 ,z40l_9 ,z40l_10 from tbl where codsoc = 1 and codtbl = 'dpt' and cletbl = 'H' ;
select typtie ,sigtie ,nomtie ,adrcom ,cpttie ,nombqe ,codbqe ,guiche ,cptbqe ,clerib ,coddpt ,modrgl ,delrgl ,codqua ,tauesc ,encmax ,encass ,anccde ,encfac ,enceff ,encenc ,perfac ,nbrfac ,edicot ,facrel ,posfis ,forfai ,editrt ,indsup ,codinc ,datmod ,utimod ,typfac ,famtie ,codbar ,coddev ,sigrep ,siggrp ,codlan ,mincde ,sigdep ,sigtra ,modliv ,relica ,sigach ,propri ,socges ,delrea ,blocliv ,libloc ,surfac ,surfres ,colec ,typtpv ,commer ,machin ,bqedom ,bqetra ,plafon ,fil ,codreg ,modtra ,codzn1 ,codzn2 ,codzn3 ,codzn4 ,codzn5 ,codzn6 ,codzn7 ,codzn8 ,codzn9 ,codzn10 ,codzn11 ,codzn12 ,codzn13 ,codzn14 ,codzn15 ,codzn16 ,codett ,datcre ,typgrp ,typrep ,cnufd ,nbcai ,indcat ,dreftar ,enseigne ,indref ,nbrjour ,numfil ,minfra ,dateve ,p_tietcp ,p_tiesig ,p_3ctcod ,p_3g1cod ,p_3g2cod ,p_3g3cod ,p_3g4cod ,p_3g5cod ,p_ribcodp ,codsoc ,p_tietpa ,p_tiespay ,p_3fccod ,p_tiebap ,p_tieintgr ,p_tielet ,etbcod ,etsstatut ,datexp ,calrea ,p_tiegrp ,moyrgl ,p_tiebim ,datinc ,indtim ,sigtrs ,guidrgl ,telven ,p_tieesc ,achvte_cat ,codcat ,datprc_cde ,nbjcde ,delsec ,codsoc_phy from tie where codsoc = 100 and typtie = 'CLI' and sigtie = '169706' ;
select codpro ,motcle ,fampro ,sfapro ,ssfpro ,nompro ,gencod ,coddou ,typpro ,exicot ,codtva ,coduni ,qtemin ,codtax ,codtax2 ,sigdep ,codrea ,suistk ,prostk ,delpre ,suistt ,claabc ,datmar ,poids ,haute ,large ,longue ,volume ,codtar ,design1 ,design2 ,design3 ,typtar ,sigfou ,datmod ,utimod ,refpro ,numvar ,tpsmon ,indcom ,va ,vl ,coduvc ,codue ,nbucue ,pcb ,unipcb ,spcb ,unispcb ,codzn1 ,codzn2 ,codzn3 ,codzn4 ,codzn5 ,codzn6 ,codzn7 ,codzn8 ,codzn9 ,codzn10 ,codzn11 ,codzn12 ,codzn13 ,codzn14 ,codzn15 ,codzn16 ,unicol ,colec1 ,stck1 ,colec2 ,stck2 ,colec3 ,stck3 ,colec4 ,stck4 ,colec5 ,stck5 ,colec6 ,stck6 ,colec7 ,stck7 ,colec8 ,stck8 ,colec9 ,stck9 ,design4 ,design5 ,design6 ,design7 ,design8 ,design9 ,design10 ,design11 ,design12 ,coddev ,codblocage ,poidsnet ,typaff ,qotite ,unista ,prosta ,indcts ,indris ,valpvr ,pdspvr ,volpvr ,numlsk ,codsoc ,delrea ,datcre ,etbcod ,etsstatut ,codconv ,claabcp ,delper ,suiins ,suiice ,nomise ,uniice ,typifa ,uniper ,delgar ,unigar ,achice ,typice ,sigice ,verice ,prorub ,teecod ,teeuni ,teeprx ,modlot ,codpay ,ttaice ,codmdl ,proref ,suiref ,repart ,codunic ,typref ,datfinmar ,natpro ,rglarr ,margemini ,mcalcvc ,nbjcvc ,nivrot ,modappro ,codsoc_phy ,sssfp1 ,sssfp2 ,sssfp3 ,sssfp4 ,sssfp5 ,sssfp6 ,sssfp7 from pro where codsoc = 100 and codpro = '213230002' ;
select codtbl ,cletbl ,lib1 ,lib2 ,lib3 ,lir ,num1 ,num2 ,num3 ,dec1 ,dec2 ,dec3 ,datmod ,utimod ,codsoc ,lib4 ,lib5 ,lib6 ,lib7 ,lib8 ,lib9 ,lib10 ,num4 ,num5 ,num6 ,num7 ,num8 ,num9 ,num10 ,dec4 ,dec5 ,dec6 ,dec7 ,dec8 ,dec9 ,dec10 ,dat1 ,dat2 ,dat3 ,dat4 ,dat5 ,dat6 ,dat7 ,dat8 ,dat9 ,dat10 ,filtre_tbl ,z40l_1 ,z40l_2 ,z40l_3 ,z40l_4 ,z40l_5 ,z40l_6 ,z40l_7 ,z40l_8 ,z40l_9 ,z40l_10 from tbl where codsoc = 100 and codtbl = 'tti' and cletbl = 'PRO' ;
select typtie ,codefam ,codesfa ,codessf ,libfam ,lirfam ,datmod ,utimod ,codcrb ,famrgt ,typpro ,niveau ,codsoc ,codesssf1 ,codesssf2 ,codesssf3 ,codesssf4 ,codesssf5 ,codesssf6 ,codesssf7 ,clefam from fam where codsoc = 100 and typtie = 'PRO' and niveau = 1 and codefam = '01' and codesfa = ' ' and codessf = ' ' and codesssf1 = ' ' and codesssf2 = ' ' and codesssf3 = ' ' and codesssf4 = ' ' and codesssf5 = ' ' and codesssf6 = ' ' and codesssf7 = ' ' ;
select codtbl ,cletbl ,lib1 ,lib2 ,lib3 ,lir ,num1 ,num2 ,num3 ,dec1 ,dec2 ,dec3 ,datmod ,utimod ,codsoc ,lib4 ,lib5 ,lib6 ,lib7 ,lib8 ,lib9 ,lib10 ,num4 ,num5 ,num6 ,num7 ,num8 ,num9 ,num10 ,dec4 ,dec5 ,dec6 ,dec7 ,dec8 ,dec9 ,dec10 ,dat1 ,dat2 ,dat3 ,dat4 ,dat5 ,dat6 ,dat7 ,dat8 ,dat9 ,dat10 ,filtre_tbl ,z40l_1 ,z40l_2 ,z40l_3 ,z40l_4 ,z40l_5 ,z40l_6 ,z40l_7 ,z40l_8 ,z40l_9 ,z40l_10 from tbl where codsoc = 100 and codtbl = 'trn' and cletbl = '484' ;
select codtbl ,cletbl ,lib1 ,lib2 ,lib3 ,lir ,num1 ,num2 ,num3 ,dec1 ,dec2 ,dec3 ,datmod ,utimod ,codsoc ,lib4 ,lib5 ,lib6 ,lib7 ,lib8 ,lib9 ,lib10 ,num4 ,num5 ,num6 ,num7 ,num8 ,num9 ,num10 ,dec4 ,dec5 ,dec6 ,dec7 ,dec8 ,dec9 ,dec10 ,dat1 ,dat2 ,dat3 ,dat4 ,dat5 ,dat6 ,dat7 ,dat8 ,dat9 ,dat10 ,filtre_tbl ,z40l_1 ,z40l_2 ,z40l_3 ,z40l_4 ,z40l_5 ,z40l_6 ,z40l_7 ,z40l_8 ,z40l_9 ,z40l_10 from tbl where codsoc = 100 and codtbl = 'tti' and cletbl = '050' ;
select codtbl ,cletbl ,lib1 ,lib2 ,lib3 ,lir ,num1 ,num2 ,num3 ,dec1 ,dec2 ,dec3 ,datmod ,utimod ,codsoc ,lib4 ,lib5 ,lib6 ,lib7 ,lib8 ,lib9 ,lib10 ,num4 ,num5 ,num6 ,num7 ,num8 ,num9 ,num10 ,dec4 ,dec5 ,dec6 ,dec7 ,dec8 ,dec9 ,dec10 ,dat1 ,dat2 ,dat3 ,dat4 ,dat5 ,dat6 ,dat7 ,dat8 ,dat9 ,dat10 ,filtre_tbl ,z40l_1 ,z40l_2 ,z40l_3 ,z40l_4 ,z40l_5 ,z40l_6 ,z40l_7 ,z40l_8 ,z40l_9 ,z40l_10 from tbl where codsoc = 100 and codtbl = '050' and cletbl = 'N' ;
select codtbl ,cletbl ,lib1 ,lib2 ,lib3 ,lir ,num1 ,num2 ,num3 ,dec1 ,dec2 ,dec3 ,datmod ,utimod ,codsoc ,lib4 ,lib5 ,lib6 ,lib7 ,lib8 ,lib9 ,lib10 ,num4 ,num5 ,num6 ,num7 ,num8 ,num9 ,num10 ,dec4 ,dec5 ,dec6 ,dec7 ,dec8 ,dec9 ,dec10 ,dat1 ,dat2 ,dat3 ,dat4 ,dat5 ,dat6 ,dat7 ,dat8 ,dat9 ,dat10 ,filtre_tbl ,z40l_1 ,z40l_2 ,z40l_3 ,z40l_4 ,z40l_5 ,z40l_6 ,z40l_7 ,z40l_8 ,z40l_9 ,z40l_10 from tbl where codsoc = 100 and codtbl = 'tti' and cletbl = '051' ;
select codtbl ,cletbl ,lib1 ,lib2 ,lib3 ,lir ,num1 ,num2 ,num3 ,dec1 ,dec2 ,dec3 ,datmod ,utimod ,codsoc ,lib4 ,lib5 ,lib6 ,lib7 ,lib8 ,lib9 ,lib10 ,num4 ,num5 ,num6 ,num7 ,num8 ,num9 ,num10 ,dec4 ,dec5 ,dec6 ,dec7 ,dec8 ,dec9 ,dec10 ,dat1 ,dat2 ,dat3 ,dat4 ,dat5 ,dat6 ,dat7 ,dat8 ,dat9 ,dat10 ,filtre_tbl ,z40l_1 ,z40l_2 ,z40l_3 ,z40l_4 ,z40l_5 ,z40l_6 ,z40l_7 ,z40l_8 ,z40l_9 ,z40l_10 from tbl where codsoc = 100 and codtbl = '051' and cletbl = 'MET' ;
select codtbl ,cletbl ,lib1 ,lib2 ,lib3 ,lir ,num1 ,num2 ,num3 ,dec1 ,dec2 ,dec3 ,datmod ,utimod ,codsoc ,lib4 ,lib5 ,lib6 ,lib7 ,lib8 ,lib9 ,lib10 ,num4 ,num5 ,num6 ,num7 ,num8 ,num9 ,num10 ,dec4 ,dec5 ,dec6 ,dec7 ,dec8 ,dec9 ,dec10 ,dat1 ,dat2 ,dat3 ,dat4 ,dat5 ,dat6 ,dat7 ,dat8 ,dat9 ,dat10 ,filtre_tbl ,z40l_1 ,z40l_2 ,z40l_3 ,z40l_4 ,z40l_5 ,z40l_6 ,z40l_7 ,z40l_8 ,z40l_9 ,z40l_10 from tbl where codsoc = 100 and codtbl = 'tti' and cletbl = '052' ;
select codtbl ,cletbl ,lib1 ,lib2 ,lib3 ,lir ,num1 ,num2 ,num3 ,dec1 ,dec2 ,dec3 ,datmod ,utimod ,codsoc ,lib4 ,lib5 ,lib6 ,lib7 ,lib8 ,lib9 ,lib10 ,num4 ,num5 ,num6 ,num7 ,num8 ,num9 ,num10 ,dec4 ,dec5 ,dec6 ,dec7 ,dec8 ,dec9 ,dec10 ,dat1 ,dat2 ,dat3 ,dat4 ,dat5 ,dat6 ,dat7 ,dat8 ,dat9 ,dat10 ,filtre_tbl ,z40l_1 ,z40l_2 ,z40l_3 ,z40l_4 ,z40l_5 ,z40l_6 ,z40l_7 ,z40l_8 ,z40l_9 ,z40l_10 from tbl where codsoc = 100 and codtbl = '052' and cletbl = 'C' ;
select codcal ,annee ,numper ,datdeb ,datfin ,codrgp ,datmod ,utimod ,reftro ,codsoc ,p_1capeta ,p_1capnjd ,p_1capnjf ,dat1 ,dat2 ,dat3 ,dat4 ,indano ,indcde ,heulim1 ,delai1 ,heuliv1 ,heulim2 ,delai2 ,heuliv2 ,codtrn ,val01 ,val02 ,val03 ,val04 ,val05 from cap where codsoc = 100 and codcal = 'STK' and annee = 2011 and numper = 257 ;
select codcal ,annee ,numper ,datdeb ,datfin ,codrgp ,datmod ,utimod ,reftro ,codsoc ,p_1capeta ,p_1capnjd ,p_1capnjf ,dat1 ,dat2 ,dat3 ,dat4 ,indano ,indcde ,heulim1 ,delai1 ,heuliv1 ,heulim2 ,delai2 ,heuliv2 ,codtrn ,val01 ,val02 ,val03 ,val04 ,val05 from cap where codsoc = 100 and codcal = 'STK' and annee = 2011 and numper = 258 ;
select codcal ,annee ,numper ,datdeb ,datfin ,codrgp ,datmod ,utimod ,reftro ,codsoc ,p_1capeta ,p_1capnjd ,p_1capnjf ,dat1 ,dat2 ,dat3 ,dat4 ,indano ,indcde ,heulim1 ,delai1 ,heuliv1 ,heulim2 ,delai2 ,heuliv2 ,codtrn ,val01 ,val02 ,val03 ,val04 ,val05 from cap where codsoc = 100 and codcal = 'STK' and annee = 2011 and numper = 258 ;
select fct ,uti ,datact ,heuact ,datdeb ,heudeb ,datfin ,heufin ,page ,st1 ,st2 ,fprint ,batch ,nbi ,forma ,afct ,auti ,numero ,nbc ,dir ,tfc ,automanu ,edit ,maq ,nomprc ,ord ,contin ,code_maq ,datmod ,utimod ,codsoc ,nommaq ,numpere ,codpled ,etape ,posext ,eshs ,nummes ,attr from ut_spl where codsoc = 100 and numero = 2976 ;
select typtie ,sigtie ,nomtie ,adrcom ,cpttie ,nombqe ,codbqe ,guiche ,cptbqe ,clerib ,coddpt ,modrgl ,delrgl ,codqua ,tauesc ,encmax ,encass ,anccde ,encfac ,enceff ,encenc ,perfac ,nbrfac ,edicot ,facrel ,posfis ,forfai ,editrt ,indsup ,codinc ,datmod ,utimod ,typfac ,famtie ,codbar ,coddev ,sigrep ,siggrp ,codlan ,mincde ,sigdep ,sigtra ,modliv ,relica ,sigach ,propri ,socges ,delrea ,blocliv ,libloc ,surfac ,surfres ,colec ,typtpv ,commer ,machin ,bqedom ,bqetra ,plafon ,fil ,codreg ,modtra ,codzn1 ,codzn2 ,codzn3 ,codzn4 ,codzn5 ,codzn6 ,codzn7 ,codzn8 ,codzn9 ,codzn10 ,codzn11 ,codzn12 ,codzn13 ,codzn14 ,codzn15 ,codzn16 ,codett ,datcre ,typgrp ,typrep ,cnufd ,nbcai ,indcat ,dreftar ,enseigne ,indref ,nbrjour ,numfil ,minfra ,dateve ,p_tietcp ,p_tiesig ,p_3ctcod ,p_3g1cod ,p_3g2cod ,p_3g3cod ,p_3g4cod ,p_3g5cod ,p_ribcodp ,codsoc ,p_tietpa ,p_tiespay ,p_3fccod ,p_tiebap ,p_tieintgr ,p_tielet ,etbcod ,etsstatut ,datexp ,calrea ,p_tiegrp ,moyrgl ,p_tiebim ,datinc ,indtim ,sigtrs ,guidrgl ,telven ,p_tieesc ,achvte_cat ,codcat ,datprc_cde ,nbjcde ,delsec ,codsoc_phy from tie where codsoc = 100 and typtie = 'SOC' and sigtie = 'CEDILAC' ;
select codsoc ,cpttie ,p_ribcod ,p_ribdev ,p_4bqcbq ,p_4bqgui ,p_ribnom ,p_ribloc ,p_ribcpt ,p_ribcle ,p_ribprinc ,datmod ,utimod ,p_ribtyp ,p_4bqbnk ,p_4bqgch ,p_ribncp ,p_ribcrib ,p_ribdeb ,p_ribfin ,p_ribtitulaire ,bic ,iban from rib where codsoc = 100 and cpttie = 'CEDILAC' and p_ribcod = '001' ;
select codcal ,annee ,numper ,datdeb ,datfin ,codrgp ,datmod ,utimod ,reftro ,codsoc ,p_1capeta ,p_1capnjd ,p_1capnjf ,dat1 ,dat2 ,dat3 ,dat4 ,indano ,indcde ,heulim1 ,delai1 ,heuliv1 ,heulim2 ,delai2 ,heuliv2 ,codtrn ,val01 ,val02 ,val03 ,val04 ,val05 from cap where codsoc = 100 and codcal = 'STK' and annee = 2011 and numper = 257 ;
select codcal ,annee ,numper ,datdeb ,datfin ,codrgp ,datmod ,utimod ,reftro ,codsoc ,p_1capeta ,p_1capnjd ,p_1capnjf ,dat1 ,dat2 ,dat3 ,dat4 ,indano ,indcde ,heulim1 ,delai1 ,heuliv1 ,heulim2 ,delai2 ,heuliv2 ,codtrn ,val01 ,val02 ,val03 ,val04 ,val05 from cap where codsoc = 100 and codcal = 'STK' and annee = 2011 and numper = 258 ;
select codcal ,annee ,numper ,datdeb ,datfin ,codrgp ,datmod ,utimod ,reftro ,codsoc ,p_1capeta ,p_1capnjd ,p_1capnjf ,dat1 ,dat2 ,dat3 ,dat4 ,indano ,indcde ,heulim1 ,delai1 ,heuliv1 ,heulim2 ,delai2 ,heuliv2 ,codtrn ,val01 ,val02 ,val03 ,val04 ,val05 from cap where codsoc = 100 and codcal = 'STK' and annee = 2011 and numper = 258 ;
select codcal ,annee ,numper ,datdeb ,datfin ,codrgp ,datmod ,utimod ,reftro ,codsoc ,p_1capeta ,p_1capnjd ,p_1capnjf ,dat1 ,dat2 ,dat3 ,dat4 ,indano ,indcde ,heulim1 ,delai1 ,heuliv1 ,heulim2 ,delai2 ,heuliv2 ,codtrn ,val01 ,val02 ,val03 ,val04 ,val05 from cap where codsoc = 100 and codcal = 'STK' and annee = 2011 and numper = 257 ;
select codcal ,annee ,numper ,datdeb ,datfin ,codrgp ,datmod ,utimod ,reftro ,codsoc ,p_1capeta ,p_1capnjd ,p_1capnjf ,dat1 ,dat2 ,dat3 ,dat4 ,indano ,indcde ,heulim1 ,delai1 ,heuliv1 ,heulim2 ,delai2 ,heuliv2 ,codtrn ,val01 ,val02 ,val03 ,val04 ,val05 from cap where codsoc = 100 and codcal = 'STK' and annee = 2011 and numper = 258 ;
select codcal ,annee ,numper ,datdeb ,datfin ,codrgp ,datmod ,utimod ,reftro ,codsoc ,p_1capeta ,p_1capnjd ,p_1capnjf ,dat1 ,dat2 ,dat3 ,dat4 ,indano ,indcde ,heulim1 ,delai1 ,heuliv1 ,heulim2 ,delai2 ,heuliv2 ,codtrn ,val01 ,val02 ,val03 ,val04 ,val05 from cap where codsoc = 100 and codcal = 'STK' and annee = 2011 and numper = 258 ;
select codcal ,annee ,numper ,datdeb ,datfin ,codrgp ,datmod ,utimod ,reftro ,codsoc ,p_1capeta ,p_1capnjd ,p_1capnjf ,dat1 ,dat2 ,dat3 ,dat4 ,indano ,indcde ,heulim1 ,delai1 ,heuliv1 ,heulim2 ,delai2 ,heuliv2 ,codtrn ,val01 ,val02 ,val03 ,val04 ,val05 from cap where codsoc = 100 and codcal = 'STK' and annee = 2011 and numper = 257 ;
select codcal ,annee ,numper ,datdeb ,datfin ,codrgp ,datmod ,utimod ,reftro ,codsoc ,p_1capeta ,p_1capnjd ,p_1capnjf ,dat1 ,dat2 ,dat3 ,dat4 ,indano ,indcde ,heulim1 ,delai1 ,heuliv1 ,heulim2 ,delai2 ,heuliv2 ,codtrn ,val01 ,val02 ,val03 ,val04 ,val05 from cap where codsoc = 100 and codcal = 'STK' and annee = 2011 and numper = 258 ;
select codcal ,annee ,numper ,datdeb ,datfin ,codrgp ,datmod ,utimod ,reftro ,codsoc ,p_1capeta ,p_1capnjd ,p_1capnjf ,dat1 ,dat2 ,dat3 ,dat4 ,indano ,indcde ,heulim1 ,delai1 ,heuliv1 ,heulim2 ,delai2 ,heuliv2 ,codtrn ,val01 ,val02 ,val03 ,val04 ,val05 from cap where codsoc = 100 and codcal = 'STK' and annee = 2011 and numper = 258 ;
select achvte ,typeve ,numeve ,numpos ,commen1 ,commen2 ,commen3 ,commen4 ,commen5 ,commen6 ,commen7 ,commen8 ,commen9 ,commen10 ,numlig ,numspo ,datmod ,utimod ,codnme ,numblo ,tel ,coddoc ,codori ,datcre ,datval ,poids ,poidsnet ,frdtra ,codzn1 ,codzn2 ,codzn3 ,codzn4 ,codzn5 ,codzn6 ,codzn7 ,codzn8 ,codzn9 ,codzn10 ,codzn11 ,codzn12 ,codzn13 ,codzn14 ,codzn15 ,codzn16 ,codzn17 ,codzn18 ,codzn19 ,codzn20 ,coddoc1 ,coddoc2 ,coddoc3 ,coddoc4 ,coddoc5 ,coddoc6 ,coddoc7 ,coddoc8 ,coddoc9 ,volevt ,dattar ,codsoc ,longue ,large ,haute from evt where codsoc = 100 and achvte = 'V' and typeve = 'CDE' and numeve = 1367250 and numpos = 11 and numlig = 0 and numspo = 0 and numblo = 0 ;
select codtbl ,cletbl ,lib1 ,lib2 ,lib3 ,lir ,num1 ,num2 ,num3 ,dec1 ,dec2 ,dec3 ,datmod ,utimod ,codsoc ,lib4 ,lib5 ,lib6 ,lib7 ,lib8 ,lib9 ,lib10 ,num4 ,num5 ,num6 ,num7 ,num8 ,num9 ,num10 ,dec4 ,dec5 ,dec6 ,dec7 ,dec8 ,dec9 ,dec10 ,dat1 ,dat2 ,dat3 ,dat4 ,dat5 ,dat6 ,dat7 ,dat8 ,dat9 ,dat10 ,filtre_tbl ,z40l_1 ,z40l_2 ,z40l_3 ,z40l_4 ,z40l_5 ,z40l_6 ,z40l_7 ,z40l_8 ,z40l_9 ,z40l_10 from tbl where codsoc = 100 and codtbl = 'tti' and cletbl = 'DEP' ;
select typtie ,sigtie ,nomtie ,adrcom ,cpttie ,nombqe ,codbqe ,guiche ,cptbqe ,clerib ,coddpt ,modrgl ,delrgl ,codqua ,tauesc ,encmax ,encass ,anccde ,encfac ,enceff ,encenc ,perfac ,nbrfac ,edicot ,facrel ,posfis ,forfai ,editrt ,indsup ,codinc ,datmod ,utimod ,typfac ,famtie ,codbar ,coddev ,sigrep ,siggrp ,codlan ,mincde ,sigdep ,sigtra ,modliv ,relica ,sigach ,propri ,socges ,delrea ,blocliv ,libloc ,surfac ,surfres ,colec ,typtpv ,commer ,machin ,bqedom ,bqetra ,plafon ,fil ,codreg ,modtra ,codzn1 ,codzn2 ,codzn3 ,codzn4 ,codzn5 ,codzn6 ,codzn7 ,codzn8 ,codzn9 ,codzn10 ,codzn11 ,codzn12 ,codzn13 ,codzn14 ,codzn15 ,codzn16 ,codett ,datcre ,typgrp ,typrep ,cnufd ,nbcai ,indcat ,dreftar ,enseigne ,indref ,nbrjour ,numfil ,minfra ,dateve ,p_tietcp ,p_tiesig ,p_3ctcod ,p_3g1cod ,p_3g2cod ,p_3g3cod ,p_3g4cod ,p_3g5cod ,p_ribcodp ,codsoc ,p_tietpa ,p_tiespay ,p_3fccod ,p_tiebap ,p_tieintgr ,p_tielet ,etbcod ,etsstatut ,datexp ,calrea ,p_tiegrp ,moyrgl ,p_tiebim ,datinc ,indtim ,sigtrs ,guidrgl ,telven ,p_tieesc ,achvte_cat ,codcat ,datprc_cde ,nbjcde ,delsec ,codsoc_phy from tie where codsoc = 100 and typtie = 'DEP' and sigtie = '99' ;
select typtie ,sigtie ,nomtie ,adrcom ,cpttie ,nombqe ,codbqe ,guiche ,cptbqe ,clerib ,coddpt ,modrgl ,delrgl ,codqua ,tauesc ,encmax ,encass ,anccde ,encfac ,enceff ,encenc ,perfac ,nbrfac ,edicot ,facrel ,posfis ,forfai ,editrt ,indsup ,codinc ,datmod ,utimod ,typfac ,famtie ,codbar ,coddev ,sigrep ,siggrp ,codlan ,mincde ,sigdep ,sigtra ,modliv ,relica ,sigach ,propri ,socges ,delrea ,blocliv ,libloc ,surfac ,surfres ,colec ,typtpv ,commer ,machin ,bqedom ,bqetra ,plafon ,fil ,codreg ,modtra ,codzn1 ,codzn2 ,codzn3 ,codzn4 ,codzn5 ,codzn6 ,codzn7 ,codzn8 ,codzn9 ,codzn10 ,codzn11 ,codzn12 ,codzn13 ,codzn14 ,codzn15 ,codzn16 ,codett ,datcre ,typgrp ,typrep ,cnufd ,nbcai ,indcat ,dreftar ,enseigne ,indref ,nbrjour ,numfil ,minfra ,dateve ,p_tietcp ,p_tiesig ,p_3ctcod ,p_3g1cod ,p_3g2cod ,p_3g3cod ,p_3g4cod ,p_3g5cod ,p_ribcodp ,codsoc ,p_tietpa ,p_tiespay ,p_3fccod ,p_tiebap ,p_tieintgr ,p_tielet ,etbcod ,etsstatut ,datexp ,calrea ,p_tiegrp ,moyrgl ,p_tiebim ,datinc ,indtim ,sigtrs ,guidrgl ,telven ,p_tieesc ,achvte_cat ,codcat ,datprc_cde ,nbjcde ,delsec ,codsoc_phy from tie where codsoc = 100 and typtie = 'DEP' and sigtie = '99' ;
select achvte ,typeve ,numeve ,numpos ,codpro ,qtecde ,codtva ,codreg ,codbar ,coduni ,prxtav ,prxbrt ,typrem ,ristou ,taurem1 ,taurem2 ,taurem3 ,prxvdu ,prxbas ,prxfrc ,exilig ,exicvc ,exitxt ,typevo ,numevo ,numpoo ,codtax ,datmod ,utimod ,codva1 ,codva2 ,prxrev ,libcom ,sigrep ,codana ,codana1 ,codana2 ,prkit ,pvkit ,achvto ,prxrevcom ,taucom ,achvts ,typevs ,numevs ,numposs ,cptgen ,disponib ,sigmag ,primpro ,qtegrt ,qtegrtliv ,unifac ,qteperdu ,qteliv ,ordevs ,qteuf ,prxuf ,coduf ,codsoc ,codass ,delpro ,delneg ,mtdroit ,txdroit ,tauca ,codfis ,indris ,tax1 ,tax2 ,achice ,typice ,sigice ,verice ,numpos_ice ,prxpvc ,coef ,codics ,codics2 ,typpst ,codpay ,codlit ,achvte_cat ,codcat ,refext ,numcnt ,prxtavfac ,prxbrtfac ,prxpvp ,prxpvg ,codeop ,statut6 from evp where codsoc = 100 and achvte = 'V' and typeve = 'CDE' and numeve = 1367250 and numpos = 11 ;
select codcal ,annee ,numper ,datdeb ,datfin ,codrgp ,datmod ,utimod ,reftro ,codsoc ,p_1capeta ,p_1capnjd ,p_1capnjf ,dat1 ,dat2 ,dat3 ,dat4 ,indano ,indcde ,heulim1 ,delai1 ,heuliv1 ,heulim2 ,delai2 ,heuliv2 ,codtrn ,val01 ,val02 ,val03 ,val04 ,val05 from cap where codsoc = 100 and codcal = 'STK' and annee = 2011 and numper = 257 ;
select codcal ,annee ,numper ,datdeb ,datfin ,codrgp ,datmod ,utimod ,reftro ,codsoc ,p_1capeta ,p_1capnjd ,p_1capnjf ,dat1 ,dat2 ,dat3 ,dat4 ,indano ,indcde ,heulim1 ,delai1 ,heuliv1 ,heulim2 ,delai2 ,heuliv2 ,codtrn ,val01 ,val02 ,val03 ,val04 ,val05 from cap where codsoc = 100 and codcal = 'STK' and annee = 2011 and numper = 258 ;
select codcal ,annee ,numper ,datdeb ,datfin ,codrgp ,datmod ,utimod ,reftro ,codsoc ,p_1capeta ,p_1capnjd ,p_1capnjf ,dat1 ,dat2 ,dat3 ,dat4 ,indano ,indcde ,heulim1 ,delai1 ,heuliv1 ,heulim2 ,delai2 ,heuliv2 ,codtrn ,val01 ,val02 ,val03 ,val04 ,val05 from cap where codsoc = 100 and codcal = 'STK' and annee = 2011 and numper = 258 ; |
Partager