Home » Applications » Oracle Fusion Apps & E-Business Suite » Building a Customer information form (Forms6i)
Building a Customer information form [message #423119] Tue, 22 September 2009 04:13 Go to next message
aiyaz_ma
Messages: 56
Registered: May 2009
Location: Hyderabad
Member

Hello all,

I am presently working on cutomer information form which includes customer number , customer name with which i have to get the payments and payments history details for these customers. I have started the form and did the customer details now need to get the payments details. Could any one give me how to get it done as my senior is not in town.I have to complete this ASAP. Quick response will be very helpful

Thanks and regards
Aiyaz.
Re: Building a Customer information form [message #423146 is a reply to message #423119] Tue, 22 September 2009 05:49 Go to previous messageGo to next message
shaz
Messages: 182
Registered: June 2009
Senior Member
Use the foreign keys of the tables and create the relationship between the customer detail and payment table.

Re: Building a Customer information form [message #423148 is a reply to message #423146] Tue, 22 September 2009 06:04 Go to previous messageGo to next message
aiyaz_ma
Messages: 56
Registered: May 2009
Location: Hyderabad
Member

hello shaz...
Thanks for the response...but that doesn't help me..Even i know that i have to join them. But what will be the tables in payments form ?

Thanks
Aiyaz
Re: Building a Customer information form [message #423150 is a reply to message #423148] Tue, 22 September 2009 06:12 Go to previous messageGo to next message
shaz
Messages: 182
Registered: June 2009
Senior Member
How can we tell you that dear. We don't know your database structure.


Re: Building a Customer information form [message #423154 is a reply to message #423150] Tue, 22 September 2009 06:24 Go to previous messageGo to next message
aiyaz_ma
Messages: 56
Registered: May 2009
Location: Hyderabad
Member


Its the apps standard receipts form in Receivables
Re: Building a Customer information form [message #423163 is a reply to message #423119] Tue, 22 September 2009 06:57 Go to previous messageGo to next message
cookiemonster
Messages: 12320
Registered: September 2008
Location: Rainy Manchester
Senior Member
Then you'd be better off posting this question in the oracle apps forum.
Re: Building a Customer information form [message #423425 is a reply to message #423163] Thu, 24 September 2009 02:23 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Can someone here help this person?

david
Re: Building a Customer information form [message #423528 is a reply to message #423425] Fri, 25 September 2009 02:00 Go to previous messageGo to next message
aiyaz_ma
Messages: 56
Registered: May 2009
Location: Hyderabad
Member

Hello All,

I have started the form and got struck in getting the payment details in my child records when i enter the customer name and number and press find button to get the details of payment receipt details....

I have used this code in find push button -----------

Declare
x varchar2(50):=:HOPE_CUSTOMER_FORM_X.customer_number;
y varchar2(200):=:HOPE_CUSTOMER_FORM_X.customer_name;
cursor c1 is select account_number,payment_method,receipt_number,receipt_date,code,amount,status,gl_date,functional_amount
from HOPE_PAYMENT_FORM_X
where HOPE_PAYMENT_FORM_X.account_number=x;
Begin
message(y);
--select customer_number into x from HOPE_CUSTOMER_FORM_X where customer_name=y;
open c1;
loop
--message(x);

fetch c1 into
:HOPE_PAYMENT_FORM_X.account_number,
:HOPE_PAYMENT_FORM_X.payment_method,
:HOPE_PAYMENT_FORM_X.receipt_number,
:HOPE_PAYMENT_FORM_X.receipt_date,
:HOPE_PAYMENT_FORM_X.code,
:HOPE_PAYMENT_FORM_X.amount,
:HOPE_PAYMENT_FORM_X.status,
:HOPE_PAYMENT_FORM_X.gl_date,
:HOPE_PAYMENT_FORM_X.functional_amount;

next_record();
--message(:HOPE_PAYMENT_FORM_X.account_number);
exit when c1%notfound;
end loop;
close c1;
End;


But that does't work..I need to get all the receipts under that customer.But instead i am getting only one record by record. I have used tabular form for the feilds.

Kindly help me ASAP...

Thanks in advance

M.A.Aiyaz
Re: Building a Customer information form [message #423529 is a reply to message #423425] Fri, 25 September 2009 02:01 Go to previous message
aiyaz_ma
Messages: 56
Registered: May 2009
Location: Hyderabad
Member

And Special thanks to David for special concern...
Previous Topic: Cannot install apps 11.5.10.2
Next Topic: using FND_PROFILE.GET to get values via sql environment (merged 2)
Goto Forum:
  


Current Time: Thu Sep 29 17:36:06 CDT 2016

Total time taken to generate the page: 0.13005 seconds