Here is my LiveReport in SQL, I need it converted to Oracle
select DataID, [Contract Folder], [Contract Document], [Created On], [Modified On], [Contract Name],
[Contract Expiration Date], [Auto Archiving], [Expiration Notification Distribution Groups],
[Expiration Notification User Emails], [Expiration Advanced Notice (in days)],
[Contract Effective Date], [Contract Type], [CVR Entity], [Counterparty],
[Contract Description (Brief)], [Signatory (CVR)], [Signing Date (CVR)], [Functional Group],
[Type of Term], [Contract Template (CVR/Counterparty)], [Auto-renewal],
[Notice Period for Renewal (in days)], [Notice Period for Termination (in days)], [Period (in Months)],
[Maximo Supplier ID], [Original or Amended], [Original Contract Date in Case of Amendment],
[Estimated Dollar Value], [Pricing Structure]
from ( select dtree.DataID, [Created On] = convert(varchar, dtree.CreateDate, 101),
[Modified On] = convert(varchar, dtree.ModifyDate, 101), [Contract Folder] = replace(dbo.Path (dtree.ParentID),
'\Enterprise\Contract Management\',''), [Contract Document] = dtree.Name, [AttributeName] = a.Attribute,
[AttributeValue] = a.Value from DTreeCore dtree WITH(NOLOCK)
join DTreeAncestors topFolder WITH(NOLOCK) on topFolder.DataID = dtree.DataID left join NodeAttributes a
WITH(NOLOCK) on a.DataID = dtree.DataId and a.Category = 'Contract Management'
where 1=1 and dtree.Subtype <> 0 and dtree.Deleted = 0 and topFolder.AncestorID = %1 and %3
and datediff(DAY, dtree.CreateDate, CURRENT_TIMESTAMP) <= %2 and %3)
p PIVOT ( MAX(AttributeValue) FOR AttributeName IN ( [Contract Name], [Contract Expiration Date],
[Auto Archiving], [Expiration Notification Distribution Groups], [Expiration Notification User Emails],
[Expiration Advanced Notice (in days)], [Contract Effective Date], [Contract Type], [CVR Entity],
[Counterparty], [Contract Description (Brief)], [Signatory (CVR)], [Signing Date (CVR)],
[Functional Group], [Type of Term], [Contract Template (CVR/Counterparty)], [Auto-renewal],
[Notice Period for Renewal (in days)], [Notice Period for Termination (in days)], [Period (in Months)],
[Maximo Supplier ID], [Original or Amended], [Original Contract Date in Case of Amendment],
[Estimated Dollar Value], [Pricing Structure] ) ) AS PivotTable ORDER BY 2,3 ;
