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
|
SELECT
P_BAREME.FK_GBA_OPERATEUR,
P_BAREME.BAREME,
P_BAREME.NOM,
to_date(to_char(P_BAREME.DATE_DEBUT,'dd/mm/yyyy'),'dd/mm/yyyy'),
to_date(to_char(P_BAREME.DATE_FIN,'dd/mm/yyyy'),'dd/mm/yyyy'),
P_TYPE_BAREME.TYPE_BAREME,
P_GROUPE_BAREME.GROUPE_BAREME,
NVL(P_BAREME_REFERENT.FK_GBA_OPERATEUR, ' '),
NVL(P_BAREME_REFERENT.BAREME, ' '),
to_date(to_char(P_BAREME_REFERENT.DATE_DEBUT,'dd/mm/yyyy'),'dd/mm/yyyy')
FROM
P_BAREME,
P_TYPE_BAREME,
P_GROUPE_BAREME,
P_BAREME P_BAREME_REFERENT
WHERE
( P_GROUPE_BAREME.FK_TBA_OPERATEUR=P_TYPE_BAREME.FK_OPERATEUR and P_GROUPE_BAREME.FK_TBA_TYPE_BAREME=P_TYPE_BAREME.TYPE_BAREME )
AND ( P_BAREME.FK_BAR_BAREME_ALTERNATIF=P_BAREME_REFERENT.NUMERO_BAREME(+) )
AND ( P_BAREME.FK_GBA_GROUPE_BAREME=P_GROUPE_BAREME.GROUPE_BAREME and P_BAREME.FK_GBA_TYPE_BAREME=P_GROUPE_BAREME.FK_TBA_TYPE_BAREME and P_BAREME.FK_GBA_OPERATEUR=P_GROUPE_BAREME.FK_TBA_OPERATEUR )
AND (
to_date(to_char(P_BAREME.DATE_DEBUT,'dd/mm/yyyy'),'dd/mm/yyyy') <= '07/11/2007'
AND to_date(to_char(P_BAREME.DATE_FIN,'dd/mm/yyyy'),'dd/mm/yyyy') >= '31/01/2000'
AND P_BAREME.FK_GBA_OPERATEUR IN ( '9T','B3G','BYT','COLT','CPTEL','CWF','FFMV2','FREE','FTF','FTLD','FTLDH','FTLDM','FTLDO','FTMRD','MFS','MONAC','OCR','OGPRS','OMMS','OMSP','ORLCF','ORORT','OVGT','OVT','OWHA','OWIFI','OZB','SFR','SIRIS','SMSC','SMSR','TD','TELE2')
AND P_TYPE_BAREME.TYPE_BAREME IN ('CNP','NNG','TBEQ')
AND P_GROUPE_BAREME.GROUPE_BAREME IN ('APN_INT','APN_NAT','CS','GBEQT','INDET','INTERNAT','MOBILES','NATIONAL','NUMSPEC')
AND P_BAREME.BAREME LIKE '%'
AND P_BAREME.AUT_IND IN @variable('A','S')
AND P_BAREME.BAREME != ' '
) |
Partager