VIEW: APPS.JTM_PER_ALL_PEOPLE_F_V

Source

View Text - Preformatted

SELECT A.ACCESS_ID , B.PERSON_ID , B.EFFECTIVE_START_DATE , B.EFFECTIVE_END_DATE , B.LAST_NAME , B.START_DATE , B.DATE_OF_BIRTH , B.EMAIL_ADDRESS , B.EMPLOYEE_NUMBER , B.FIRST_NAME , B.FULL_NAME , B.MIDDLE_NAMES , B.NATIONALITY , B.SEX , B.TITLE , B.WORK_TELEPHONE , B.PARTY_ID FROM JTM_PER_ALL_PEOPLE_F_ACC A , PER_ALL_PEOPLE_F B WHERE A.PERSON_ID = B.PERSON_ID AND A.EFFECTIVE_START_DATE = B.EFFECTIVE_START_DATE AND A.EFFECTIVE_END_DATE = B.EFFECTIVE_END_DATE AND A.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID

View Text - HTML Formatted

SELECT A.ACCESS_ID
, B.PERSON_ID
, B.EFFECTIVE_START_DATE
, B.EFFECTIVE_END_DATE
, B.LAST_NAME
, B.START_DATE
, B.DATE_OF_BIRTH
, B.EMAIL_ADDRESS
, B.EMPLOYEE_NUMBER
, B.FIRST_NAME
, B.FULL_NAME
, B.MIDDLE_NAMES
, B.NATIONALITY
, B.SEX
, B.TITLE
, B.WORK_TELEPHONE
, B.PARTY_ID
FROM JTM_PER_ALL_PEOPLE_F_ACC A
, PER_ALL_PEOPLE_F B
WHERE A.PERSON_ID = B.PERSON_ID
AND A.EFFECTIVE_START_DATE = B.EFFECTIVE_START_DATE
AND A.EFFECTIVE_END_DATE = B.EFFECTIVE_END_DATE
AND A.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID