Receivables - EBS (MOSC)

MOSC Banner

phone number country code in Rel 12

edited Dec 15, 2016 4:00AM in Receivables - EBS (MOSC) 4 commentsAnswered

In 11.5.10.2, I use the following SQL to get the full phone number e.g. 1-800-123-1234

select  hp.primary_phone_country_code phone_country_code,

  rap.area_code, rap.phone_number , ooh.ship_to_contact_id

from

  ont.oe_order_headers_all ooh,

  APPS.ra_contacts rac,

  APPS.ra_phones rap,

  apps.hz_parties          hp

where  1=1

  and rac.contact_id  = ooh.ship_to_contact_id

  and rac.contact_id=rap.contact_id

  and phone_type='GEN'

  and rap.primary_flag = 'Y'

  and hp.party_id = rap.owner_table_id;

After upgrade to 12.1.3, I re-write the SQL since ra_contacts view is gone.  But so far I cannot find a table and column that store the primary_phone_country_code  ( for example, US is 1, France is 33 ).   Where is the table and column in Rel 12?

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