Receivables - EBS (MOSC)

MOSC Banner

RA_CUSTOMER_TRX_ALL and AR_RECEIPT_METHOD_ACCOUNTS_ALL

edited Jul 2, 2015 10:00AM in Receivables - EBS (MOSC) 9 commentsAnswered

Hi,

I'd like to create a BI report to extract transaction information.

When I create a transaction, I can choose Receipt Method with associated bank account:

How can I extract account information from RA_CUSTOMER_TRX_ALL?

There I can extract receipt method, but not the related bank account.

Receipt methods and bank accounts are stored in AR_RECEIPT_METHOD_ACCOUNTS_ALL table, but I'm not able to find the join between these two.

Any suggestion?

Thanks

Martina

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center