OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Join gl_je_lines with iby_payments

Home » Applications » Oracle Fusion Apps & E-Business Suite » Join gl_je_lines with iby_payments_all (R12)

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

Join gl_je_lines with iby_payments_all [message #489318]

Fri, 14 January 2011 07:13

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?

Report message to a moderator

Re: Join gl_je_lines with iby_payments_all [message #489368 is a reply to message #489318]

Sat, 15 January 2011 04:27

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

Report message to a moderator

Re: Join gl_je_lines with iby_payments_all [message #489437 is a reply to message #489368]

Sun, 16 January 2011 10:05

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?

Report message to a moderator

Re: Join gl_je_lines with iby_payments_all [message #489445 is a reply to message #489437]

Sun, 16 January 2011 11:34

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Have you clicked the link at least?

By
Vamsi

Report message to a moderator

Re: Join gl_je_lines with iby_payments_all [message #489456 is a reply to message #489445]

Sun, 16 January 2011 14:45

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.

Report message to a moderator

Re: Join gl_je_lines with iby_payments_all [message #489810 is a reply to message #489456]

Wed, 19 January 2011 05:16

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.

Report message to a moderator

Previous Topic:	Event Alert
Next Topic:	E-Business screen Web screens

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 11:14:47 CST 2024