1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54
| INSERT INTO alm.tb_wdo_vte
(id_wdo_vte_ref_cla, id_wdo_vte_pvt, id_wdo_vte_emp,
id_wdo_vte_mci_jou_heu, nb_wdo_vte_prp, nb_wdo_vte_tkv,
dc_wdo_vte_mnt_ca_net_ht, dc_wdo_vte_mnt_ca_brt_ini,
dc_wdo_vte_mnt_ca_brt_bas, dc_wdo_vte_mnt_ca_net_ttc,
dc_wdo_vte_mnt_mrg, dc_wdo_vte_mnt_rab_rem, dc_wdo_vte_mnt_rem,
dc_wdo_vte_vnd_heu, nb_wdo_vte_rmb, nb_wdo_vte_ech,
nb_wdo_vte_ret_cli, nb_wdo_vte_qte, dc_wdo_vte_mnt_ret_cli,
dc_wdo_vte_mnt_ech, dc_wdo_vte_mnt_rmb, dc_wdo_vte_amp_hor,
lb_wdo_vte_sta, nb_wdo_vte_cli)
SELECT g_t4.id_ref, g_t3.id_pvt, g_t3.id_emp,
TO_NUMBER (TO_CHAR (g_t3.dt_ent_tkv, 'yyyymmddHH24')), 0, 0,
SUM (( ( (g_t1.dc_lig_tkv_prx_ven_brt * g_t1.nb_lig_tkv_qt)
- g_t1.dc_lig_tkv_mnt_rem
)
- g_t1.dc_lig_tkv_mnt_tva
)
),
SUM ((g_t2.dc_prx_brt_ini * g_t1.nb_lig_tkv_qt)),
SUM ((g_t1.nb_lig_tkv_qt * g_t2.dc_prx_brt_bas)),
SUM (( (g_t1.dc_lig_tkv_prx_ven_brt * g_t1.nb_lig_tkv_qt)
- g_t1.dc_lig_tkv_mnt_rem
)
),
( SUM (( ( (g_t1.dc_lig_tkv_prx_ven_brt * g_t1.nb_lig_tkv_qt)
- g_t1.dc_lig_tkv_mnt_rem
)
- g_t1.dc_lig_tkv_mnt_tva
)
)
- SUM ((g_t1.nb_lig_tkv_qt * g_t2.dc_prmp))
),
( SUM (( (g_t2.dc_prx_brt_bas - g_t1.dc_lig_tkv_prx_ven_brt)
* g_t1.nb_lig_tkv_qt
)
)
+ SUM (g_t1.dc_lig_tkv_mnt_rem)
),
SUM (g_t1.dc_lig_tkv_mnt_rem), 0, 0, 0, 0,
SUM (g_t1.nb_lig_tkv_qt), 0, 0, 0, 0, 'AA', 0
FROM ods.tb_o_lig_tkv@xdwa g_t1,
alm.tb_wdo_prx_ref_jou@xdwa g_t2,
ods.tb_o_ent_tkv@xdwa g_t3,
ods.tb_o_uvc@xdwa g_t4
WHERE g_t3.id_tps_jou = g_t2.id_jou
AND g_t1.id_uvc = g_t4.id_uvc
AND g_t3.id_ent_tkv = g_t1.id_ent_tkv
AND g_t3.id_tps_jou >= TO_NUMBER (TO_CHAR (:1, 'yyyymmdd'))
AND g_t1.cd_lig_tkv_typ <> 'MVTFI'
AND g_t4.id_ref = g_t2.id_uvc
GROUP BY TO_NUMBER (TO_CHAR (g_t3.dt_ent_tkv, 'yyyymmddHH24')),
g_t4.id_ref,
g_t3.id_pvt,
g_t3.id_emp |
Partager