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.IGSBV_VISAS

Object Details

Object Name:	IGSBV_VISAS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGSBV_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)		Issuing post of the Visa
_LA:VISA_ISSUING_COUNTRY	CHAR	(67)		Country 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.
AGENT_CONTACT_NAME	VARCHAR2	(80)		International Agent's contact name
PERSON_ID	NUMBER	(15)	Yes	Unique Identifier of a person.
VISA_ID	NUMBER	(15)	Yes	A unique identifier for the person's visa.
PASSPORT_ID	NUMBER	(15)		Passport that is associated to the Visa
AGENT_PERSON_ID	NUMBER	(15)		Unique Person Identifier Of the International Agent .
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
,      AGENT_CONTACT_NAME
,      PERSON_ID
,      VISA_ID
,      PASSPORT_ID
,      AGENT_PERSON_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSBV_VISAS;

Dependencies

[top of page]

APPS.IGSBV_VISAS references the following:

APPS: HZ_PARTIES; IGS_PE_VISA

APPS.IGSBV_VISAS is not referenced by any database object