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:
Posts (Atom)
SQL Query to Convert number into Words for Money
SELECT INITCAP ( DECODE ( FLOOR (TO_NUMBER ( :amount)), 0, '', TO_CHAR (TO_DATE...
-
You are not setup as a worker. To access this Page you need to be a worker. EBS R12 this is the problem How to solve it...
-
case we needs to Download The HR Workflow but instead of English Descriptions and all the Subjects we needs to appears it by Arabic languag...