View: ICX_TEMPLATE_LOV

Product:	ICX - Oracle iProcurement
Description:	Template Heirarchy Definition LOV View
Implementation/DBA Data:	APPS.ICX_TEMPLATE_LOV

View Text

SELECT EXPRESS_NAME
, DESCRIPTION
FROM PO_REQEXPRESS_HEADERS
WHERE SYSDATE <= NVL(INACTIVE_DATE
, SYSDATE+1)
AND TYPE_LOOKUP_CODE = 'PURCHASE'

Columns