EBS:AR应收账款、贷项通知单或收款核销 查询

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
-- 核销表  FROM "AR"."AR_RECEIVABLE_APPLICATIONS_ALL"
-- APPS.AR_RECEIVABLE_APPLICATIONS_V
SELECT ct.trx_number as "应收单号",
  ( SELECT  CR.receipt_number FROM APPS.AR_CASH_RECEIPTS_ALL CR
    WHERE CR.CASH_RECEIPT_ID = ARA.CASH_RECEIPT_ID
    AND ARA.APPLICATION_TYPE = 'CASH'
   ) AS "收款单",
   ARA.AMOUNT_APPLIED AS "核销金额",
   ( SELECT  ctCM.trx_number FROM AR.Ra_Customer_Trx_All CTCM
    WHERE CTCM.CUSTOMER_TRX_ID = ARA.CUSTOMER_TRX_ID 
    AND ARA.APPLICATION_TYPE = 'CM'
   ) AS "应收-贷项单",
  ara.*
  FROM --APPS.AR_CASH_RECEIPTS_ALL CR,
   APPS.AR_RECEIVABLE_APPLICATIONS_ALL  ARA  ,  -- 收款核销
   AR.Ra_Customer_Trx_All ct  -- 应收账款
WHERE 1=1
-- AND CR.CASH_RECEIPT_ID = ARA.CASH_RECEIPT_ID
-- AND CR.SET_OF_BOOKS_ID = ARA.SET_OF_BOOKS_ID
 AND ARA.CREATION_DATE> TO_DATE('2021-01-01','YYYY-MM-DD')
 AND ARA.ORG_ID = 719 
 and ARA.APPLIED_CUSTOMER_TRX_ID =  ct.CUSTOMER_TRX_ID
 and ara.org_id = ct.ORG_ID
 and ct.trx_number like '10220000746163'  -- 应该账款单号
 AND ARA.SET_OF_BOOKS_ID = 2331 --  销售有限公司

  

posted @   samrv  阅读(471)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· 全程不用写代码,我用AI程序员写了一个飞机大战
· MongoDB 8.0这个新功能碉堡了,比商业数据库还牛
· 记一次.NET内存居高不下排查解决与启示
· DeepSeek 开源周回顾「GitHub 热点速览」
· 白话解读 Dapr 1.15:你的「微服务管家」又秀新绝活了
点击右上角即可分享
微信分享提示