[Home] [Help] [Dependency Information]
Object Name: | IGSFV_VISAS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGSFV_VISAS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This entity contains information about a person's visa details.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSON_NUMBER | VARCHAR2 | (30) | Yes | Unique identification number for a person |
VISA_TYPE | VARCHAR2 | (30) | Yes | Type of Visa the person holds. |
VISA_ISSUE_DATE | DATE | Yes | Date visa was issued | |
VISA_NUMBER | VARCHAR2 | (30) | Yes | Visa Number |
VISA_CATEGORY | VARCHAR2 | (30) | Category of a Visa Type | |
_LA:VISA_TYPE_DESCRIPTION | CHAR | (54) | Description of the Visa type | |
_LA:VISA_ISSUING_POST | CHAR | (72) | Post where the visa was issued. | |
_LA:VISA_ISSUING_COUNTRY | CHAR | (67) | Country Code where the visa was issued | |
VISA_EXPIRY_DATE | DATE | Yes | Date visa expires | |
AGENT_ORG_UNIT_CD | VARCHAR2 | (30) | Indicates the external agency (Org Unit Code) which the International Agent represents. | |
_DF | CHAR | (33) | Descriptive flex field | |
AGENT_ORG_UNIT_NAME | VARCHAR2 | (360) | Name of the external agency which the International Agent represents. | |
AGENT_PERSON_NUMBER | VARCHAR2 | (30) | Unique Identification Person Number of the International Agent. | |
AGENT_CONTACT_NAME | VARCHAR2 | (80) | International Agent's contact name | |
PASSPORT_NUMBER | VARCHAR2 | (30) | Passport number for the person which the visa is issued. | |
_LA:PASSPORT_COUNTRY | CHAR | (66) | Country where the passport is issued. | |
PERSON_ID | NUMBER | (15) | Yes | Unique Identifier of a person. |
VISA_ID | NUMBER | (15) | Yes | A unique identifier for the visa. |
AGENT_PERSON_ID | NUMBER | (15) | Person ID of the International Agent | |
PASSPORT_ID | NUMBER | (15) | Passport that is associated to the Visa | |
CREATION_DATE | DATE | Yes | Standard Who Column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_NUMBER
, VISA_TYPE
, VISA_ISSUE_DATE
, VISA_NUMBER
, VISA_CATEGORY
, _LA:VISA_TYPE_DESCRIPTION
, _LA:VISA_ISSUING_POST
, _LA:VISA_ISSUING_COUNTRY
, VISA_EXPIRY_DATE
, AGENT_ORG_UNIT_CD
, _DF
, AGENT_ORG_UNIT_NAME
, AGENT_PERSON_NUMBER
, AGENT_CONTACT_NAME
, PASSPORT_NUMBER
, _LA:PASSPORT_COUNTRY
, PERSON_ID
, VISA_ID
, AGENT_PERSON_ID
, PASSPORT_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGSFV_VISAS;
APPS.IGSFV_VISAS is not referenced by any database object
|
|
|