Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This entity contains information about the citizenship countries. |
Implementation/DBA Data: | Not implemented in this database |
SELECT HZC.COUNTRY_CODE
, T.TERRITORY_SHORT_NAME
, HZC.DATE_DISOWNED
, HZC.DATE_RECOGNIZED
, HZC.BIRTH_OR_SELECTED
, HZC.DOCUMENT_REFERENCE
, HZC.END_DATE
, HZC.DOCUMENT_TYPE
, HZC.STATUS
, HZP.PARTY_NUMBER
, HZC.PARTY_ID
, HZC.CITIZENSHIP_ID
, HZC.CREATED_BY
, HZC.CREATION_DATE
, HZC.LAST_UPDATED_BY
, HZC.LAST_UPDATE_DATE
FROM HZ_CITIZENSHIP HZC
, HZ_PARTIES HZP
, FND_TERRITORIES_VL T
WHERE HZC.PARTY_ID=HZP.PARTY_ID
AND HZC.COUNTRY_CODE = T.TERRITORY_CODE WITH READ ONLY