This content has been marked as final. Show 4 replies
1. If I were you I will ask user to specify transaction types or accounts because user maybe do not want some kind of transaction example: interest invoices etc. Maybe want only transaction from order entry. You must check this.
2. I'm not developer but look at http://www.oracleappshub.com/accounts-receivable/ar-back-to-basictechnical-foundation/ this will help you.
I pick this sql from http://www.oraclebusinessapps.com/downloads/revcogs1/revcogs.sql
Look at account_class = 'REV'
WHERE customer_trx_line_id IN (
WHERE interface_line_context = 'ORDER ENTRY'
AND interface_line_attribute6 IN (SELECT line_id
WHERE header_id = (SELECT header_id
WHERE order_number = &your_order_number))
AND account_set_flag = 'N'
AND account_class = 'REV');