DBA Data[Home] [Help]

VIEW: APPS.OKS_REP_V

Source

View Text - Preformatted

SELECT DISTINCT res.resource_name name, sr.salesrep_id resource_id , sr.org_id from jtf_rs_salesreps sr, jtf_rs_resource_extns_vl res WHERE res.resource_id = sr.resource_id
View Text - HTML Formatted

SELECT DISTINCT RES.RESOURCE_NAME NAME
, SR.SALESREP_ID RESOURCE_ID
, SR.ORG_ID
FROM JTF_RS_SALESREPS SR
, JTF_RS_RESOURCE_EXTNS_VL RES
WHERE RES.RESOURCE_ID = SR.RESOURCE_ID