VIEW: APPS.OKC_RESOURCE_USERS_V

Source

View Text - Preformatted

SELECT distinct res.id1 id, res.resource_number, res.resource_type, res.name, res.description, res.start_date_active, res.end_date_active, rr.status, rr.delete_flag FROM OKX_RESOURCES_V RES,OKX_RESOURCE_ROLES_V RR WHERE rr.resource_type = 'RS_INDIVIDUAL' and rr.resource_id = res.id1

View Text - HTML Formatted

SELECT DISTINCT RES.ID1 ID
, RES.RESOURCE_NUMBER
, RES.RESOURCE_TYPE
, RES.NAME
, RES.DESCRIPTION
, RES.START_DATE_ACTIVE
, RES.END_DATE_ACTIVE
, RR.STATUS
, RR.DELETE_FLAG
FROM OKX_RESOURCES_V RES
, OKX_RESOURCE_ROLES_V RR
WHERE RR.RESOURCE_TYPE = 'RS_INDIVIDUAL'
AND RR.RESOURCE_ID = RES.ID1