OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » move order and reservation

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

move order and reservation [message #529258]

Sun, 30 October 2011 09:36

hany_marawan
Messages: 198
Registered: April 2005
Location: Cairo - Egypt

Senior Member

Heelo,
I want a select statement to link between move order and reservation.

regards

Report message to a moderator

Re: move order and reservation [message #529343 is a reply to message #529258]

Mon, 31 October 2011 04:10

hany_marawan
Messages: 198
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 11 16:13:55 CST 2024