Skip to Content
Author's profile photo Former Member

Reporte de Oportunidades

Cordial Saludo:

Envió reporte de oportunidades:

SELECT T0.[OpenDate], T0.[CloseDate] as ‘Fecha de Cierre’, T0.[OpprId] as Oportunidad, T0.[Name], T0.[CardCode], T0.[CardName], T1.[SlpName] as ‘Asesor Comercial’, T0.[MaxSumLoc] as ‘Monto Potencial’,T2.[Descript] AS ‘Nivel de Interes’, T3.[Descript] as Fuente,T4.[IndName] as Sector , Estado= CASE T0.[Status] WHEN ‘W’ THEN ‘GANADO’ WHEN ‘O’ THEN ‘ABIERTO’ WHEN ‘L’ THEN ‘PERDIDO’ ELSE ‘N/A’ END, T0.[CloPrcnt] FROM OOPR T0  INNER JOIN OSLP T1 ON T0.SlpCode = T1.SlpCode INNER JOIN OOIR T2 ON T0.IntRate = T2.Num INNER JOIN OOSR T3 ON T0.Source = T3.Num INNER JOIN OOND T4 ON T0.Industry = T4.IndCode WHERE T0.[OpenDate] between [%0] and [%1] ORDER BY T0.[OpenDate] asc

A espera de sus comentarios.

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.