Home » Applications » Oracle Fusion Apps & E-Business Suite » where i can find the supplier country in oracle apps Tables? (R12.1)
where i can find the supplier country in oracle apps Tables? [message #441393] Sun, 31 January 2010 05:36 Go to next message
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 Go to previous message
Tranliem84
Messages: 7
Registered: June 2007
Location: Viet Nam
Junior Member

Smile 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
Previous Topic: migrate oracle EBS 12.1.1 from windows 2003 to windows 2008
Next Topic: ORACLE FINANCIALS Functional FAQs
Goto Forum:
  


Current Time: Wed Sep 28 07:27:10 CDT 2016

Total time taken to generate the page: 0.11939 seconds