View: PA_EVENT_TYPES_LOV_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_EVENT_TYPES_LOV_V

View Text

SELECT ET.EVENT_TYPE
, ET.DESCRIPTION
, L.MEANING
, ET.EVENT_TYPE_CLASSIFICATION
FROM PA_EVENT_TYPES ET
, PA_LOOKUPS L
WHERE L.LOOKUP_TYPE='EVENT TYPE CLASSIFICATION'
AND L.LOOKUP_CODE=ET.EVENT_TYPE_CLASSIFICATION
AND L.LOOKUP_CODE NOT IN ('AUTOMATIC'
, 'REALIZED_GAINS'
, 'REALIZED_LOSSES')
AND (TRUNC(SYSDATE) BETWEEN ET.START_DATE_ACTIVE
AND NVL(ET.END_DATE_ACTIVE
, TRUNC(SYSDATE)))

Columns