Bonjour, j'ai un petit souci dans un package sur toad, son interêt est de calculer les délais en prenant en compte que les jours ouvrés
merci bcp de m'aider

INSERT INTO TAG_DDD_DELAI(
NUMBERPRGN,
DDD_DELAI_1,
DDD_DELAI_2,
SYSMODTIME)
SELECT
TFA_DDD.NUMBERPRGN,
(CASE
WHEN TFA_DDD.SFR_DDD_DATE_FIN IS NOT NULL
AND TFA_DDD.SFR_DDD_DT_A_QUIT_A_COMPL IS NOT NULL
THEN TFA_DDD.SFR_DDD_DATE_FIN - TFA_DDD.SFR_DDD_DT_A_QUIT_A_COMPL - DEL1.SUM_JR_NON_OUV
END)DDD_DELAI_1,
(CASE
WHEN TFA_DDD.SFR_DDD_DATE_FIN IS NOT NULL
AND TFA_DDD.UPDATE_DATE IS NOT NULL
THEN TFA_DDD.SFR_DDD_DATE_FIN - TFA_DDD.UPDATE_DATE - DEL2.SUM_JR_NON_OUV
END)DDD_DELAI_2,
TRUNC(TMP_DDD.SYSMODTIME,'MM')
FROM TFA_DDD ,TMP_DDD
INNER JOIN (
SELECT
Count(TDI_BITOOL_CAL1.CPT_J_WE) SUM_JR_NON_OUV
FROM
TDI_BITOOL_CAL TDI_BITOOL_CAL1
WHERE
TDI_BITOOL_CAL1.CPT_J_FER=1
) DEL1
ON (DEL1.DATE_D >=TFA_DDD.SFR_DDD_DT_A_QUIT_A_COMPL AND DEL1.DATE_D<=TFA_DDD.SFR_DDD_DATE_FIN)

INNER JOIN (
SELECT
Count(TDI_BITOOL_CAL2.CPT_J_WE) SUM_JR_NON_OUV
FROM
TDI_BITOOL_CAL TDI_BITOOL_CAL2
WHERE
TDI_BITOOL_CAL2.CPT_J_FER=1) DEL2
ON (DEL2.DATE_D BETWEEN TFA_DDD.UPDATE_DATE AND TFA_DDD.SFR_DDD_DATE_FIN)
WHERE TFA_DDD.SFR_DDD_A_QUIT_A_COMPL = 1
AND TMP_DDD.NUMBERPRGN = TFA_DDD.NUMBERPRGN;