[Home] [Help]
View: OKC_RESOURCE_USERS_V
View Text
SELECT DISTINCT RES.ID1 ID
, RES.RESOURCE_NUMBER
, RES.RESOURCE_TYPE
, RES.NAME
, RES.DESCRIPTION
, RES.START_DATE_ACTIVE
, RES.END_DATE_ACTIVE
, RR.STATUS
, RR.DELETE_FLAG
FROM OKX_RESOURCES_V RES
, OKX_RESOURCE_ROLES_V RR
WHERE RR.RESOURCE_TYPE = 'RS_INDIVIDUAL'
AND RR.RESOURCE_ID = RES.ID1
Columns
| Name |
| ID |
| RESOURCE_NUMBER |
| RESOURCE_TYPE |
| NAME |
| DESCRIPTION |
| START_DATE_ACTIVE |
| END_DATE_ACTIVE |
| STATUS |
| DELETE_FLAG |
APPS.OKC_RESOURCE_USERS_V