------------------------------------------------------------------
-- DEVIS EN COURS												--
------------------------------------------------------------------
SELECT DISTINCT CLI.EMAILCONTACT AS 'EMAIL', 'DEVIS' AS 'ORDER_STATUS', ENT.TIERS, ENT.PINO, ENT.PIDT, CLI.NOM , CLI.TITRELIBELLE , CLI.PRENOM , CLI.NOMCOMTACT  
FROM CARTOFLEX.dbo.ENT ENT, CARTOFLEX.dbo.CARTOFLEX_CONTACTS_CLIENT_V CLI 
WHERE (ENT.TIERS = CLI.TIERS) AND CLI.CONTACT = ENT.CONTACT AND (ENT.PIDT>'2023-05-01') AND (ENT.CE4=1) AND (ENT.PICOD=1) AND (ENT.REPR_0001='ACS') AND CLI.EMAILCONTACT!=''
UNION 
SELECT DISTINCT PRO.EMAILCONTACT AS 'EMAIL', 'DEVIS' AS 'ORDER_STATUS', ENT.TIERS, ENT.PINO, ENT.PIDT, PRO.NOM , PRO.TITRELIBELLE , PRO.PRENOM , PRO.NOMCOMTACT  
FROM CARTOFLEX.dbo.ENT ENT, CARTOFLEX.dbo.CARTOFLEX_CONTACTS_PROSPECT_V PRO 
WHERE (ENT.TIERS = PRO.TIERS) AND PRO.CONTACT = ENT.CONTACT AND (ENT.PIDT>'2023-05-01') AND (ENT.CE4=1) AND (ENT.PICOD=1) AND (ENT.REPR_0001='ACS') AND PRO.EMAILCONTACT!=''



------------------------------------------------------------------
-- FACUTRE EN COURS												--
------------------------------------------------------------------
SELECT DISTINCT CLI.EMAILCONTACT AS 'EMAIL', 'OUI' AS 'ORDER_STATUS', ENT.TIERS, ENT.PINO, ENT.PIDT, CLI.NOM , CLI.TITRELIBELLE , CLI.PRENOM , CLI.NOMCOMTACT  
FROM CARTOFLEX.dbo.ENT ENT, CARTOFLEX.dbo.CARTOFLEX_CONTACTS_CLIENT_V CLI 
WHERE (ENT.TIERS = CLI.TIERS) AND CLI.CONTACT = ENT.CONTACT AND (ENT.PIDT>'2023-01-01') AND (ENT.CE4=1) AND (ENT.PICOD=4) AND (ENT.REPR_0001='ACS') AND CLI.EMAILCONTACT!=''
UNION 
SELECT DISTINCT PRO.EMAILCONTACT AS 'EMAIL', 'OUI' AS 'ORDER_STATUS', ENT.TIERS, ENT.PINO, ENT.PIDT, PRO.NOM , PRO.TITRELIBELLE , PRO.PRENOM , PRO.NOMCOMTACT  
FROM CARTOFLEX.dbo.ENT ENT, CARTOFLEX.dbo.CARTOFLEX_CONTACTS_PROSPECT_V PRO 
WHERE (ENT.TIERS = PRO.TIERS) AND PRO.CONTACT = ENT.CONTACT AND (ENT.PIDT>'2023-01-01') AND (ENT.CE4=1) AND (ENT.PICOD=4) AND (ENT.REPR_0001='ACS') AND PRO.EMAILCONTACT!=''