Forms [32 Bit] Version 10.1.2.3.0
Oracle Apps R12
A Custom Form which captures Order Header and Lines details is developed and working.
- A change has to be made whereby one column(equipment_type) from previous line has to be copied when another line is being created. But the first line will be created earlier only. Then the Order is queried and new line will be added. To this new line, the equipment_type value has to be copied from existing record based on order_id and equipment_id. Which trigger should I use to read the database table and fetch the equipment_type
- Also, both the lines could be created at the same time. Meaning both records entered but saved at the same time. The matching conditions should be order_id and another field called equipment_id. How to read the value of a field(equipment_type) entered in the previous line and copy to next record.
Please suggest leads. Thanks in advance.