Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Sunday, March 20, 2016

Query to get the Order and transaction details

select distinct
OOHA.ORDER_NUMBER
,rcta.trx_number
,rcta.trx_date
,oola.line_number
,oola.ordered_quantity
from
oe_order_headers_all ooha,
oe_order_lines_all oola,
ra_customer_trx_all rcta,
RA_CUSTOMER_TRX_LINES_ALL RCTLA
where 1=1
and ooha.header_id=oola.header_id
AND rcta.customer_trx_id = rctla.customer_trx_id
and RCTLA.INTERFACE_LINE_ATTRIBUTE1  = TO_CHAR(OOHA.ORDER_NUMBER)
AND RCTLA.INTERFACE_LINE_ATTRIBUTE6 = TO_CHAR(OOLA.LINE_ID)
AND OOHA.ORDER_NUMBER='343343' ;

No comments:

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect