View: PA_RESOURCE_TYPES_ACTIVE_V

Product:	PA - Projects
Description:	10Sc only
Implementation/DBA Data:	APPS.PA_RESOURCE_TYPES_ACTIVE_V

View Text

SELECT RESOURCE_TYPE_ID
, NAME
, RESOURCE_CLASS_CODE
, RESOURCE_TYPE_CODE
, GROUP_FLAG
, DESCRIPTION
, TABLE_NAME
, ACCESS_KEY
, SQL_TEXT
FROM PA_RESOURCE_TYPES
WHERE TRUNC(SYSDATE) BETWEEN START_DATE_ACTIVE
AND NVL(END_DATE_ACTIVE
, TRUNC(SYSDATE))

Columns