Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DISTINCT a.suscripcion, a.linea,a.contrato,a.bonificacion,a.PRODUCTO,a.VENDEDOR,a.COD_APROB,a.COD_PLAN,a.PDV,a.fec_activ,
- a.fec_aprob,a.FECHA_PRIMERA_CARGA,a.PORC_COMI,a.BONI_PORTA,a.AGENTE,a.ZONA_COMER,a.DEPARTAMENTO,a.PORTADA
- FROM comisv2.evt_comi_recargas a
- JOIN comisv2.evt_recarga_det d ON a.linea=d.linea AND a.CONTRATO=d.CONTRATO
- JOIN comisv2.CABEVENTOS c ON d.idcabevento=c.COD_CABEVENTO_PK
- WHERE a.vendedor IN ('ocken', 'ocbb',
- 'ferremic','huancan','nunezig','cuevasar','quirogde','alonzor','cuellavi','castelld','almadape',
- 'ramirere','martirei','maizme','veragus','rojasnay','ramirliz','aveirola','bernalle','salcedog',
- 'diartef','obregoma','britvict','esquimar','miranday','ramirezg','fleitass','balmorfa','duartezu','martinso','acostaga',
- 'espinoal','davalole','ramirliz','ramireju','britocin','maizme',
- 'esquivek','aquinogl','ruizserg','paivalu','duartezu','obregoma')
- AND a.COMI_RECARGAS > 0 AND a.idcabevento IN (77450,77471) AND a.COD_APROB='APROB' AND (a.BONI_PORTA=0 OR a.PORTADA IS NULL)
- AND d.monto > 0
- AND to_char(d.fecha_carga,'mm/yyyy') = to_char(to_date('18/01/2019','dd/mm/yyyy hh24:mi:ss'),'mm/yyyy')
- AND d.FECHA_CARGA <= add_months(d.fec_activ, 3)
- AND c.str_firma = 'RECARGAS_DETALLE'
- AND c.STR_CONFIRMADO = 'S';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement