[Home] [Help]
VIEW: APPS.ICX_TEMPLATE_LOV
Source
View Text - Preformatted
SELECT EXPRESS_NAME, DESCRIPTION FROM PO_REQEXPRESS_HEADERS WHERE SYSDATE <= NVL(INACTIVE_DATE, SYSDATE+1) AND TYPE_LOOKUP_CODE = 'PURCHASE'
View Text - HTML Formatted
SELECT EXPRESS_NAME
, DESCRIPTION
FROM PO_REQEXPRESS_HEADERS
WHERE SYSDATE <= NVL(INACTIVE_DATE
, SYSDATE+1)
AND TYPE_LOOKUP_CODE = 'PURCHASE'