OraFAQ Forum: Forms » How to link Receivable(HZ

Home » Developer & Programmer » Forms » How to link Receivable(HZ_PARTIES) and its Bank Account?

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

How to link Receivable(HZ_PARTIES) and its Bank Account? [message #624544]

Tue, 23 September 2014 07:57

alex_shynk
Messages: 22
Registered: July 2014

Junior Member

How to link in SQL query a Receivable(HZ_PARTIES) and its Bank Account.

It is posible to see those accounts - Payables manager -> Suppliers -> Entry
search our receivable
Menu: Bank and account information

I have tried tracing SQL for that web form and parcing SQL queries but I got into true swamp

[Updated on: Tue, 23 September 2014 07:58]

Report message to a moderator

Re: How to link Receivable(HZ_PARTIES) and its Bank Account? [message #624563 is a reply to message #624544]

Tue, 23 September 2014 08:37

CraigB
Messages: 386
Registered: August 2014
Location: Utah, USA

Senior Member

Have you tried the Oracle eTRM (http://etrm.oracle.com/pls/etrm/etrm_search.search)? Start by searching the table (HZ_PARTIES). From there, you can research all of the tables that are related to HZ_PARTIES. Next to the Oracle Applications Documenation website (http://www.oracle.com/technetwork/documentation/applications-167706.html) it is one of your greatest resources. Also, I would recommend posting in the EBS General Questions forum on OTN or in the EBS forum here (http://www.orafaq.com/forum/f/26/).

Craig...

[Updated on: Tue, 23 September 2014 08:38]

Report message to a moderator

Previous Topic:	Forms 11g JDK version 1.6.0_12 Runtime opening blank screen
Next Topic:	How To Show Data Like This

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 16:35:58 CDT 2024