SQL Script to get UCM uploaded File in Oracle Fusion.

 SQL Script to get UCM uploaded File in Oracle Fusion.

select
 DID ,
 DDOCNAME ,
 DDOCTYPE ,
 DDOCTITLE ,
 DDOCAUTHOR ,
 DSECURITYGROUP ,
 DCREATEDATE ,
 DINDATE ,
 DOUTDATE ,
 DSTATUS ,
 DRELEASESTATE ,
 DWEBEXTENSION ,
 DDOCACCOUNT ,
 DRELEASEDATE

from
 revisions
where DDOCNAME='UCMFA07515573'