View: OE_AK_SRV_TEMPLATE_V

Product:	ONT - Order Management
Description:	Used for defaulting of Coverage Template and Subscription Template on Service Items
Implementation/DBA Data:	APPS.OE_AK_SRV_TEMPLATE_V

View Text

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))

Columns