This content has been marked as final. Show 4 replies
Just you go to Track order page and search your existing order. You can find hear all order details.
This is the default functionality in istore right? I need some pl/sql query to find out recently ordered items using account number of the customer
Check this query it should work..
select ol.ordered_item, oh.ordered_date from oe_order_lines_all ol,oe_order_headers_all oh, hz_cust_accounts hz where ol.header_id=oh.header_id
and hz.cust_account_id=oh.sold_to_org_id and hz.account_number='12345' order by oh.creation_date desc.
Note: Replace 12345 to your account number.
Hello,1 person found this helpful
You can, also, use or modify the view IBE_ORDER_SUM_V which is for iStore generated orders. This is the view used in the iStore Order Tracker (Orders tab).
Reference guidelines in: How can the iStore Order Tracker include additional fields? (Doc ID 334385.1)