Home » Applications » Oracle Fusion Apps & E-Business Suite » ACCOUNT PAYABLES (11I)
ACCOUNT PAYABLES [message #386111] Thu, 12 February 2009 13:00 Go to next message
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 #386114 is a reply to message #386111] Thu, 12 February 2009 14:43 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Is this Oracle Applications question? If so, would you like it to be moved over there?
Re: ACCOUNT PAYABLES [message #386234 is a reply to message #386111] Fri, 13 February 2009 03:48 Go to previous messageGo to next message
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 #386360 is a reply to message #386114] Fri, 13 February 2009 23:33 Go to previous messageGo to next message
bharatt19
Messages: 7
Registered: February 2009
Location: banglore
Junior Member
yes its oracle applications question ACCOUNT PAYABLES
Re: ACCOUNT PAYABLES [message #387957 is a reply to message #386360] Sun, 22 February 2009 12:06 Go to previous message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
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

Previous Topic: Copy On Hand quantity details
Next Topic: Update API failing on 'Primary Key' error..
Goto Forum:
  


Current Time: Sat Dec 03 18:16:09 CST 2016

Total time taken to generate the page: 0.17723 seconds