[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

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

HZ_PARTIES

HZ_PERSON_PROFILES

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