Home » Applications » Oracle Fusion Apps & E-Business Suite » How to join ap_checks_all with ce_statement_lines (Fusion Cloud R12)
How to join ap_checks_all with ce_statement_lines [message #663465] Mon, 05 June 2017 04:21 Go to next message
GeoC
Messages: 1
Registered: June 2017
Junior Member
Hi,

I am trying to write some SQL that checks bank statement lines in ce_statement_lines against payments in ap_checks_all. Can anyone tel me the correct reference to join on between these two tables please?

Thanks
Re: How to join ap_checks_all with ce_statement_lines [message #663564 is a reply to message #663465] Thu, 08 June 2017 04:47 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
Hi,

Please check if this helps.

ap_checks_all.bank_account_id = ce_statement_headers.bank_account_id
AND ce_statement_lines.statement_header_id = ce_statement_headers.statement_header_id
AND TO_CHAR(ap_checks_all.check_number) = ce_statement_lines.bank_trx_number

By
Vamsi
Re: How to join ap_checks_all with ce_statement_lines [message #663576 is a reply to message #663465] Thu, 08 June 2017 15:55 Go to previous message
Lubna
Messages: 12
Registered: June 2017
Junior Member
You should have to provide sample data to give you exact reply.
Previous Topic: WED ADI Process
Next Topic: How to pass parameters to ADF from EBS(Ex:User Id) (merged 3)
Goto Forum:
  


Current Time: Mon Mar 18 22:01:39 CDT 2024