Payables and Cash Management - EBS (MOSC)

MOSC Banner

Multiple vendor contacts for a vendor,need to extact one

edited Aug 15, 2011 11:33PM in Payables and Cash Management - EBS (MOSC) 2 commentsAnswered
Hi,

We have setup a XYZ vendor for whom we have assigned  2 contacts. when we are fetching all the payments for this vendor as there exists 2 conatcs each payment is being shown twice with 2 different conatct information.

But we need only one conatct information to be fetched. Could anyone please help on it.

Please find attched the below query.

SELECT distinct
        rtrim(ltrim(v.vendor_name,' '),' ')
        ,to_char(c.check_number)                             
       , HP2.email_address
       ,HP2.PRIMARY_PHONE_AREA_CODE
       ,HP2.PRIMARY_PHONE_NUMBER
       ,HP.PERSON_FIRST_NAME  FIRST_NAME_ALT
       ,HP.PERSON_LAST_NAME  LAST_NAME_ALT

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