Payables and Cash Management - EBS (MOSC)

MOSC Banner

Fetch template name based on payment_id

edited Oct 5, 2023 3:40PM in Payables and Cash Management - EBS (MOSC) 3 commentsAnswered

Below is the query I am using to fetch the template name based on my payment_id parameter. But I am getting multiple template names for single paymen_id. Kindly assist.


SELECT DISTINCT ipa.PAYMENT_PROCESS_REQUEST_NAME, apt.template_name --,ipa.payment_id,apt.template_id

 FROM IBY_PAYMENTS_ALL ipa, ap_payment_templates apt

 WHERE   1 = 1

    AND apt.payment_profile_id = ipa.payment_profile_id

    AND ipa.payment_id = 'any-payment_id'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center