View: ICX_REQ_TEMPLATES_V

Product:	ICX - Oracle iProcurement
Description:	Templates View
Implementation/DBA Data:	APPS.ICX_REQ_TEMPLATES_V

View Text

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

Columns