VIEW: APPS.OKC_RESOURCE_GROUPS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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