OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » country for inventory oraganization

Home » Applications » Oracle Fusion Apps & E-Business Suite » country for inventory oraganization (11.5.10)

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

country for inventory oraganization [message #423669]

Sat, 26 September 2009 05:09

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

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

Report message to a moderator

Re: country for inventory oraganization [message #423676 is a reply to message #423669]

Sat, 26 September 2009 06:10

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.

Report message to a moderator

Re: country for inventory oraganization [message #423678 is a reply to message #423676]

Sat, 26 September 2009 06:44

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?

Report message to a moderator

Previous Topic:	is there API for loading suppliers ?
Next Topic:	Formula Column Datatype Char Show "/" on to_char for format number

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 17 22:57:16 CDT 2024