DPP Purchase Orders Log

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

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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('//TXNNUMBER/text()').getStringVal() as TXNNUMBER,
extract(value(w), '//ITEMNUMBER/text()').getStringVal() as ItemNumber,
extract(value(w), '//POTYPE/text()').getStringVal() as DocumentType,
extract(value(w), '//PONUMBER/text()').getStringVal() as DocumentNumber,
extract(value(w), '//LINENUMBER/text()').getStringVal() as LineNumber,
extract(value(w), '//REASON/text()').getStringVal() as ReasonForFailure
from DPP_EXECUTION_DETAILS DED,table(xmlsequence(extract(DED.OUTPUT_XML, 
'/ROWSET/ROOT/TRANSACTION/TRANSACTION_ROW'))) w
WHERE DED.EXECUTION_DETAIL_ID=:EXECUTION_DETAIL_ID
Download
 
Blitz Report™

Blitz Report™ provides multiple benefits: