View: PA_SERVICE_TYPE_LOV_V

Product:	PA - Projects
Description:	This view displays all valid service types that can be specified for a task
Implementation/DBA Data:	APPS.PA_SERVICE_TYPE_LOV_V

View Text

SELECT LOOKUP_CODE
, MEANING
FROM PA_LOOKUPS
WHERE LOOKUP_TYPE= 'SERVICE TYPE'
AND ENABLED_FLAG = 'Y'
AND TRUNC(SYSDATE) BETWEEN START_DATE_ACTIVE
AND NVL(END_DATE_ACTIVE
, TRUNC(SYSDATE))

Columns