DPP Outbound Price lists Notification Log

➜ Back to Library
XMLXML import file

Description

Categories
BI Publisher
Application
Oracle Price Protection
Source
Short Name
DPPOUTBDLG
DB package:

SQL 10 lines

select 
to_char(DED.EXECUTION_START_DATE,'dd-Mon-yyyy HH24:MI:ss')STARTDATE,
to_char(DED.EXECUTION_END_DATE,'dd-Mon-yyyy HH24:MI:ss') ENDDATE,
DED.EXECUTION_STATUS as EXECUTIONSTATUS,
DED.OUTPUT_XML.extract('//ERRORMSG/text()').getStringVal() as ErrorMsg,
DED.OUTPUT_XML.extract('//TXNNUMBER/text()').getStringVal() as TransactionNumber,
DED.OUTPUT_XML.extract('//NAME/text()').getStringVal() as Name
        from DPP_EXECUTION_DETAILS DED
        WHERE DED.EXECUTION_DETAIL_ID=:EXECUTION_DETAIL_ID