Home » Applications » Oracle Fusion Apps & E-Business Suite » Link b/w tables
Link b/w tables [message #218960] Mon, 12 February 2007 04:32 Go to next message
kanmani_karuppannan
Messages: 23
Registered: November 2006
Location: India
Junior Member

Do we have any link between

a) hr_locations view & financials_system_params_all table.

b) hr_locations view & mtl_system_items table.

Please advice.
Re: Link b/w tables [message #222164 is a reply to message #218960] Fri, 02 March 2007 02:20 Go to previous message
srinivasoracle
Messages: 18
Registered: February 2007
Location: Hyderabad
Junior Member

Hi,

2)Ans:

select msi.segment1 "Item name", hl.location_code
from mtl_system_items msi,
hr_organization_units hou,
hr_locations hl
where msi.organization_id = hou.organization_id
and hou.location_id = hl.location_id
and msi.inventory_item_id=31

MTL_SYSTEM_ITEMS is Items Table
HR_ORGANIZATION_UNITS is Orgnizations Table
HR_LOCATIONS is Locations Table

Check the Item orgnization Location and map to Location table to get the Location Name.

Thanks & Regards,
Srinivasulu Vakati
Previous Topic: Launch SRS Form
Next Topic: oracle faqs
Goto Forum:
  


Current Time: Wed Dec 07 10:55:52 CST 2016

Total time taken to generate the page: 0.09650 seconds