Home » Applications » Oracle Fusion Apps & E-Business Suite » move order and reservation
move order and reservation [message #529258] Sun, 30 October 2011 09:36 Go to next message
hany_marawan
Messages: 180
Registered: April 2005
Location: Cairo - Egypt
Senior Member
Heelo,
I want a select statement to link between move order and reservation.

regards
Re: move order and reservation [message #529343 is a reply to message #529258] Mon, 31 October 2011 04:10 Go to previous message
hany_marawan
Messages: 180
Registered: April 2005
Location: Cairo - Egypt
Senior Member
Thanks every body.
I found the select

select ooh.order_number

from MTL_RESERVATIONS_ALL_V mr
,OE_ORDER_HEADERS_ALL ooh
,OE_ORDER_LINES_ALL ool
,MTL_TXN_REQUEST_LINES_V mtrl
,MTL_TXN_REQUEST_HEADERS_V mtrh

where ooh.header_id=ool.header_id
and demand_source_line_id=ool.line_id
and mr.DEMAND_SOURCE_LINE_ID is not null
and mtrh.header_id=mtrl.header_id
and mtrl.txn_source_line_id=mr.DEMAND_SOURCE_LINE_ID
and mtrh.REQUEST_NUMBER='19242';

may it helps anyone

Regards
Previous Topic: gl_interface in R12 - translated values?
Next Topic: Issue with AR
Goto Forum:
  


Current Time: Thu Aug 28 10:39:38 CDT 2014

Total time taken to generate the page: 0.09848 seconds