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) |