View: POR_EXPENDITURE_LOV_V

Product:	ICX - Oracle iProcurement
Description:	List of Values for Expenditure
Implementation/DBA Data:	APPS.POR_EXPENDITURE_LOV_V

View Text

SELECT EXPENDITURE_TYPE
, DESCRIPTION
, SYS_LINK_START_DATE_ACTIVE
, SYS_LINK_END_DATE_ACTIVE
FROM PA_EXPENDITURE_TYPES_EXPEND_V ET
WHERE ET.SYSTEM_LINKAGE_FUNCTION = 'VI'
AND (TRUNC(SYSDATE) BETWEEN ET.EXPND_TYP_START_DATE_ACTIVE
AND NVL( ET.EXPND_TYP_END_DATE_ACTIVE
, TRUNC(SYSDATE+1)))
AND (TRUNC(SYSDATE) BETWEEN ET.SYS_LINK_START_DATE_ACTIVE
AND NVL( ET.SYS_LINK_END_DATE_ACTIVE
, TRUNC(SYSDATE+1)))

Columns