Formatting Oracle Alerts
Hello Everyone:
Is it possible to format oracle Alerts?
Our Environment:-
Database 11.2.4.0 Oracle Apps = 12.2.5
I have tried to concatenate all the fields, padding them before doing it, tried printing individually, also tried my hand with dbms_xmlgen.getxml, none of them are producing a formatted output like one below.
PO # Line# Release# Buyer Name Vendor Release Status Item# Creation Date
=======================================================================================================================
PO1234 Ln12 Rel122 John Smith Mom and Pop Store Inc. Incomplete Item9999 12-Jun-2017
Here is the base query.
select rpad('PO#', 20, ' ') || ' ' || lpad('Line#', 10, ' ') || ' ' || lpad('Release#', 10, ' ') || ' ' ||