View: OKR_RESOURCE_GROUPS_V

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