WIS_PARTY_PERSON_DETAILS_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: WIS
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
PERSON_ID PERSON_NUMBER OWNER_TABLE_ID |
問合せ
| 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) |