oracle ebs计税逻辑,Oracle EBS 验证应收是否等于加税

--To validate whether a transaction's REC is equal to its REV plus TAX or not

--验证应收是否等于收入加税

SELECT c.trx_number, c.complete_flag, c.customer_trx_id,

a.customer_trx_line_id,

(SELECT payment_schedule_id

FROM ar.ar_payment_schedules_all d

WHERE a.customer_trx_id = d.customer_trx_id) payment_schedule_id,

(SELECT receivable_application_id

FROM ar.ar_receivable_applications_all e

WHERE a.customer_trx_id =

e.customer_trx_id)

receivable_application_id

FROM ar.ra_customer_trx_lines_all a,

ar.ra_customer_trx_lines_all b,

ar.ra_customer_trx_all c

WHERE c.set_of_books_id = '&sob'

AND a.customer_trx_id = c.customer_trx_id

AND a.set_of_books_id = '&sob'

AND a.set_of_books_id = b.set_of_books_id

AND a.customer_trx_line_id = b.link_to_cust_trx_line_id

AND a.revenue_amount <> b.taxable_amount

AND EXISTS (

SELECT 'T'

FROM ar.ra_cust_trx_types_all rctt

WHERE rctt.post_to_gl = 'Y'

AND rctt.set_of_books_id = c.set_of_books_id

AND rctt.cust_trx_type_id = c.cust_trx_type_id

AND rctt.end_date IS NULL)

AND EXISTS (

SELECT 'T'

FROM ar.ra_cust_trx_line_gl_dist_all rctlg

WHERE rctlg.set_of_books_id = c.set_of_books_id

AND rctlg.customer_trx_id = c.customer_trx_id

AND rctlg.gl_date >= SYSDATE - 31)

Oracle EBS AR应收核销取值

AR_RECEIVABLE_APPLICATIONS APP, AR_CASH_RECEIPTS CR, AR_PAYMENT_SCHEDULES PS_INV, HZ_CUST_ACCOUNTS C ...

Oracle Ebs R12 SLA与GL关系变化

http://www.cnblogs.com/bruce_zhao/p/3809886.html Oracle Ebs R12 SLA与GL关系变化 SLA概念:SLA(Subledger Accou ...

&lbrack;转&rsqb;oracle EBS 基础100问

from:http://www.cnblogs.com/xiaoL/p/3593691.html  http://f.dataguru.cn/thread-51057-1-1.html 1001 OR ...

Oracle EBS Report 输出字符字段前部＂0＂被Excel自动去掉问题

Oracle  EBS 提供多种报表的开发和输出形式,由于MS Excel在处理数据方面的优势明显,报表输出用Excel打开是很常见的开发项. 但是正是由于Excel的"过于智能而不智能&q ...

Oracle EBS 如何月结、对账&lbrack;Z&rsqb;

在Oracle系统处理月结业务时,需要遵循一定的操作顺序.这些业务,牵涉到相应的模块,包括:应付模块.采购模块.库存模块.应收模块.薪资模块.固定资产和总帐模块等 在Oracle系统中,总帐模块处于财 ...

Oracle EBS R12经验谈(二)

作者: jianping.ni    时间: 2009-2-13 12:52     标题: Oracle EBS R12经验谈(二) OAF页面:银行帐户开户人LOV值列表无值    在输入 应付超 ...

ORACLE EBS常用表

http://www.cnblogs.com/quanweiru/archive/2012/09/26/2704628.html call fnd_global.APPS_INITIALIZE(131 ...

Oracle EBS供应商接口导入&lpar;转&rpar;