VIEW: APPS.PA_RESOURCE_TYPES_ACTIVE_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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