View: OE_PRINT_SREP_LOCTN_V

Product:	ONT - Order Management
Description:
Implementation/DBA Data:	APPS.OE_PRINT_SREP_LOCTN_V

View Text

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)

Columns