About Me

My photo
Oracle Apps- Technical consultant

Friday, August 26

XML Template code and template name

we can get Lob_Code  from this query to get the details of  RTF files.  Query with lob_code in the application in case if we don't know the  template name

select * from XDO_LOBS
where file_name like '%po_terms%'
and XDO_File_type='RTF'
--and trunc(last_update_date)=trunc(sysdate)

No comments: