Oracle EBS AR 收款取值

最新推荐文章于 2024-09-14 17:41:51 发布

weixin_30345577

最新推荐文章于 2024-09-14 17:41:51 发布

阅读量398

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：http://www.cnblogs.com/jenrry/p/10007320.html

本文深入探讨了使用SQL进行复杂数据查询的方法，通过具体案例展示如何从多个表中联接并筛选数据，适用于需要掌握高级SQL技能的数据库管理员及开发者。

select hr.name,
       a.autoapply_flag,
       a.AUTOMATCH_SET_ID,
       a.LEGAL_ENTITY_ID,
       a.RECEIPT_NUMBER,
       a.type,
       a.receipt_date,
       b.gl_date,
       c.name,
       a.remit_bank_account,
       ce.bank_account_name,
       a.attribute3
  from AR_CASH_RECEIPTS_V        a,
       hr_operating_units          hr,
       AR_CASH_RECEIPT_HISTORY_ALL b,
       AR_RECEIPT_METHODS          c,
       ce_bank_accounts ce
 where a.org_id = hr.organization_id
   AND b.CASH_RECEIPT_ID(+) = a.CASH_RECEIPT_ID
   AND b.ORG_ID(+) = a.ORG_ID
   AND b.FIRST_POSTED_RECORD_FLAG(+) = 'Y'
   and hr.organization_id = 89
   AND a.RECEIPT_METHOD_ID = c.RECEIPT_METHOD_ID
   and a.remit_bank_account = ce.bank_account_num
   and a.attribute3 < '20000'