View: AMS_LT_HZ_CITIZENSHIP

Product:	AMS - Marketing
Description:	Data Source view based on hz_citizenship
Implementation/DBA Data:	APPS.AMS_LT_HZ_CITIZENSHIP

View Text

SELECT CITIZENSHIP_ID
, BIRTH_OR_SELECTED
, PARTY_ID
, COUNTRY_CODE
, DATE_DISOWNED
, DATE_RECOGNIZED
, DOCUMENT_REFERENCE
, END_DATE
, DOCUMENT_TYPE
FROM HZ_CITIZENSHIP
WHERE STATUS = 'A'

Columns