DPP Customer Inventory Claim Log
Description
- Categories
- BI Publisher
- Application
- Oracle Price Protection
- Source
- Short Name
- DPPCSTCLLG
DB package:
SQL 14 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('//TXNNUMBER/text()').getStringVal() as TXNNUMBER, extract(value(w),'//CLAIMNUMBER/text()').getStringVal() as CLAIMNUMBER, extract(value(w), '//ITEMNUMBER/text()').getStringVal() as ITEMNUMBER, extract(value(w), '//CUSTOMERNAME/text()').getStringVal() as CUSTOMERNAME, extract(value(w), '//REASON/text()').getStringVal() as REASON, extract(value(w), '//CURRENCY/text()').getStringVal() as CURRENCY 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 |