[red]
Try to get the Oracle Applications Documentation Cd and refer the Technical reference.
To identify the tables being updated, open a window in oracle apps and use the Help menu and Record History.
Then you will find the Table name.
[/color]
[b]
If you want to compare, for instance, tbl.Payment with 200,
use this code:
decode(sign(tbl.Payment -200),0,'two hundred',1,'Greater than 200','less than 200').
This is a nice shortcut rather than writing the procedure.
The value of sign(tbl.Payment -200) is 0 if tbl.Payment = 200.
The value...
Hi,
Try to find the CD which has Oracle Applications Documentation Library.
In this reference, you have the Technical reference under the topic 'Detailed designs'.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.