AP Invoices

There are many available reports in Oracle Apps so you can discuss the requirements related to these reports here.
Post Reply
krishna4202224
Posts: 10
Joined: Sat Nov 22, 2008 11:21 pm
Location: USA

AP Invoices

Post by krishna4202224 »

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.
hiszaki
Posts: 482
Joined: Thu May 10, 2007 9:03 am
Location: Egypt

Post by hiszaki »

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
krishna4202224
Posts: 10
Joined: Sat Nov 22, 2008 11:21 pm
Location: USA

Post by krishna4202224 »

Helo,

I want the solution by using sql statements.

Plz help me.

Thanks,
Bye.
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests