Home » Applications » Oracle Fusion Apps & E-Business Suite » country for inventory oraganization (11.5.10)
country for inventory oraganization [message #423669] Sat, 26 September 2009 05:09 Go to next message
ajitpal.s
Messages: 204
Registered: November 2006
Senior Member
Hi ,

Can someone tell me which table i can extract the country name of a particular inventory organization.

I tried query below, but no records returned, just wonder if theres any workaround

select country from apps.hz_locations a, 
              hr.HR_ALL_ORGANIZATION_UNITS b 
where 
a.location_id = b.location_id


thank you very much

[Updated on: Sat, 26 September 2009 05:18]

Report message to a moderator

Re: country for inventory oraganization [message #423671 is a reply to message #423669] Sat, 26 September 2009 05:27 Go to previous messageGo to next message
ajitpal.s
Messages: 204
Registered: November 2006
Senior Member
got it, i should join it with hr_locations_all , it the country field is in short form, is there any way to get the full country name rather than decoding it, etc
Re: country for inventory oraganization [message #423676 is a reply to message #423669] Sat, 26 September 2009 06:10 Go to previous messageGo to next message
pralin
Messages: 6
Registered: July 2005
Location: Singapore
Junior Member

I dont think u can find country information of an inv org directly.
Country information (Legislation Code) can be found in the Business Group Definition. So you need to find the BG under which the inv Org is defined.
Re: country for inventory oraganization [message #423678 is a reply to message #423676] Sat, 26 September 2009 06:44 Go to previous message
ajitpal.s
Messages: 204
Registered: November 2006
Senior Member
thanks for the reply pralin

im not very familiar with apps. does BG stands for business group.

If so, which table do i link with hr.HR_ALL_ORGANIZATION_UNITS to get the full name of the country and what is the join condition?
Previous Topic: is there API for loading suppliers ?
Next Topic: How to make invoices / customer delinquent in AR ?
Goto Forum:
  


Current Time: Wed Dec 07 23:58:40 CST 2016

Total time taken to generate the page: 0.06171 seconds