从Invoice 得到Payment batch.

在Oracle的Ap中从Payment Batch得到invoice是很方便的,但是没有一个逆向的查找,可以从Invoice 得到Payment batch.

下面这个SQL,可以提供一些帮助:

select a.CHECKRUN_NAME Batch_Name,a.*
n-N
u:JN'L@)mGv0from Ap_Checks_All a
u0kF3voB*x?0where Check_id inITPUB个人空间3Bv'Ov+q5QY-X
(select check_idITPUB个人空间9Rz2E$fe
from AP_INVOICE_PAYMENTS_all
t(?c7Y
K%vY|L0where invoice_id inITPUB个人空间zn\5a,hf
(select invoice_id
Bj"}nOs4p0from AP_INVOICES_ALL
;TI1Mh6t#k;E0vjh0where invoice_num = '00397527'))