This Blog for Sharing Knowledge that related to Oracle ERP EBS R12 -------------------------------------------------------------------------------------------------------------------------- *note :- some topics are copied just to share the knowladge*
Wednesday, May 15, 2024
SQL Query to Convert number into Words for Money
SELECT INITCAP (
DECODE (
FLOOR (TO_NUMBER ( :amount)),
0, '',
TO_CHAR (TO_DATE (FLOOR (TO_NUMBER ( :amount)), 'J'), 'JSP')
|| ' '
|| 'Dirham'
|| DECODE (
MOD (TO_NUMBER ( :amount) * 100, 100),
0, '',
' AND ('
|| TO_CHAR (
TO_DATE (MOD (TO_NUMBER ( :amount) * 100, 100), 'J'),
'JSP')
|| ' Fils)')))
FROM DUAL;
Subscribe to:
Post Comments (Atom)
SQL Query to Convert number into Words for Money
SELECT INITCAP ( DECODE ( FLOOR (TO_NUMBER ( :amount)), 0, '', TO_CHAR (TO_DATE...
-
now we are going to handle User hook case and it use when we want to validate EIT Or SIT in both case Self Service or Professional View (Fo...
-
Note this when its Submit but if still in AME Cycle Use Wrok Flow to approve then delete it or Reject -- The API --- DECLARE CUR...
No comments:
Post a Comment