从Invoice 得到Payment batch

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

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

select a.CHECKRUN_NAME Batch_Name,a.*ITPUB个人空间%{v`H+rx.dd
from Ap_Checks_All aITPUB个人空间Rz{yCgo2@
where Check_id inITPUB个人空间J?,X
vTCG4f@9H
(select check_id
:|A-E{$B7x*J)N0from AP_INVOICE_PAYMENTS_all
a@E8Vd2r0where invoice_id in
}K
_i:t,\*[op0(select invoice_idITPUB个人空间 X~0n^W0t3yB7P
from AP_INVOICES_ALLITPUB个人空间BP0?s |7ZCz
where invoice_num = '00397527'))