DPP Offers Promotions Notification Log
Description
Categories: BI Publisher
Application: Oracle Price Protection
Source:
Short Name: DPPPROLG
DB package:
Source:
Short Name: DPPPROLG
DB package:
Run
DPP Offers Promotions Notification Log and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |