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
|
CREATE OR REPLACE VIEW ETAT_ACAV_Pk_view (
ID_SUPPORT,
VALEUR,
LIBELLE_COURT,
MONTANT_ACAV_A,
MONTANT_ACAV_P,
MONTANT_ACAV_ATTENTE,
ID_ACAV_ATTENTE,
ID_FLUX,
UNIQUE RELY DISABLE NOVALIDATE,
CONSTRAINT Pk_ETAT_ACAV_view PRIMARY KEY (ID_SUPPORT,ID_ACAV_ATTENTE,ID_FLUX) RELY DISABLE NOVALIDATE)
AS
SELECT
AA.ID_SUPPORT ,
VALEUR ,
LIBELLE_COURT ,
AA.MONTANT_ACAV_A ,
MONTANT_ACAV_P ,
MONTANT_ACAV_ATTENTE ,
FA.ID_ACAV_ATTENTE ,
FA.ID_FLUX
FROM
VL ,
MIF_SUPPORT ,
ACAV_ACTIF AA ,
ACAV_PASSIF ,
ACAV_ATTENTE ,
FLUX_ACAV_ATTENTE FA
WHERE AA.ID_SUPPORT ='1' ; |
Partager