DBA Data[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'