[Home] [Help]
[Dependency Information]
| Object Name: | IGS_PR_DISPLAY_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | IGS.IGS_PR_DISPLAY_V
|
| Subobject Name: | |
| Status: | VALID |
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.
| 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) |
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;
APPS
IGS_EN_GEN_003
- show dependent code
IGS_EN_GEN_007
- show dependent code
IGS_GE_GEN_002
- show dependent code
IGS_PE_PERSON
APPS.IGS_PR_DISPLAY_V is not referenced by any database object
|
|
|
|