eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.IGSFV_VISAS

Object Details

Object Name:	IGSFV_VISAS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGSFV_VISAS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This entity contains information about a person's visa details.

[View Source]

Columns

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

Query Text

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;

Dependencies

[top of page]

APPS.IGSFV_VISAS references the following:

APPS: HZ_PARTIES; IGS_PE_PASSPORT; IGS_PE_VISA

APPS.IGSFV_VISAS is not referenced by any database object