ERPstuff - Oracle EBS Community

Hello all,

I am new to this forums.I am very glad to see you all.
I had one urgent problem in AP Report.Here is the scenario
I had three tables,among them one is custom table.
Tables are:ap_invoices_all,ap_invoice_distributions_all,custom table.
I want to write a SQL query and should develop concurrent program.When i run the concurrent program,the table should consists of all the columns from these three tables.

Any other doubts and issues please let me know.

Thanks in advance all of you
I hope you will help me.

Regards,
krishna.

Hi krishna

You can made a program unit in the report builder & it running in the trigger "Before report".

Then you can put it on the application as a customize reports.

Thanks
Hisham

Helo,

I want the solution by using sql statements.

Plz help me.

Thanks,
Bye.