Basic AP Payments Query:
This query contains most of the fields in Payments header screen.
Select
aca.check_number payment_number,
aca.vendor_name payee,
aca.check_date payment_date,
aca.status_lookup_code status,
ap_checks_pkg.get_posting_status(check_id) Accounting_status,
aca.recon_flag reconciled,
alc.displayed_field payment_type,
aca.amount payment_amount,
aca.currency_code,
hou.name bu,
xep.name le,
aca.stopped_Date stop_date,
aca. void_date
from
ap_checks_All aca,
xle_entity_profiles xep,
hr_operating_units hou,
ap_lookup_code alc
where
aca.legal_entity_id=xep.legal_Entity_id
and aca.org_id=hou.organization_id
and alc.lookup_type='PAYMENT TYPE'
and aca.payment_type_flag=alc.lookup_code
