List of value should perform following

[shekhar12]

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

[admin]

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

[mirza_rehan]

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

[Kashif]

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

[Kashif]

[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

[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

[RiazAhmad]

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