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
| CREATE OR REPLACE VIEW ME_V_SUP_R AS
SELECT
ME_SUPPORT.SUP_IDENT,
ME_SUPPORT.CO_NUMINSEE,
ME_SUPPORT.SUP_LTY_IDENT,
ME_SUP_LTY.SUP_LTY_LIBELLE,
ME_SUPPORT.SUP_LTE_IDENT,
ME_SUPPORT.SUP_LPR,
ME_SUPPORT.SUP_DATE,
COUNT(ME_SUP_REL.SUP_IDENT) RELATION,
ME_SUPPORT.LECH_ECHSAISIE,
ME_PDT.PDT_IDENT,
ME_SUP_LP.SUP_PEINT_LIBELLE,
ME_SUP_REL.RSU_SUP_NUMERO
FROM
ME_SUPPORT,
ME_SUP_REL,
ME_SUP_LTY,
ME_PDT,
ME_SUP_LP
WHERE ME_SUPPORT.SUP_IDENT = ME_PDT.SUP_IDENT(+)
AND ME_SUPPORT.SUP_IDENT = ME_SUP_REL.SUP_IDENT(+)
AND ME_SUPPORT.SUP_LTY_IDENT = ME_SUP_LTY.SUP_LTY_IDENT
AND ME_SUP_LP.SUP_PEINT_IDENT(+) = ME_SUPPORT.SUP_PEINT_IDENT
GROUP BY
ME_SUPPORT.SUP_IDENT,
ME_SUPPORT.CO_NUMINSEE,
ME_SUPPORT.SUP_LTY_IDENT,
ME_SUP_LTY.SUP_LTY_LIBELLE,
ME_SUPPORT.SUP_LTE_IDENT,
ME_SUPPORT.SUP_LPR,
ME_SUPPORT.SUP_DATE,
ME_SUPPORT.LECH_ECHSAISIE,
ME_PDT.pdt_ident,
ME_SUP_LP.SUP_PEINT_LIBELLE,
ME_SUP_REL.RSU_SUP_NUMERO; |
Partager