View: AS_PERSONS_ACTIVE_V

Product:	AS - Sales Foundation
Description:	Active sales representatives view
Implementation/DBA Data:	APPS.AS_PERSONS_ACTIVE_V

View Text

SELECT P.PERSON_ID
, P.FIRST_NAME
, P.LAST_NAME
, P.FIRST_NAME || ' ' || P.LAST_NAME
, J.NAME
, LOOK.MEANING
, P.WORK_TELEPHONE
, P.EMAIL_ADDRESS
, P.EMPLOYEE_NUMBER
FROM PER_ALL_PEOPLE_F P
, PER_ALL_ASSIGNMENTS_F A
, PER_JOBS J
, HR_LOOKUPS LOOK
WHERE P.PERSON_ID = A.PERSON_ID
AND A.PRIMARY_FLAG = 'Y'
AND A.ASSIGNMENT_TYPE = 'E'
AND P.EMPLOYEE_NUMBER IS NOT NULL
AND J.JOB_ID(+) = A.JOB_ID
AND TRUNC(SYSDATE) BETWEEN P.EFFECTIVE_START_DATE
AND P.EFFECTIVE_END_DATE
AND ((TRUNC(SYSDATE) BETWEEN A.EFFECTIVE_START_DATE
AND A.EFFECTIVE_END_DATE))
AND P.TITLE = LOOK.LOOKUP_CODE(+)
AND LOOK.LOOKUP_TYPE(+) = 'TITLE'

Columns