AP Payments Query

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