查询潜在客户资金进账记录

最新推荐文章于 2019-12-30 15:31:39 发布

1411840699

最新推荐文章于 2019-12-30 15:31:39 发布

阅读量227

点赞数

分类专栏： oracle

本文链接：https://blog.csdn.net/qq_37784788/article/details/102494646

版权

oracle 专栏收录该内容

36 篇文章 0 订阅

订阅专栏

SELECT 客户号,
       销售人员,
       预约单号,
       产品名称,
       "预约金额(元)",
       进账金额,
       最后进账日期,
       进账状态
  FROM (SELECT 客户号,
               销售人员,
               预约单号,
               产品名称,
               "预约金额(元)",
               进账金额,
               最后进账日期,
               进账状态,
               ROWNUM R
          FROM (SELECT 客户号,
                       销售人员,
                       预约单号,
                       产品名称,
                       "预约金额(元)",
                       进账金额,
                       最后进账日期,
                       进账状态
                  FROM (SELECT QZKHID 客户号,
                               (SELECT RYXM FROM TRYXX WHERE ID = RYXX) 销售人员,
                               YYDH 预约单号,
                               CPMC 产品名称,
                               YYGMJE "预约金额(元)",
                               JZJE 进账金额,
                               JZRQ 最后进账日期,
                               CASE
                                 WHEN JZJE = 0 THEN
                                  '未进账'
                                 WHEN YYGMJE - JZJE > 0 THEN
                                  '部分进账'
                                 ELSE
                                  '全部进账'
                               END 进账状态
                          FROM (SELECT B.QZKHID,
                                       B.RYXX,
                                       B.YYDH,
                                       C.CPMC,
                                       B.YYGMJE,
                                       SUM(A.JZJE) JZJE,
                                       MAX(A.JZRQ) JZRQ
                                  FROM TZJJZ A, TCPYY B, TFP_CPDM C
                                 WHERE A.CPYYID = B.ID
                                   AND A.CPID = C.ID
                                   AND B.QZKHID = 327
                                 GROUP BY B.QZKHID,
                                          B.RYXX,
                                          B.YYDH,
                                          C.CPMC,
                                          B.YYGMJE)
                         WHERE 1 = 1)
                 ORDER BY 1))
 WHERE R BETWEEN 1 AND 6