VIEW: APPS.OE_PRINT_SREP_LOCTN_V

Source

View Text - Preformatted

SELECT jrs.salesrep_id, jre.category, pp.email_address, pp.internal_location, pp.mailstop, pp.office_number from jtf_rs_salesreps jrs, jtf_rs_resource_extns jre, per_all_people_f pp WHERE jrs.resource_id = jre.resource_id and jre.category = 'EMPLOYEE' and jre.source_id = pp.person_id and sysdate between pp.effective_start_date and nvl(pp.effective_end_date,sysdate)

View Text - HTML Formatted

SELECT JRS.SALESREP_ID
, JRE.CATEGORY
, PP.EMAIL_ADDRESS
, PP.INTERNAL_LOCATION
, PP.MAILSTOP
, PP.OFFICE_NUMBER
FROM JTF_RS_SALESREPS JRS
, JTF_RS_RESOURCE_EXTNS JRE
, PER_ALL_PEOPLE_F PP
WHERE JRS.RESOURCE_ID = JRE.RESOURCE_ID
AND JRE.CATEGORY = 'EMPLOYEE'
AND JRE.SOURCE_ID = PP.PERSON_ID
AND SYSDATE BETWEEN PP.EFFECTIVE_START_DATE
AND NVL(PP.EFFECTIVE_END_DATE
, SYSDATE)