View: POR_PUBLIC_LISTS_V

Product:	ICX - Oracle iProcurement
Description:	Public shopping list view
Implementation/DBA Data:	APPS.POR_PUBLIC_LISTS_V

View Text

SELECT PR.EXPRESS_NAME
, PR.DESCRIPTION
, PR.INACTIVE_DATE
, PR.EXPRESS_NAME
FROM PO_REQEXPRESS_HEADERS PR
, ICX_POR_CATEGORIES_TL IC
WHERE PR.EXPRESS_NAME||'_TMPL' = IC.KEY
AND IC.TYPE = 3
AND IC.LANGUAGE = USERENV('LANG')
AND TRUNC(SYSDATE) < NVL(TRUNC(PR.INACTIVE_DATE)
, TRUNC(SYSDATE+1))

Columns