1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
|
CREATE OR REPLACE VIEW V_FACTURE_MF (
FAC_ID,
FAC_NUMEROPIECE, FACTURE_MF_NO, FAC_GENRE, FAC_DESIGNATION,
FAC_VALEURBRUTE, CTR_ANC_NO, ENT_NOM1, ORD_MF_ID
) AS
SELECT facture.fac_id, facture.fac_numeropiece, facture_mf.facture_mf_no,
facture.fac_genre, facture.fac_designation, facture.fac_valeurbrute,
contrat_cmd.ctr_anc_no, entreprise.ent_nom1, facture_mf.ord_mf_id
FROM facture_mf,
contrat_cmd_mf,
facture,
entreprise,
contrat_cmd
WHERE ( (facture.fac_id = facture_mf.fac_id)
AND (entreprise.ent_id = facture.ent_id)
AND (contrat_cmd.ctr_id = contrat_cmd_mf.ctr_id)
AND (facture_mf.ctr_id = contrat_cmd_mf.ctr_id)
) |
