Home » SQL & PL/SQL » SQL & PL/SQL » Table Join on Same Table
Table Join on Same Table [message #247630] Tue, 26 June 2007 10:55 Go to next message
orappnewbie
Messages: 20
Registered: May 2007
Junior Member
Hi,

I have following data.

In Oracle application EBS
we have table called

FND_LOOKUP_VALUES which hold value for different code which are used in EBS.

like 1)LOOKUP_TYPE := MRP_PLAN
LOOKUP_VALUE:= MAKE 1
BUY 2

2)LOOKUP_TYPE := WIP_SUPPLY
LOOKUP_VALUE:= PUSH 1
PULL 2


so i am getting wip_supply and mrp_plan value which is 1 and 2 in different column of table MTL_SYSTEM_ITEMS

so if i do following i


select wip_supply_value,mrp_plan_value from mtl_system_items
where item_id=123

wip_supply_value mrp_plan_value
-------------------------------------------
1 1


but i need meaning of lookup value

so i need output like
wip_supply_value mrp_plan_value
-------------------------------------------
MAKE PUSH

i need to join with FND_LOOKUP_VALUES with different LOOKUP_TYPE for multiple column on same table MTL_SYSTEM_ITEMS

how can i do that?

Thanks
Jim


Re: Table Join on Same Table [message #247639 is a reply to message #247630] Tue, 26 June 2007 11:16 Go to previous message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
FROM MTL_SYSTEM_ITEMS T1, MTL_SYSTEM_ITEMS T2
Previous Topic: Query not working in 10g.
Next Topic: Need distinct on 1 table
Goto Forum:
  


Current Time: Wed Dec 07 16:14:36 CST 2016

Total time taken to generate the page: 0.05118 seconds