eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: APPS.OKS_LAYOUT_TEMPLATES_V

Source

View Text - Preformatted


SELECT XTVL.TEMPLATE_ID, XTVL.TEMPLATE_NAME, FNDLK.MEANING TEMPLATE_TYPE, XTVL.DESCRIPTION, XTVL.TEMPLATE_CODE FROM XDO_TEMPLATES_VL XTVL, FND_LOOKUPS FNDLK WHERE XTVL.APPLICATION_ID = 515 AND XTVL.TEMPLATE_TYPE_CODE = 'RTF' AND XTVL.TEMPLATE_TYPE_CODE = FNDLK.LOOKUP_CODE AND FNDLK.LOOKUP_TYPE = 'XDO_TEMPLATE_TYPE' AND FNDLK.ENABLED_FLAG = 'Y' AND SYSDATE BETWEEN XTVL.START_DATE AND NVL(XTVL.END_DATE,SYSDATE) AND NVL(XTVL.DEPENDENCY_FLAG,'P') = 'P'

View Text - HTML Formatted

SELECT XTVL.TEMPLATE_ID
, XTVL.TEMPLATE_NAME
, FNDLK.MEANING TEMPLATE_TYPE
, XTVL.DESCRIPTION
, XTVL.TEMPLATE_CODE
FROM XDO_TEMPLATES_VL XTVL
, FND_LOOKUPS FNDLK
WHERE XTVL.APPLICATION_ID = 515
AND XTVL.TEMPLATE_TYPE_CODE = 'RTF'
AND XTVL.TEMPLATE_TYPE_CODE = FNDLK.LOOKUP_CODE
AND FNDLK.LOOKUP_TYPE = 'XDO_TEMPLATE_TYPE'
AND FNDLK.ENABLED_FLAG = 'Y'
AND SYSDATE BETWEEN XTVL.START_DATE
AND NVL(XTVL.END_DATE
, SYSDATE)
AND NVL(XTVL.DEPENDENCY_FLAG
, 'P') = 'P'