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))
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))
|
|
|