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
|
Select
C.col_qual, C.col_fpos, C.col_redg, C.col_redc, C.col_sign,
C.col_mttd, C.col_mfac, C.col_pai1, C.col_sdun, C.col_cmat,
C.col_cfac, C.col_cfil, C.col_empb, C.col_embt, C.col_poid,
C.col_dexp, C.col_cvac, C.col_cgou, C.col_csac, C.col_lang,
C.col_iaff, C.col_mpai1, C.col_mpai2, C.col_orig,
C.edi_code, C.col_supt, C.col_ifpr, C.col_cled, C.col_srel,
C.col_plan, C.col_echp, C.col_mtav, C.col_noav, C.col_tax1,
C.col_clet, C.col_mprt, C.col_ftrt, C.col_curg, C.col_nptt,
C.col_cgiro, C.col_sgiro, C.col_nchif, C.col_chol,
C.soc_no, C.col_nfac, C.lot_numo, C.cha_code, C.rgp_code,
C.stc_code, C.cnf_num, C.col_ncli, C.col_numo, C.col_expc,
C.col_dfac, C.col_bdx, C.col_type, C.col_fprt, C.col_crt,
C.col_tpai, C.col_mexp, C.col_sdis, C.col_sexp, C.col_texp,
C.col_irap, C.col_ilent, C.col_icirc, C.col_iqte,
C.col_iqva, C.col_char, C.col_numf, C.col_cont, C.col_ncol,
C.col_slot, C.col_bqec, C.col_dval, C.col_cpd, C.col_idv,
C.col_tax2, C.col_fiav, C.col_fiut, C.col_fiat, C.col_ztar,
C.col_npat, C.col_cdis, C.col_cdep, C.col_ndep, C.col_prfx,
C.col_ncou, C.col_prel, C.col_cppr, C.col_idis, C.col_mail,
C.col_mailr, C.pal_num, C.tps_code, C.col_ipoid,
C.col_iprev, C.res_code
into COLIS from CARTON C Where C.Soc_no = SOC_soc_no
And C.col_nfac = CARTON_col_nfac; |
Partager