Hi I am looking for some technic

[radmur]

Hi

I am looking for some technical details on these reports , like what are the tables on which these reports are based. Pl it is very urgent.
Aging Bucket report,
Transaction register report
Deduction Transaction Detail Report
Duplicate Customer reports

Thanks in advance
RadMur

 

[jimbopalmer]

I confess I run the reports on my test system then look in the SQL cache and see what got run. I am sure that is not the best way but It works for me. I have also used the Unix command strings on my reports

I tried to remain child-like, all I acheived was childish.

 

[tracy1234]

Or, if you have a copy of Reports (6i or 9i), you can ftp a copy of your report to your desktop and take a look at the tables used by opening the queries in the Data Model.

You'll need to know your report short name and its location. In Unix, these are at $x_TOP\11.5.0\reports (x=module abbreviation ex: AR, for Receivables; INV for Inventory etc)

- Tracy

 

[HECL]

I can help u for aging bucket report.
this report is based on ar_aging_buckets_all
and ar_aging_bucket_lines_all