Receivables - EBS (MOSC)

MOSC Banner

How to Get Customer Contact Purpose Details

edited Feb 25, 2013 7:48AM in Receivables - EBS (MOSC) 8 commentsAnswered
Hi All,

I am using below query for getting customer contact details but I am not able to find the address purpose( e.g. Acknowledgments,Invoices) fields anywhere. Which table I need to refer for this?
I am getting all the information except purpose of the contact. Could someone help me on this?

Attached screenshot shows the field which I am referring to on Customer form.

SELECT hcas.CUST_ACCT_SITE_ID,h_contact.party_id contact_id,h_contact.party_name contact_name,hp.party_id,hp.party_name , hcp.phone_number, hcp.CONTACT_POINT_PURPOSE, cust.account_name

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