Skip to Main Content

Oracle Forms

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!

Disable and enable item at record level based on condition

735423Nov 20 2009 — edited Nov 20 2009
Hello folks,

I have tabular form based on custom table.
It has columns line_id,Actual Return Serial and line_type.

We have a requirement where we need to disable the item of column Actual Return Serial, if line_type = 'Return to Warhouse'.
and fetch the value from a following query and display the value.

SELECT rst.serial_num
INTO :FTU_WMS_RETURN_SERIAL_DETAILS.ACTUAL_RETURN_SERIAL
FROM rcv_transactions rt,
rcv_serial_transactions rst
WHERE rt.transaction_id = rst.transaction_id
AND rt.transaction_type = 'DELIVER'
AND rt.oe_order_line_id = :FTU_WMS_RETURN_SERIAL_DETAILS.line_id;

and we want to enable the item of column Actual Return Serial, if line_type = 'Return to Redemptech'.

If we have numbers of llines populated on the form and these lines have line type as 'Return to Warhouse' and 'Return to Redemptech',
then form should look like lines having 'Return to Warhouse' line types, for them column ACTUAL_RETURN_SERIAL
should have value and not enabled.

Whereas lines having 'Return to Redemptech' line types, for them column ACTUAL_RETURN_SERIAL
should enabled and editable.

Please provide your pointers on how to accomplish it?

Thanks and Regards
Sanket
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 18 2009
Added on Nov 20 2009
3 comments
1,394 views