Receivables - EBS (MOSC)

MOSC Banner

Trying to find frontend fields for the following information

edited Jun 2, 2015 10:00AM in Receivables - EBS (MOSC) 6 commentsAnswered

Hello,

when I query a specific customer for the party phone number using this query:

SELECT ca.account_number,

       hp.party_name,

       hp.primary_phone_purpose,

       hp.primary_phone_line_type,

       hp.primary_phone_country_code,

       hp.primary_phone_area_code,

       hp.primary_phone_number,

       hp.primary_phone_extension

FROM apps.hz_cust_accounts ca,

     apps.hz_parties hp

WHERE ca.party_id=hp.party_id

and ca.account_number in ('18473');

I get a specific phone number but cannot seem to find that same phone number from the frontend.  Where can I find those specific fields on the frontend?

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