Skip to Main Content

SQLcl: MCP Server & SQL Prompt

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

need to query Customer Receivable Account oracle fusion cloud

user1056100Mar 21 2017 — edited Mar 24 2017

Hi,

Can anyone please guide me how to query customer's Receivable account in oracle fusion cloud. I have googled and found out that accounts information is present in "ar_ref_accounts_all" table. but there is no join column in it with the hz_parties / sites table.

Please Help.

Regards

Comments
Post Details
Added on Mar 21 2017
1 comment
811 views