We have a requirement where our customers are associated to the buying groups/management companies. We are creating a party of type "Organization" for the buying groups and management companies and associating all the customers to these buying groups as party relationships. Ideally this client looks for all the sales reporting for the customers associated to these buying groups/management companies at the end of the month to pay them the royalities/commissions.
So are there any oracle seeded reports(order details) which we can run based on the buying group/management company party and their party relationships with the customers or do we need to write the custom reports??