Home » Applications » Oracle Fusion Apps & E-Business Suite » Join gl_je_lines with iby_payments_all (R12)
Join gl_je_lines with iby_payments_all [message #489318] Fri, 14 January 2011 07:13 Go to next message
davholla
Messages: 116
Registered: August 2009
Location: London
Senior Member
I want to create a query to see what journals are associated with a payment for reasons which are too complex to explain here.

However as I am new to R12 I am not sure what the link is.

Could anyone enlighten me?
Re: Join gl_je_lines with iby_payments_all [message #489368 is a reply to message #489318] Sat, 15 January 2011 04:27 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
Check whether this helps.
http://www.orafaq.com/node/2242
I think the linkage is ap_checks_all.payment_id => iby_payments_all.payment_id

By
Vamsi
Re: Join gl_je_lines with iby_payments_all [message #489437 is a reply to message #489368] Sun, 16 January 2011 10:05 Go to previous messageGo to next message
davholla
Messages: 116
Registered: August 2009
Location: London
Senior Member
vamsi kasina wrote on Sat, 15 January 2011 10:27
Check whether this helps.
http://www.orafaq.com/node/2242
I think the linkage is ap_checks_all.payment_id => iby_payments_all.payment_id

By
Vamsi

Thanks but how do I link it to the journal lines?
Re: Join gl_je_lines with iby_payments_all [message #489445 is a reply to message #489437] Sun, 16 January 2011 11:34 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
Have you clicked the link at least?

By
Vamsi
Re: Join gl_je_lines with iby_payments_all [message #489456 is a reply to message #489445] Sun, 16 January 2011 14:45 Go to previous messageGo to next message
davholla
Messages: 116
Registered: August 2009
Location: London
Senior Member
My apologies I was being attacked by a 2 year old.
That looks very useful I will try it at work tomorrow.
Re: Join gl_je_lines with iby_payments_all [message #489810 is a reply to message #489456] Wed, 19 January 2011 05:16 Go to previous message
davholla
Messages: 116
Registered: August 2009
Location: London
Senior Member
That link is perfect - thank you so much.

I have written 2 queries to join invoices and payments.
I will post them later to help others.
Previous Topic: Event Alert
Next Topic: E-Business screen Web screens
Goto Forum:
  


Current Time: Fri Mar 29 08:04:16 CDT 2024