View: OKC_RESOURCE_GROUPS_V

Product:	OKC - Contracts Core
Description:	View for resource groups of role Contracts
Implementation/DBA Data:	APPS.OKC_RESOURCE_GROUPS_V

View Text

SELECT DISTINCT RGP.GROUP_ID
, RGP.GROUP_NUMBER
, RGP.GROUP_NAME NAME
, RGP.GROUP_DESC DESCRIPTION
, RGP.START_DATE_ACTIVE
, RGP.END_DATE_ACTIVE
, RR.STATUS
, RR.DELETE_FLAG
FROM JTF_RS_GROUPS_VL RGP
, OKX_RESOURCE_ROLES_V RR
WHERE RR.RESOURCE_TYPE = 'RS_GROUP'
AND RR.RESOURCE_ID = RGP.GROUP_ID

Columns