[Home] [Help]
VIEW: APPS.AMS_LT_HZ_CITIZENSHIP
Source
View Text - Preformatted
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'
View Text - HTML Formatted
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'