Disable and enable item at record level based on condition
735423Nov 20 2009 — edited Nov 20 2009Hello 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