Way to success...

--"Running Away From Any PROBLEM Only Increases The DISTANCE From The SOLUTION"--.....--"Your Thoughts Create Your FUTURE"--.....--"EXCELLENCE is not ACT but a HABIT"--.....--"EXPECT nothing and APPRECIATE everything"--.....

Friday, April 6, 2018

Query to get XML Template Code details from Database

As you know we upload the XML Templates from XML Publisher Administrator responsibility, below is the navigation :

XML Publisher Administrator  Home  -> Templates

Please use below query to check the details in the backend database after the upload.


SELECT B.TEMPLATE_CODE,
  a.FILE_NAME,
  TO_CHAR(a.CREATION_DATE, 'DD-MON-YYYY HH24:MI:SS') "CREATION_DATE",
  TO_CHAR(a.LAST_UPDATE_DATE, 'DD-MON-YYYY HH24:MI:SS') "LAST_UPDATE_DATE"
FROM APPS.XDO_LOBS a,
  APPS.XDO_TEMPLATES_B B
WHERE a.LOB_CODE     = B.TEMPLATE_CODE
AND a.FILE_NAME = 'TEMP_CODE_ABC.rtf'
--AND B.TEMPLATE_CODE IN('TEMP_CODE_ABC')
AND a.XDO_FILE_TYPE  = 'RTF';

Update the FILE_NAME and TEMPLATE_CODE parameters according to requirement.