VIEW: APPS.IEX_DELIVERY_TEMPLATES_V

Source

View Text - Preformatted

SELECT fm.template_name, fm.template_id, upper(fm.template_name) from jtf_fm_template_all fm WHERE exists ( select 1 from iex_app_preferences_vl where PREFERENCE_ID = 1003 and PREFERENCE_VALUE = 'FFM' ) union all SELECT xml.template_name, xml.template_id, upper(xml.template_name) from xdo_templates_vl xml where application_short_name = 'IEX' -- Commented to fix 12785555 /*and (TRUNC(SYSDATE) BETWEEN TRUNC (NVL(start_date, SYSDATE)) AND TRUNC(NVL(end_date, SYSDATE)))*/ and exists ( select 1 from iex_app_preferences_vl where PREFERENCE_ID = 1003 and PREFERENCE_VALUE = 'XML' ) order by 3

View Text - HTML Formatted

SELECT FM.TEMPLATE_NAME
, FM.TEMPLATE_ID
, UPPER(FM.TEMPLATE_NAME)
FROM JTF_FM_TEMPLATE_ALL FM
WHERE EXISTS ( SELECT 1
FROM IEX_APP_PREFERENCES_VL
WHERE PREFERENCE_ID = 1003
AND PREFERENCE_VALUE = 'FFM' ) UNION ALL SELECT XML.TEMPLATE_NAME
, XML.TEMPLATE_ID
, UPPER(XML.TEMPLATE_NAME)
FROM XDO_TEMPLATES_VL XML
WHERE APPLICATION_SHORT_NAME = 'IEX' -- COMMENTED TO FIX 12785555 /*AND (TRUNC(SYSDATE) BETWEEN TRUNC (NVL(START_DATE
, SYSDATE))
AND TRUNC(NVL(END_DATE
, SYSDATE)))*/
AND EXISTS ( SELECT 1
FROM IEX_APP_PREFERENCES_VL
WHERE PREFERENCE_ID = 1003
AND PREFERENCE_VALUE = 'XML' ) ORDER BY 3