SELECT "SYSSYNC"."last_download_time",
"SYSSYNC"."last_upload_time",
"RPT_STK_DEPOTFIX"."franchise",
"RPT_STK_DEPOTFIX"."billtoANDnomClient",
"RPT_STK_DEPOTFIX"."shiptoANDnomLivraison",
"RPT_STK_DEPOTFIX"."entity",
"RPT_STK_DEPOTFIX"."nomEtPrenom",
"RPT_STK_DEPOTFIX"."billto",
"RPT_STK_DEPOTFIX"."nomclient",
"RPT_STK_DEPOTFIX"."shipto",
"RPT_STK_DEPOTFIX"."nomLivraison"
FROM ("DBA"."RPT_STK_DEPOTFIX" "RPT_STK_DEPOTFIX"
INNER JOIN "DBA"."AUT_USER" "AUT_USER" ON (("RPT_STK_DEPOTFIX"."culture_name"="AUT_USER"."CULTURE_NAME")
AND ("RPT_STK_DEPOTFIX"."prenom_utilisateur"="AUT_USER"."FIRSTNAME"))
AND ("RPT_STK_DEPOTFIX"."nom_utilisateur"="AUT_USER"."LASTNAME")) INNER JOIN "SYS"."SYSSYNC" "SYSSYNC" ON "AUT_USER"."NTLOGIN"="SYSSYNC"."site_name"
WHERE "RPT_STK_DEPOTFIX"."franchise"='OBT' AND "RPT_STK_DEPOTFIX"."billtoANDnomClient"='CENTRE HOSPITALIER PRIVE DE LA LOIRE - 00891866'
AND "RPT_STK_DEPOTFIX"."shiptoANDnomLivraison"='CHPL - 01582924'
Partager