ERPstuff - Oracle EBS Community

Dear all
I m having master detail form relations in oracle apps customised form...

At master level i m entering data,based on that i m entering invoice no in detail leval which is having multiline rows,by using list of value.When i go to next record the invoice no which i have previously assigned it should not display or appear in in list of value without saving.

To resolve above problem where should i have to write code...

Regards
Shekhar

shekhar

Hmm bit tricky...........hope someone will have some solution. Let's wait...

Use global variable and check master record with that varibale

hope you understad it if any confisuion please reply

take care

Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807

When ever you pray
Please remember me and my family

[quote]Use global variable and check master record with that varibale
<i><div align="right">Originally posted by mirza_rehan

[quote]At master level i m entering data,based on that i m entering invoice no in detail leval which is having multiline rows,by using list of value.When i go to next record the invoice no which i have previously assigned it should not display or appear in in list of value without saving.
<i><div align="right">Originally posted by shekhar12

HI

YES,ACTUALY MY FORM IS DD REQUEST FORM,AFTER ENTERRING INVICE NO AND OTHER DETAILS I M SAVING MASTER AND DETAIL RECORD,BASED ON THAT I GET A DD REQUEST ID.

==================================

MY REQUIREMENT IS WHEN I M ASSIGNING A PERTICULAR INVOICE NO TO AGAINT VENDOR,IT SHOULD NO APPEAR IN LOV NEXT TIME WHEN I AM ENTERING INVOICE IN SECOND ROW .

=================


shekhar

Its very simple just place this value in a global variable and write down lov record group query as

Select * from table name
where inv_no <> 'variable'


Regards,
Ahmad