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.

Report message to a moderator

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

Report message to a moderator

Previous Topic: Launch SRS Form
Next Topic: oracle faqs
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jul 07 04:27:22 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.