OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » where i can find the supplier country in oracle apps Tables?

Home » Applications » Oracle Fusion Apps & E-Business Suite » where i can find the supplier country in oracle apps Tables? (R12.1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

where i can find the supplier country in oracle apps Tables? [message #441393]

Sun, 31 January 2010 05:36

alaa_fouad2004
Messages: 64
Registered: January 2009

Member

Dear all
Please
I want to know where i can find the supplier country in Oracle tables

Alaa Fouad

[Updated on: Mon, 15 March 2010 14:33] by Moderator

Report message to a moderator

Re: where i can fine the supplier country in oracle Tables [message #447504 is a reply to message #441393]

Mon, 15 March 2010 09:56

Tranliem84
Messages: 7
Registered: June 2007
Location: Viet Nam

Junior Member

You can get it from FND_TERRITORIES_VL table
with this script

Select FT.Territory_shot_name as country_name
from
Po_vendor_site_all PVS,
FND_TERRITORIES_VL FT
where FT.TERRITORY_CODE = PVS.COUNTRY

Report message to a moderator

Previous Topic:	migrate oracle EBS 12.1.1 from windows 2003 to windows 2008
Next Topic:	ORACLE FINANCIALS Functional FAQs

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 01 16:19:07 CDT 2025