how to convert Amount to Words
Summary:
in EBS we Used Pacjage AP_AMOUNT_UTILITIES_PKG to convert Amount numbers into Word
We see the same package in fusion but We do not understand how to use it - SQL returns error
is there any other way to translate number to words?
Content (please ensure you mask any confidential information):
in EBS we used:
SELECT ‘USD‘||REPLACE(AP_AMOUNT_UTILITIES_PKG.ap_convert_number(REGEXP_SUBSTR (x_tot_amount, ‘[^.]+’, 1, 1))||
DECODE(AP_AMOUNT_UTILITIES_PKG.ap_convert_number(REGEXP_SUBSTR (x_tot_amount, ‘[^.]+’, 1, 2)),NULL,’ Only’,
‘ and Paisa’||AP_AMOUNT_UTILITIES_PKG.ap_convert_number(REGEXP_SUBSTR (x_tot_amount, ‘[^.]+’, 1, 2))||’ Only’),’-‘,’ ‘)
0