1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| SELECT iidba_ipv_article.art_cod, iidba_ipv_stock.stk_qte AS art_qte_stock, iidba_ipv_article.art_lib, TBL_ARTICLE.art_type,
iidba_ipv_article.art_rem, iidba_ipv_article.art_stk_ep AS art_epuise, rq_av_lst_art_qte_cmde_KANBAN.qte_cde_kan,
rq_av_lst_art_qte_cmde_CSA_PJT.qte_cde_csa_pjt, rq_av_lst_art_qte_cmde_autre.qte_cde_autre,
rq_av_lst_art_qte_appro.SommeDeapo_rest_ges, rq_av_lst_art_qte_of.SommeDeof_qte_a_ent,
rq_av_lst_art_qte_sorties.qte_sorties_exp, rq_av_lst_art_qte_sorties.qte_sorties_internes, rq_av_lst_art_qte_entrees.qte_appro,
rq_av_lst_art_qte_entrees.qte_of, rq_av_lst_art_qte_NF.SommeDenf_qte_a_sort
FROM (((((((((iidba_ipv_article LEFT JOIN TBL_ARTICLE ON iidba_ipv_article.art_cod = TBL_ARTICLE.art_cod) LEFT JOIN
iidba_ipv_stock ON (iidba_ipv_article.art_soc_proprietaire = iidba_ipv_stock.soc_num) AND (iidba_ipv_article.art_cod = iidba_ipv_stock.art_cod)) LEFT JOIN
rq_av_lst_art_qte_cmde_KANBAN ON iidba_ipv_article.art_cod = rq_av_lst_art_qte_cmde_KANBAN.art_cod) LEFT JOIN
rq_av_lst_art_qte_cmde_CSA_PJT ON iidba_ipv_article.art_cod = rq_av_lst_art_qte_cmde_CSA_PJT.art_cod) LEFT JOIN
rq_av_lst_art_qte_appro ON iidba_ipv_article.art_cod = rq_av_lst_art_qte_appro.art_cod) LEFT JOIN
rq_av_lst_art_qte_cmde_autre ON iidba_ipv_article.art_cod = rq_av_lst_art_qte_cmde_autre.art_cod) LEFT JOIN
rq_av_lst_art_qte_entrees ON iidba_ipv_article.art_cod = rq_av_lst_art_qte_entrees.art_cod) LEFT JOIN
rq_av_lst_art_qte_of ON iidba_ipv_article.art_cod = rq_av_lst_art_qte_of.art_cod) LEFT JOIN
rq_av_lst_art_qte_sorties ON iidba_ipv_article.art_cod = rq_av_lst_art_qte_sorties.art_cod) LEFT JOIN
rq_av_lst_art_qte_NF ON iidba_ipv_article.art_cod = rq_av_lst_art_qte_NF.nf_composant
WHERE (((iidba_ipv_article.art_cod)>"003" And (iidba_ipv_article.art_cod) Not Like "4*" And (iidba_ipv_article.art_cod) Not Like "F*") AND ((iidba_ipv_article.art_stk_ep)<>"A")); |
Partager