Payables and Cash Management - EBS (MOSC)

MOSC Banner

SQL Script: All Payments By Supplier with Largest Pay Site Pulled In

edited Apr 17, 2018 12:36AM in Payables and Cash Management - EBS (MOSC) 2 commentsAnswered ✓

Not sure if this is the correct community.  Assistance needed with the SQL script below, mostly with a subquery using  DENSE_RANK() OVER (PARTITION BY.

I have a need in Payables R12.2 to query total (non-voided) Payment amounts by Supplier within an operating unit  . . . but pull in the address from the pay site with the largest payment amount for that supplier in that OU.  If the supplier has multiple sites whose payment totals for the period tied for # 1 for that supplier, then I want just one of the top sites pulled in -- I actually don't care which top site.

Tagged:

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

EBS Payables Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center