[Home] [Help]
View: 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
Name |
RESOURCE_TYPE_ID |
RESOURCE_TYPE_NAME |
RESOURCE_CLASS_CODE |
RESOURCE_TYPE_CODE |
GROUP_FLAG |
DESCRIPTION |
TABLE_NAME |
ACCESS_KEY |
SQL_TEXT |