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


VIEW: APPS.IGS_PR_DISPLAY_V

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
PERSON_ID NUMBER (15) Yes
STAFF_MEMBER_IND VARCHAR2 (4000)
STUDENT_IND VARCHAR2 (1)
ENCUMBERED_IND VARCHAR2 (1)
DECEASED_IND VARCHAR2 (1)
SURNAME VARCHAR2 (150)
GIVEN_NAMES VARCHAR2 (150)
PREFERRED_GIVEN_NAME VARCHAR2 (240)
SEX VARCHAR2 (30)
TITLE VARCHAR2 (60)
BIRTH_DT DATE

SALUTATION VARCHAR2 (60)
ORACLE_USERNAME VARCHAR2 (100)
EMAIL_ADDR VARCHAR2 (2000)
ARCHIVE_EXCLUSION_IND VARCHAR2 (1)
ARCHIVE_DT DATE

PURGE_EXCLUSION_IND VARCHAR2 (1)
PURGE_DT DATE

FULL_NAME VARCHAR2 (301)
PREFERRED_NAME VARCHAR2 (391)
TITLE_NAME VARCHAR2 (362)
INITIAL_NAME VARCHAR2 (161)
INITIAL_LAST_NAME VARCHAR2 (162)
CONTEXT_BLOCK_NAME VARCHAR2 (455)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PERSON_ID
,      STAFF_MEMBER_IND
,      STUDENT_IND
,      ENCUMBERED_IND
,      DECEASED_IND
,      SURNAME
,      GIVEN_NAMES
,      PREFERRED_GIVEN_NAME
,      SEX
,      TITLE
,      BIRTH_DT
,      SALUTATION
,      ORACLE_USERNAME
,      EMAIL_ADDR
,      ARCHIVE_EXCLUSION_IND
,      ARCHIVE_DT
,      PURGE_EXCLUSION_IND
,      PURGE_DT
,      FULL_NAME
,      PREFERRED_NAME
,      TITLE_NAME
,      INITIAL_NAME
,      INITIAL_LAST_NAME
,      CONTEXT_BLOCK_NAME
FROM APPS.IGS_PR_DISPLAY_V;

Dependencies

[top of page]

APPS.IGS_PR_DISPLAY_V references the following:

SchemaAPPS
PL/SQL PackageIGS_EN_GEN_003 - show dependent code
PL/SQL PackageIGS_EN_GEN_007 - show dependent code
PL/SQL PackageIGS_GE_GEN_002 - show dependent code
ViewIGS_PE_PERSON

APPS.IGS_PR_DISPLAY_V is not referenced by any database object