OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » How to join ap_checks_all with ce_statement

Home » Applications » Oracle Fusion Apps & E-Business Suite » How to join ap_checks_all with ce_statement_lines (Fusion Cloud R12)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to join ap_checks_all with ce_statement_lines [message #663465]

Mon, 05 June 2017 04:21

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

Report message to a moderator

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

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

Report message to a moderator

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

Lubna
Messages: 12
Registered: June 2017

Junior Member

You should have to provide sample data to give you exact reply.

Report message to a moderator

Previous Topic:	WED ADI Process
Next Topic:	How to pass parameters to ADF from EBS(Ex:User Id) (merged 3)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 09 16:54:53 CST 2025