[Home] [Help]
View: IGSFV_RESIDENCY_COUNTRIES
| Product: | IGS - Student System (Obsolete) |
|---|
| Description: | This entity contains information about the person's residency country. |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT HZP.PARTY_NUMBER
, PET.INFORMATION_TYPE
, PET.START_DATE
, PET.PEI_INFORMATION1
, PET.END_DATE
, L1.TERRITORY_SHORT_NAME
, PET.PE_EIT_ID
, PET.PERSON_ID
, PET.CREATED_BY
, PET.CREATION_DATE
, PET.LAST_UPDATED_BY
, PET.LAST_UPDATE_DATE
FROM IGS_PE_EIT PET
, HZ_PARTIES HZP
, FND_TERRITORIES_VL L1
WHERE HZP.PARTY_ID=PET.PERSON_ID
AND PET.INFORMATION_TYPE = 'PE_STAT_RES_COUNTRY'
AND PET.PEI_INFORMATION1 = L1.TERRITORY_CODE WITH READ ONLY
Columns
| Name |
| PERSON_NUMBER |
| INFORMATION_TYPE |
| START_DATE |
| COUNTRY_CODE |
| END_DATE |
| COUNTRY_NAME |
| PE_EIT_ID |
| PERSON_ID |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |