[Home] [Help]
[Dependency Information]
VIEW: APPS.IGS_PE_PERSON_BASE_V
Object Details
Object Name: | IGS_PE_PERSON_BASE_V |
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_PE_PERSON_BASE_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 |
ROW_ID |
ROWID |
(10) |
|
|
PERSON_ID |
NUMBER |
(15) |
Yes |
|
PERSON_NUMBER |
VARCHAR2 |
(30) |
Yes |
|
PRE_NAME_ADJUNCT |
VARCHAR2 |
(30) |
|
Pre Name Adjunct |
FIRST_NAME |
VARCHAR2 |
(150) |
|
Given Name of the person |
MIDDLE_NAME |
VARCHAR2 |
(60) |
|
Middle Name of the person |
LAST_NAME |
VARCHAR2 |
(150) |
|
Surname of the Person |
TITLE |
VARCHAR2 |
(60) |
|
Title of the person |
FULL_NAME |
VARCHAR2 |
(450) |
|
|
SUFFIX |
VARCHAR2 |
(30) |
|
Suffix of the person |
BIRTH_DATE |
DATE |
|
|
|
GENDER |
VARCHAR2 |
(30) |
|
|
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 |
LAST_UPDATE_LOGIN |
NUMBER |
(15) |
|
Standard Who Column |
DATE_OF_DEATH |
DATE |
|
|
Date on which the Person expired. |
OBJECT_VERSION_NUMBER |
NUMBER |
|
|
HZ_PARTIES Object version number ,internally used for locking the record |
STATUS |
VARCHAR2 |
(1) |
Yes |
|
KNOWN_AS |
VARCHAR2 |
(240) |
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, PERSON_ID
, PERSON_NUMBER
, PRE_NAME_ADJUNCT
, FIRST_NAME
, MIDDLE_NAME
, LAST_NAME
, TITLE
, FULL_NAME
, SUFFIX
, BIRTH_DATE
, GENDER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, DATE_OF_DEATH
, OBJECT_VERSION_NUMBER
, STATUS
, KNOWN_AS
FROM APPS.IGS_PE_PERSON_BASE_V;
Dependencies
[top of page]
APPS.IGS_PE_PERSON_BASE_V references the following:
-
APPS
-
HZ_PARTIES
-
HZ_PERSON_PROFILES
APPS.IGS_PE_PERSON_BASE_V is referenced by following:
-
APPS
-
IGF_AP_GEN
- show dependent code
-
IGF_AP_GEN_001
- show dependent code
-
IGF_AP_TODO_GRPS_PRC_PKG
- show dependent code
-
IGF_AP_VER_GRPS_PRC_PKG
- show dependent code
-
IGF_AW_CANCEL_AWD
- show dependent code
-
IGF_AW_CANCEL_AWD
- show dependent code
-
IGF_AW_COA_CALC
- show dependent code
-
IGF_AW_COA_UPDATE
- show dependent code
-
IGF_AW_LOCK_ASSGN_PKG
- show dependent code
-
IGF_AW_MANAGE_AWD
- show dependent code
-
IGF_DB_DISB
- show dependent code
-
IGF_DB_SF_INTEGRATION
- show dependent code
-
IGF_GR_GEN
- show dependent code
-
IGF_GR_GEN_XML
- show dependent code
-
IGF_GR_VERIFY_PROCESS
- show dependent code
-
IGF_SE_GEN_001
- show dependent code
-
IGF_SL_CL_CHG_FILE
- show dependent code
-
IGF_SL_DL_GEN_XML
- show dependent code
-
IGF_SL_GEN
- show dependent code
-
IGF_SL_LAR_CREATION
- show dependent code
-
IGF_SL_LOANS_SUM_V
-
IGF_SL_PLUS_LOAN_DETAILS_V
-
IGF_SL_REL_DISB
- show dependent code
-
IGF_SP_ASSIGN_PUB
- show dependent code
-
IGF_SP_AWARD
- show dependent code
-
IGF_SP_CREATE_BASE_REC
- show dependent code
-
IGF_SP_STDNT_REL_V
-
IGR_IMP_003
- show dependent code
-
IGR_IN_JTF_INTERACTIONS_PKG
- show dependent code
-
IGR_IN_JTF_INTERACTIONS_PKG
- show dependent code
-
IGR_I_APPL_PKG
- show dependent code
-
IGSFV_HESA_EXT_RUN_DAT_LINES
-
IGS_AD_ACAD_HISTORY_PKG
- show dependent code
-
IGS_AD_APPL_EVAL_V
-
IGS_AD_APPL_HIST_APHSTRY_V
-
IGS_AD_APPL_PERSTAT_PKG
- show dependent code
-
IGS_AD_APPL_PGMAPPRV_V
-
IGS_AD_APPL_PKG
- show dependent code
-
IGS_AD_APPL_V
-
IGS_AD_DEF_APPL_PKG
- show dependent code
-
IGS_AD_DES_BATCH_DEF_DET_V
-
IGS_AD_GEN_002
- show dependent code
-
IGS_AD_GEN_007
- show dependent code
-
IGS_AD_IMP_002
- show dependent code
-
IGS_AD_IMP_002
- show dependent code
-
IGS_AD_IMP_006
- show dependent code
-
IGS_AD_IMP_007
- show dependent code
-
IGS_AD_IMP_008
- show dependent code
-
IGS_AD_IMP_011
- show dependent code
-
IGS_AD_IMP_012
- show dependent code
-
IGS_AD_IMP_013
- show dependent code
-
IGS_AD_IMP_026
- show dependent code
-
IGS_AD_IMP_ADM_DES
- show dependent code
-
IGS_AD_IMP_PAR_MATCHES_V
-
IGS_AD_INT_RECONSIDER
- show dependent code
-
IGS_AD_INT_RECONSIDER
- show dependent code
-
IGS_AD_LOCATION_V
-
IGS_AD_MKADM_DES_INT_V
-
IGS_AD_OFFRESP_STATUS_WF
- show dependent code
-
IGS_AD_PANEL_DTLS_V
-
IGS_AD_PANEL_MEMBRS_V
-
IGS_AD_PNMEMBR_DTLS_V
-
IGS_AD_PROSPECT_V
-
IGS_AD_PS_APLINSTUNT_V
-
IGS_AD_PS_APPL_INST_CONTEXT_V
-
IGS_AD_STDNT_PS_ATT_V
-
IGS_AD_TEST_RESULTS_PKG
- show dependent code
-
IGS_AD_VAL_AA
- show dependent code
-
IGS_AD_VAL_ACAI
- show dependent code
-
IGS_AD_VAL_ACAI_FTR_OFFER
- show dependent code
-
IGS_AD_VAL_PE
- show dependent code
-
IGS_AD_WF_001
- show dependent code
-
IGS_AS_DUP_DOCS_V
-
IGS_AS_SUAAI_HIST_V
-
IGS_AS_SU_STMPTOUT_V
-
IGS_AV_STND_UNIT_DTL_V
-
IGS_AV_STND_UNIT_LVL_V
-
IGS_CO_PROCESS
- show dependent code
-
IGS_CO_SUBMIT
- show dependent code
-
IGS_CO_VAL_OC
- show dependent code
-
IGS_CO_VAL_SCOTR
- show dependent code
-
IGS_DA_PURGE_RQST_PKG
- show dependent code
-
IGS_EN_GEN_006
- show dependent code
-
IGS_EN_GEN_016
- show dependent code
-
IGS_EN_GEN_017
- show dependent code
-
IGS_EN_IVR_PUB
- show dependent code
-
IGS_EN_STDNT_PS_ATT_V
-
IGS_EN_SUA_RULCHK_V
-
IGS_EN_SUA_WLST_V
-
IGS_EN_TIMESLOTS
- show dependent code
-
IGS_EN_TIMESLOT_RSLT_V
-
IGS_EN_VAL_PAL
- show dependent code
-
IGS_EN_VAL_SCA
- show dependent code
-
IGS_EN_WORKFLOW
- show dependent code
-
IGS_FI_1098T_EXTRACT_DATA
- show dependent code
-
IGS_FI_PRC_DISC_SUA
- show dependent code
-
IGS_FI_PRC_HOLDS
- show dependent code
-
IGS_FI_PRC_IMPCLC_ANC_CHGS
- show dependent code
-
IGS_FI_PRC_SP_FEES
- show dependent code
-
IGS_FI_PRC_WAIVERS
- show dependent code
-
IGS_FI_WAV_DTLS_WF
- show dependent code
-
IGS_FI_WAV_UTILS_001
- show dependent code
-
IGS_FI_WAV_UTILS_001
- show dependent code
-
IGS_GE_GEN_001
- show dependent code
-
IGS_GE_GEN_002
- show dependent code
-
IGS_GE_GEN_003
- show dependent code
-
IGS_GR_GEN_001
- show dependent code
-
IGS_GR_GEN_002
- show dependent code
-
IGS_GR_PRC_GAC
- show dependent code
-
IGS_GR_VAL_GR
- show dependent code
-
IGS_HE_EXTRACT2_PKG
- show dependent code
-
IGS_HE_IDENTIFY_TARGET_POP
- show dependent code
-
IGS_HE_IMPORT_DATA
- show dependent code
-
IGS_HE_UCAS_TARIFF_PKG
- show dependent code
-
IGS_OR_CONTACTS_V
-
IGS_OR_INST_IMP_003_PKG
- show dependent code
-
IGS_PE_ALT_PERS_ID_PKG
- show dependent code
-
IGS_PE_CITIZENSHIPS_PKG
- show dependent code
-
IGS_PE_CREDENTIALS_V
-
IGS_PE_DUP_PERSON_V
-
IGS_PE_DYNAMIC_PERSID_GROUP
- show dependent code
-
IGS_PE_EIT_PKG
- show dependent code
-
IGS_PE_FELONY_DTLS_PKG
- show dependent code
-
IGS_PE_GEN_001
- show dependent code
-
IGS_PE_GEN_002
- show dependent code
-
IGS_PE_GEN_004
- show dependent code
-
IGS_PE_HEARING_DTLS_PKG
- show dependent code
-
IGS_PE_HLTH_INS_PKG
- show dependent code
-
IGS_PE_HZ_CONT_PREF_PKG
- show dependent code
-
IGS_PE_HZ_PTY_SITES_PKG
- show dependent code
-
IGS_PE_IDENTIFY_DUPS
- show dependent code
-
IGS_PE_IMMU_DTLS_PKG
- show dependent code
-
IGS_PE_INTL_DEPD_V
-
IGS_PE_MIL_SERVICES_PKG
- show dependent code
-
IGS_PE_PASSPORT_PKG
- show dependent code
-
IGS_PE_PERSID_GROUP
-
IGS_PE_PERSID_GROUP_V
-
IGS_PE_PERSON_ALIAS_PKG
- show dependent code
-
IGS_PE_PERSON_DTLS_V
-
IGS_PE_PERSON_SS_PKG
- show dependent code
-
IGS_PE_PERS_DISABLTY_PKG
- show dependent code
-
IGS_PE_PERS_DISABLTY_V
-
IGS_PE_PERS_ENCUMB_V
-
IGS_PE_PERS_PEN_ENCUMB_V
-
IGS_PE_PRIV_LEVEL_V
-
IGS_PE_PRSID_GRP_MEM_V
-
IGS_PE_RELATIONSHIPS_PKG
- show dependent code
-
IGS_PE_RES_DTLS_V
-
IGS_PE_STATIC_PIG_MEM_V
-
IGS_PE_STAT_V
-
IGS_PE_USERID_PKG
- show dependent code
-
IGS_PE_VISA_PKG
- show dependent code
-
IGS_PE_VISA_V
-
IGS_PE_WF_GEN
- show dependent code
-
IGS_PR_COHINST_RANK_PKG
- show dependent code
-
IGS_PS_FAC_CAL_INST_V
-
IGS_PS_FAC_CREDT_WRKLOAD
- show dependent code
-
IGS_PS_FAC_WL_V
-
IGS_PS_GENERIC_PUB
- show dependent code
-
IGS_PS_UNIT_LGCY_PKG
- show dependent code
-
IGS_PS_USEC_SCHEDULE
- show dependent code
-
IGS_RE_CANDIDATURE_V
-
IGS_RE_SPRVSR_LGCY_PUB
- show dependent code
-
IGS_RE_WORKFLOW
- show dependent code
-
IGS_SS_ENR_DETAILS
- show dependent code
-
IGS_SV_NI_BATCH_PROCESS_PKG
- show dependent code
-
IGS_TR_GEN_002
- show dependent code
-
IGS_TR_ITEM_V
-
IGS_TR_STEP_V
-
IGS_TR_TYPE_STEP_V
-
IGS_UC_APP_CHOICE_DETS_V
-
IGS_UC_EXPORT_HESA_TO_OSS_PKG
- show dependent code
-
IGS_UC_EXPUNGE_APP
- show dependent code
-
IGS_UC_EXP_APPLICANT_DTLS
- show dependent code
-
IGS_UC_PROC_APPLICATION_DATA
- show dependent code
-
IGS_UC_QUAL_DETS_IMP_PKG
- show dependent code