[Home] [Help]
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
Name |
GROUP_ID |
GROUP_NUMBER |
NAME |
DESCRIPTION |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
STATUS |
DELETE_FLAG |