OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Thu, 14 October 2010 04:34

cylin
Messages: 5
Registered: October 2010

Junior Member

how to link
ap_invoices_all with gl_code_combinations

thanking in advance

Thu, 14 October 2010 12:06

Alien
Messages: 291
Registered: June 1999

Senior Member

Hi,

Select <X>
From Ap_invoices_all Ai
,    Gl_code_combinations Gc
where ai.accts_pay_code_combination_id=gc.code_combination_id

However, this is only the AP-account. Are you sure you are not looking for the charge-account from the invoice distributions?

Select <X>
From Ap_invoice_distributions_all Aid
,    Gl_code_combinations Gc
where aid.dist_code_combination_id = gc.code_combination_id

Regards,

Arian

Sat, 16 October 2010 23:54

cylin
Messages: 5
Registered: October 2010

Junior Member

hi

thanks a lot

Previous Topic:	error installing R12 on RHEL with rapidwiz
Next Topic:	Can you Process Participants' Enrollment Choices in SSBEN

Goto Forum:

]

Current Time: Tue Apr 23 19:04:06 CDT 2024