gproc_Receptions_DuJour
SELECT 
hcdid AS nidCde,
caso AS sCodeSte,
caag AS sCodeAgence,
hsrvid AS scodeService,
hcdnum AS nNumCde,
hcddat AS dCommande,
hcdref AS sRefCommande,
tgid AS nidFournisseur,
fousuf AS sSufFournisseur,
hcdlib AS sLibelle,
hcdfrf AS sRefFou,
hcdfcl AS sClientFou,
hcddal AS dLivraison,
hcdsec AS sSection,
hcdmtt AS rMontant,
hcdenv AS sModeEnvoi,
hcdimo AS sImmo,
hcdsld AS sSoldee,
hcdfac AS sFacturee,
hcdann AS sAnnulee,
hcdfor AS sForcee,
hcdsta AS sStatut,
hcddav AS dValidation,
hcdhev AS hValidation,
hcdprv AS pValidation,
hcdiln AS nNoteInfoLegale,
hcdild AS dInfolegale,
hcdilp AS sProfilInfolegale,
dcrt AS nDateCrea,
hcrt AS nHeureCrea,
pcrt AS sUtilCrea,
pgcrt AS sProgCrea,
dmaj AS nDateMAJ,
hmaj AS nHeureMAJ,
pmaj AS sUtilMAJ,
pgmaj AS sProgMAJ,
hcdbni AS sBlocNoteInterne,
hcdbne AS sBlocNoteImpression,
hcdtyp AS sTypeCommande,
hcddev AS sNDevis
FROM 
chdev.hacde 
WHERE 
hcddal=current date
AND 
hcdsta IN ('COE','COI')
AND 
caag = 'CS' 	 AND hcdsec IN (SELECT hfcsec FROM chdev.hafavc WHERE 	hfcusr='CFINSB')