[Home] [Help]
View: OKR_RESOURCE_GROUPS_V
| Product: | OKR - Contracts for Rights (Obsolete) |
|---|
| Description: | |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT JRES.GROUP_ID GROUP_ID
, JRES.GROUP_NUMBER GROUP_NUMBER
, JRES.GROUP_NAME NAME
, JRES.GROUP_DESC DESCRIPTION
, JRES.START_DATE_ACTIVE START_DATE_ACTIVE
, JRES.END_DATE_ACTIVE END_DATE_ACTIVE
FROM JTF_RS_GROUPS_VL JRES
WHERE EXISTS (SELECT 'X'
FROM OKX_RESOURCE_ROLES_V RR
WHERE RR.RESOURCE_TYPE = 'RS_INDIVIDUAL'
AND RR.STATUS = 'A'
AND NVL(RR.DELETE_FLAG
, 'N') = 'N'
AND RR.RESOURCE_ID = JRES.GROUP_ID)
Columns
| Name |
| GROUP_ID |
| GROUP_NUMBER |
| NAME |
| DESCRIPTION |
| START_DATE_ACTIVE |
| END_DATE_ACTIVE |