[Home] [Help]
View: AMS_PERSON_CITIZENSHIP_V
View Text
SELECT HC.CITIZENSHIP_ID
, HC.PARTY_ID
, HC.COUNTRY_CODE
, HC.BIRTH_OR_SELECTED
, HC.DATE_RECOGNIZED
, HC.END_DATE
, HC.DATE_DISOWNED
, HC.DOCUMENT_TYPE
, HC.DOCUMENT_REFERENCE
FROM HZ_CITIZENSHIP HC
, HZ_PARTIES HP
WHERE HC.PARTY_ID = HP.PARTY_ID
AND HP.STATUS = 'A'
AND HP.PARTY_TYPE = 'PERSON'
Columns
Name |
CITIZENSHIP_ID |
PARTY_ID |
COUNTRY_CODE |
BIRTH_OR_SELECTED |
DATE_RECOGNIZED |
END_DATE |
DATE_DISOWNED |
DOCUMENT_TYPE |
DOCUMENT_REFERENCE |