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

VIEW: APPS.IGSBV_PERSON_ALIASES

Object Details
Object Name: IGSBV_PERSON_ALIASES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGSBV_PERSON_ALIASES
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


This entity contains aliases or other names by which a person may be known.


[View Source]

Columns
Name Datatype Length Mandatory Comments
_LA:ALIAS_TYPE CHAR (58)
Type of alias or name.
START_DATE DATE

Indicates the start date which the person alias/name is valid.
END_DATE DATE

Indicates the end date which the person alias/name is no longer valid.
SURNAME VARCHAR2 (150)
Former Surname/Last name of the person
GIVEN_NAME VARCHAR2 (150)
Former Given name/First Name of the person
TITLE VARCHAR2 (60)
Former Title of the person
ALIAS_COMMENT VARCHAR2 (60)
Comments for the Alias
SEQUENCE_NUMBER NUMBER (6) Yes Uniquely identifies a person alias
PERSON_ID NUMBER (15) Yes Unique identifier of a person
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
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 _LA:ALIAS_TYPE
,      START_DATE
,      END_DATE
,      SURNAME
,      GIVEN_NAME
,      TITLE
,      ALIAS_COMMENT
,      SEQUENCE_NUMBER
,      PERSON_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSBV_PERSON_ALIASES;

Dependencies

[top of page]

APPS.IGSBV_PERSON_ALIASES references the following:

SchemaAPPS
SynonymIGS_PE_PERSON_ALIAS

APPS.IGSBV_PERSON_ALIASES is not referenced by any database object