DPP Customer Inventory Claim Log

Description
Categories: BI Publisher
Columns: Startdate, Enddate, Executionstatus, Txnnumber, Claimnumber, Itemnumber, Customername, Reason, Currency ...
Application: Oracle Price Protection
Source:
Short Name: DPPCSTCLLG
DB package:
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),'//CLAIMNUMBER/text()').getStringVal() as CLAIMNUMBER,
extract(value(w), '//ITEMNUMBER/text()')