OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » How to pull Invoice Number for a receipt(Technical)

Home » Applications » Oracle Fusion Apps & E-Business Suite » How to pull Invoice Number for a receipt(Technical)

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

How to pull Invoice Number for a receipt(Technical) [message #179453]

Tue, 27 June 2006 08:44

mchittib
Messages: 87
Registered: September 2005

Member

Hi there,
Can someone please tell for a particular receipt how to pull the invoice number to which it has been applied.

Thanks,
Mchittib.

Report message to a moderator

Re: How to pull Invoice Number for a receipt(Technical) [message #179498 is a reply to message #179453]

Tue, 27 June 2006 13:56

agostino_neto
Messages: 180
Registered: July 2005

Senior Member

Are talking of AR or AP ?
Do you know how to do it from front end (using standard forms) ?
Do you want to do it with Sql ?

Report message to a moderator

Re: How to pull Invoice Number for a receipt(Technical) [message #179507 is a reply to message #179498]

Tue, 27 June 2006 14:53

mchittib
Messages: 87
Registered: September 2005

Member

AR module.
Don't know to do it from frnot end.
Do it from sql.

Report message to a moderator

Re: How to pull Invoice Number for a receipt(Technical) [message #179524 is a reply to message #179507]

Tue, 27 June 2006 16:44

agostino_neto
Messages: 180
Registered: July 2005

Senior Member

Look for the following tables in eTRM
AR_RECEIVABLE_APPLICATIONS_ALL
AR_CASH_RECEIPTS_ALL
RA_CUSTOMER_TRX_ALL
It is always useful to learn how to do things from front end.

Report message to a moderator

Re: How to pull Invoice Number for a receipt(Technical) [message #179556 is a reply to message #179453]

Wed, 28 June 2006 00:12

patelhemantg
Messages: 25
Registered: May 2006

Junior Member

Hi,

Go to AR Super user Responsibility.
Go to Receipts--> Receipts
query on particular receipt(F11)
click on application (see the field Apply to)

now u will get transaction number in that form.

Report message to a moderator

Re: How to pull Invoice Number for a receipt(Technical) [message #180001 is a reply to message #179556]

Thu, 29 June 2006 11:47

mchittib
Messages: 87
Registered: September 2005

Member

Thanks ngouadjeu, for your suggestion.
It worked.
Thanks a lot for others response too.

Report message to a moderator

Re: How to pull Invoice Number for a receipt(Technical) [message #180039 is a reply to message #180001]

Thu, 29 June 2006 22:36

patelhemantg
Messages: 25
Registered: May 2006

Junior Member

Try this:

SELECT
arav.TRX_NUMBER, arav.CUSTOMER_ID ,arav.CUSTOMER_NAME , arav.CUSTOMER_TRX_ID
FROM
AR_CASH_RECEIPTS_v acrv, AR_RECEIVABLE_APPLICATIONS_v arav
WHERE
acrv.receipt_number='000104' -- receipt # of ur choice...
AND acrv.cash_receipt_id=arav.cash_receipt_id

Thanks,
Hemant Patel.

Report message to a moderator

Previous Topic:	OM Transactional Currency Code
Next Topic:	move order

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 14:18:50 CST 2024