Monday, March 20, 2017

Payment Details Query in Oracle Payables or Payments in Oracle EBS

SELECT sup.vendor_name, assa.vendor_site_code, pp.payment_profile_name,
p.payment_id, p.payment_method_code, p.payment_status, p.process_type,
p.payment_amount, p.payment_currency_code, p.ext_payee_id
FROM apps.iby_payments_all p,
apps.iby_payment_profiles pp,
apps.hr_operating_units op,
apps.ap_supplier_sites_all assa,
apps.ap_suppliers sup,
apps.iby_external_payees_all iepa
WHERE 1 = 1 -- payment_instruction_id=213190
AND p.payment_profile_id = pp.payment_profile_id
AND pp.processing_type = 'ELECTRONIC'
AND p.org_id = op.organization_id
AND op.business_group_id = 0
AND iepa.ext_payee_id = p.ext_payee_id
AND sup.vendor_id = assa.vendor_id
AND assa.pay_site_flag = 'Y'
AND assa.vendor_site_id = iepa.supplier_site_id
AND p.payment_instruction_id = 213190;

No comments:

Post a Comment