| ACCOUNT PAYABLES [message #386111] |
Thu, 12 February 2009 13:00  |
bharatt19
Messages: 7
Registered: February 2009
Location: banglore
|
Junior Member |
|
|
Do you know of a view or sql query that can tie back from GL to Payables at a detail transaction level. We are unable to do this currently. We have an urgent request from management to provide this. Any help you can offer would be appreciated.
|
|
|
|
|
|
| Re: ACCOUNT PAYABLES [message #386234 is a reply to message #386111] |
Fri, 13 February 2009 03:48  |
dr.s.raghunathan
Messages: 540
Registered: February 2008
|
Senior Member |
|
|
dear bharatt19,
yes it is possible. if you provide us the related table structure many persons can give you business logic and then translating into sql querry would be very simple task. Ignore my reply if you are talking about oracle financials
yours
dr.s.raghunathan
|
|
|
|
|
|
| Re: ACCOUNT PAYABLES [message #387957 is a reply to message #386360] |
Sun, 22 February 2009 12:06 |
 |
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
|
Senior Member |
|
|
I think it is 11i...Am I right? If so,
take gl_import_references.gl_sl_link_table and gl_sl_link_id and tie back it to ap_ae_lines_all.
From there go back to ap_ae_headers_all, ap_accounting_events_all, ap_invoice_distributions_all and then to ap_invoices_all.
Hope this helps you.
By
Vamsi
PS: Hope you know that Oracle relased R12 also. Better to mention your release version, while seeking the answers.
[Updated on: Sun, 22 February 2009 12:14] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
