phone number country code in Rel 12
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?