One Time Payment Request - Party Tax Registration Number Query

One-time payment requests may not include a supplier link; however, the party link is available and functions correctly.

Sample Data (FBDI)

Interface Table.Column

AP_PAYMENT_REQUESTS_INT.THIRD_PARTY_REGISTRATION_NUM

Base Table.Column

ZX_PARTY_TAX_PROFILE.REP_REGISTRATION_NUMBER

Check the below SQL:

SELECT aia.invoice_num,

aia.party_id,

zx.rep_registration_number

FROM ap_invoices_all aia,

zx_party_tax_profile zx

WHERE 1=1

AND invoice_type_lookup_code = 'PAYMENT REQUEST'

-- AND invoice_num LIKE 'AP_%'

AND source = 'ONE_TIME_PAYMENTS'

AND aia.party_id = zx.party_id (+)

Query Output: