SELECT NAME TEMPLATE_NAME , DESCRIPTION , ID TEMPLATE_ID FROM OKS_COVERAGE_TEMPLTS_V WHERE ITEM_TYPE IN ( 'SERVICE' ,'SUBSCRIPTION') AND (SYSDATE BETWEEN NVL(START_DATE, SYSDATE) AND NVL(END_DATE, SYSDATE))
View Text - HTML Formatted
SELECT NAME TEMPLATE_NAME , DESCRIPTION , ID TEMPLATE_ID FROM OKS_COVERAGE_TEMPLTS_V WHERE ITEM_TYPE IN ( 'SERVICE' , 'SUBSCRIPTION') AND (SYSDATE BETWEEN NVL(START_DATE , SYSDATE) AND NVL(END_DATE , SYSDATE))