This content has been marked as final. Show 4 replies
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.
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)