WIS_PARTY_PERSON_DETAILS_V

Details

• Schema: FUSION

• Object owner: WIS

• Object type: VIEW

Columns

Name
PERSON_ID PERSON_NUMBER OWNER_TABLE_ID

Query

SQL_Statement

SELECT PersonDetailsPEO.PERSON_ID, PersonDetailsPEO.PERSON_NUMBER, OriginalSystemReferencePEO.OWNER_TABLE_ID FROM PER_PERSONS PersonPEO, PER_ALL_PEOPLE_F PersonDetailsPEO, HZ_ORIG_SYS_REFERENCES OriginalSystemReferencePEO WHERE PersonPEO.PERSON_ID = PersonDetailsPEO.PERSON_ID AND OriginalSystemReferencePEO.ORIG_SYSTEM_REFERENCE = TO_CHAR(PersonDetailsPEO.PERSON_ID) AND ( TRUNC(SYSDATE) BETWEEN PersonDetailsPEO.EFFECTIVE_START_DATE AND PersonDetailsPEO.EFFECTIVE_END_DATE)