[Home] [Help] [Dependency Information]
Object Name: | AMS_PERSON_CITIZENSHIP_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMS.AMS_PERSON_CITIZENSHIP_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CITIZENSHIP_ID | NUMBER | (15) | Yes | Citizenship identifier |
PARTY_ID | NUMBER | (15) | Yes | Unique identifier for a person(party). Foreign key to the HZ_PARTIES table. |
COUNTRY_CODE | VARCHAR2 | (2) | Yes | ISO code for the country from which a person claims citizenship. Foreign key to the FND_TERRITORIES table |
BIRTH_OR_SELECTED | VARCHAR2 | (30) | Indicates if the citizenship was granted by being born in the country or by naturalization. | |
DATE_RECOGNIZED | DATE | Date when the country granted citizenship to the individual. For a native-born person, this date is typically the person's date of birth. | ||
END_DATE | DATE | Date that the country recognizes as the end of citizenship. | ||
DATE_DISOWNED | DATE | Date when an individual renounced citizenship. Usually a self-declared date that might not match a legal effective date. | ||
DOCUMENT_TYPE | VARCHAR2 | (30) | The class of document that confirms citizenship. For example, a passport, or naturalization papers. | |
DOCUMENT_REFERENCE | VARCHAR2 | (60) | A number such as passport number or naturalization reference number associated with DOCUMENT_TYPE. |
Cut, paste (and edit) the following text to query this object:
SELECT CITIZENSHIP_ID
, PARTY_ID
, COUNTRY_CODE
, BIRTH_OR_SELECTED
, DATE_RECOGNIZED
, END_DATE
, DATE_DISOWNED
, DOCUMENT_TYPE
, DOCUMENT_REFERENCE
FROM APPS.AMS_PERSON_CITIZENSHIP_V;
APPS.AMS_PERSON_CITIZENSHIP_V is not referenced by any database object
|
|
|