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


VIEW: APPS.IGS_LOOKUP_VALUES

Object Details
Object Name: IGS_LOOKUP_VALUES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_LOOKUP_VALUES
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
LOOKUP_TYPE VARCHAR2 (30) Yes
LOOKUP_CODE VARCHAR2 (30) Yes
MEANING VARCHAR2 (80) Yes
CLOSED_IND VARCHAR2 (1)
ENABLED_FLAG VARCHAR2 (1) Yes
DESCRIPTION VARCHAR2 (240)
START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

TAG VARCHAR2 (150)
Tag
Query Text

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


SELECT LOOKUP_TYPE
,      LOOKUP_CODE
,      MEANING
,      CLOSED_IND
,      ENABLED_FLAG
,      DESCRIPTION
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      TAG
FROM APPS.IGS_LOOKUP_VALUES;

Dependencies

[top of page]

APPS.IGS_LOOKUP_VALUES references the following:

SchemaAPPS
SynonymFND_LOOKUP_VALUES
APPS.IGS_LOOKUP_VALUES is referenced by following:

SchemaAPPS
Package BodyIGF_AP_OSS_INTEGR - show dependent code
ViewIGF_AP_PERS_NOTE_V
Package BodyIGF_DB_SF_INTEGRATION - show dependent code
Package BodyIGF_SL_AWARD - show dependent code
Package BodyIGF_SL_CL_ORIG - show dependent code
Package BodyIGF_SL_GEN - show dependent code
ViewIGF_SL_PLUS_LOAN_DETAILS_V
Package BodyIGF_SP_ROLLOVER - show dependent code
Package BodyIGR_IMP_001 - show dependent code
Package BodyIGR_IMP_002 - show dependent code
ViewIGR_I_STATUS_V
ViewIGSBV_AD_ACT_STATS_SUBSCORE
ViewIGSBV_AD_ACT_STATS_TEST
ViewIGSFV_AD_ACT_STATS_SUBSCORE
ViewIGSFV_AD_ACT_STATS_TEST
Package BodyIGS_AD_ACT_ASSESSMENTS_PKG - show dependent code
Package BodyIGS_AD_ADM_REQ - show dependent code
ViewIGS_AD_APL_REV_PRF_V
ViewIGS_AD_APPL_ADMAPPL_V
ViewIGS_AD_APPL_INST_MKDES_V
ViewIGS_AD_APPL_PGMAPPRV_V
ViewIGS_AD_APPQUAL_CODE_V
Package BodyIGS_AD_CANCEL_RECONSIDER - show dependent code
ViewIGS_AD_CAT_ATTR_V
ViewIGS_AD_CODE_CLASSES_V
ViewIGS_AD_CRED_TYPES_V
ViewIGS_AD_CRT_APPL_CFG_V
ViewIGS_AD_EXTRACURR_ACT_V
Package BodyIGS_AD_GEN_002 - show dependent code
Package BodyIGS_AD_IMP_001 - show dependent code
Package BodyIGS_AD_IMP_013 - show dependent code
Package BodyIGS_AD_IMP_015 - show dependent code
Package BodyIGS_AD_IMP_026 - show dependent code
Package BodyIGS_AD_INT_RECONSIDER - show dependent code
ViewIGS_AD_PANEL_MEMBRS_V
ViewIGS_AD_PERD_PS_OF_PAT1_V
ViewIGS_AD_PNMEMBR_DTLS_V
ViewIGS_AD_PRCS_CAT_STEP_V
ViewIGS_AD_PROSPECT_V
ViewIGS_AD_PS_APL_INST_CNTX_V
ViewIGS_AD_PS_APPL_INST_APLINST_V
ViewIGS_AD_PS_APPL_INST_APLSUMR_V
Package BodyIGS_AD_PS_APPL_INST_PKG - show dependent code
ViewIGS_AD_QUAL_TYPE_V
ViewIGS_AD_RECRUITMENT_V
ViewIGS_AD_SBMAO_FN_AMTT_V
ViewIGS_AD_SBMAO_FN_CTTT_V
ViewIGS_AD_SBMAO_FN_UITT_V
ViewIGS_AD_SBM_AOU_FNDTT_V
Package BodyIGS_AD_SOURCE_CAT_PKG - show dependent code
ViewIGS_AD_SS_APPL_COMPS_V
ViewIGS_AD_SS_APPL_PGS_V
ViewIGS_AD_SS_APPL_TYP_V
Package BodyIGS_AD_SS_GEN_001 - show dependent code
ViewIGS_AD_SS_LOOKUPS_V
ViewIGS_AD_TEST_RESULTS_V
ViewIGS_AD_TEST_SCORES_V
Package BodyIGS_AD_VAL_AAS - show dependent code
Package BodyIGS_AD_VAL_ACAI_FTR_OFFER - show dependent code
Package BodyIGS_AD_VAL_ACOS - show dependent code
Package BodyIGS_AD_VAL_ADS - show dependent code
Package BodyIGS_AD_VAL_AEQS - show dependent code
Package BodyIGS_AD_VAL_AFS - show dependent code
Package BodyIGS_AD_VAL_AODS - show dependent code
Package BodyIGS_AD_VAL_AORS - show dependent code
Package BodyIGS_AD_VAL_ASES - show dependent code
Package BodyIGS_AD_VAL_AUOS - show dependent code
Package BodyIGS_AD_VAL_ITT - show dependent code
Package BodyIGS_AD_VAL_OSES - show dependent code
ViewIGS_AS_ALIAS_TYPES_V
ViewIGS_AS_DOC_FEE_PMNT_V
ViewIGS_AS_SLIST_ADI_V
ViewIGS_AS_SU_STMPTOUT
Package BodyIGS_AS_TRNCMT_LGCY_PUB - show dependent code
ViewIGS_AS_XSLISTCOM_ADI_V
ViewIGS_AS_XSLISTSEP_ADI_V
Package BodyIGS_AV_GEN_001 - show dependent code
Package BodyIGS_AV_VAL_AS - show dependent code
Package BodyIGS_AV_VAL_ASU - show dependent code
ViewIGS_AZ_GROUPS_V
ViewIGS_CA_DA_APPTY_OVRD_VAL_V
ViewIGS_CA_DA_CONFIGS_V
ViewIGS_CA_DA_ORG_OVD_VALS_V
ViewIGS_CA_DA_PRC_OVD_VALS_V
ViewIGS_CA_DA_PRT_OVD_VALS_V
ViewIGS_CA_DA_V
Package BodyIGS_CO_SUBMIT - show dependent code
ViewIGS_DA_CNFG_FTR_V
ViewIGS_DA_CNFG_REQ_TYP_V
ViewIGS_DA_CNFG_STAT_V
ViewIGS_DA_CNFG_V
ViewIGS_DA_REQ_FTRS_V
ViewIGS_DA_REQ_STDNTS_V
ViewIGS_EN_DL_OFFSET_CONS_V
Package BodyIGS_EN_ELGBL_OVERRIDE - show dependent code
Package BodyIGS_EN_GEN_011 - show dependent code
Package BodyIGS_EN_GEN_LEGACY - show dependent code
Package BodyIGS_EN_LGCY_PRC - show dependent code
ViewIGS_EN_SCA_V
ViewIGS_EN_SPI_RCONDS_V
Package BodyIGS_EN_SPI_RCOND_LGCY_PUB - show dependent code
ViewIGS_EN_SPL_PERM_H_V
ViewIGS_EN_SPL_PERM_V
Package BodyIGS_EN_STDNT_PS_INTM_PKG - show dependent code
ViewIGS_EN_SUA_RULCHK_V
ViewIGS_EN_SVS_AUTH_V
ViewIGS_EN_USEC_DISC_DL_V
Package BodyIGS_EN_WORKFLOW - show dependent code
Package BodyIGS_FI_1098T_EXTRACT_DATA - show dependent code
Package BodyIGS_FI_ACCT_STP_CNV - show dependent code
Package BodyIGS_FI_AD_HOC_WAV - show dependent code
ViewIGS_FI_BILL_DPSTS_V
Package BodyIGS_FI_BILL_EXTRACT - show dependent code
Package BodyIGS_FI_CHARGES_API_PVT - show dependent code
Package BodyIGS_FI_COM_REC_INTERFACE - show dependent code
ViewIGS_FI_CONTROL_V
Package BodyIGS_FI_CRDAPI_UTIL - show dependent code
ViewIGS_FI_CRDT_TRNSCTNS
ViewIGS_FI_CREDITS_V
ViewIGS_FI_CR_ACTIVITIES_V
Package BodyIGS_FI_DEPOSITS_PRCSS - show dependent code
ViewIGS_FI_ELM_RNG_ORDS_V
ViewIGS_FI_ELM_RNG_V
ViewIGS_FI_FEE_AS_RATE_V
ViewIGS_FI_FEE_TRG_GRP_V
Package BodyIGS_FI_FEE_TYPE_PKG - show dependent code
ViewIGS_FI_FEE_TYPE_V
ViewIGS_FI_FTCI_ACCTS_V
ViewIGS_FI_F_CAT_FEE_LBL_ALL_V
ViewIGS_FI_F_TYP_CA_INST_LKP_V
Package BodyIGS_FI_GEN_001 - show dependent code
Package BodyIGS_FI_GEN_005 - show dependent code
Package BodyIGS_FI_GEN_007 - show dependent code
PL/SQL PackageIGS_FI_GEN_GL - show dependent code
Package BodyIGS_FI_GEN_GL - show dependent code
Package BodyIGS_FI_GL_INTERFACE - show dependent code
ViewIGS_FI_GL_PERIODS_V
ViewIGS_FI_IMP_CHGS_V
ViewIGS_FI_INV_INT_V
ViewIGS_FI_LB_REC_TYPES_V
ViewIGS_FI_LOCKBOXES_V
Package BodyIGS_FI_PAYMENT_PLANS - show dependent code
Package BodyIGS_FI_POSTING_PROCESS - show dependent code
ViewIGS_FI_PP_INSTLMNTS_V
ViewIGS_FI_PP_STD_ATTRS_V
ViewIGS_FI_PP_TEMPLATES_V
Package BodyIGS_FI_PRC_ACCT_PKG - show dependent code
Package BodyIGS_FI_PRC_APINT - show dependent code
Package BodyIGS_FI_PRC_BALANCES - show dependent code
PL/SQL PackageIGS_FI_PRC_BALANCES - show dependent code
Package BodyIGS_FI_PRC_DISC_SUA - show dependent code
Package BodyIGS_FI_PRC_FEE_ASS - show dependent code
Package BodyIGS_FI_PRC_FEE_ROLLV - show dependent code
Package BodyIGS_FI_PRC_FIN_LT_CHG - show dependent code
Package BodyIGS_FI_PRC_HOLDS - show dependent code
PL/SQL PackageIGS_FI_PRC_LOCKBOX - show dependent code
Package BodyIGS_FI_PRC_LOCKBOX - show dependent code
Package BodyIGS_FI_PRC_STDNT_DPSTS - show dependent code
Package BodyIGS_FI_REFUNDS_PROCESS - show dependent code
ViewIGS_FI_REFUNDS_V
Package BodyIGS_FI_SS_ACCT_PAYMENT - show dependent code
ViewIGS_FI_SUB_ELM_RNG_V
Package BodyIGS_FI_UPG_RETENTION - show dependent code
Package BodyIGS_FI_WAV_UTILS_002 - show dependent code
PL/SQL PackageIGS_FI_WAV_UTILS_002 - show dependent code
ViewIGS_GE_CFG_NAV_V
Package BodyIGS_GE_GEN_004 - show dependent code
Package BodyIGS_HE_EXTRACT_FIELDS_PKG - show dependent code
Package BodyIGS_HE_SUSA_LGCY_PUB - show dependent code
ViewIGS_HE_UT_CALC_LVL_V
Package BodyIGS_OR_FUNC_FLTR_PKG - show dependent code
ViewIGS_OR_FUNC_FLTR_V
ViewIGS_OR_INSTITUTION
ViewIGS_OR_INSTITUTION_ADVSTEX_V
ViewIGS_OR_INSTITUTION_PRIORUG_V
ViewIGS_OR_INST_EXEMPT_V
ViewIGS_OR_INST_HIST_V
Package BodyIGS_OR_INST_IMP_001 - show dependent code
Package BodyIGS_OR_INST_IMP_003_PKG - show dependent code
ViewIGS_OR_INST_OUTER_V
ViewIGS_OR_INST_STATS_V
ViewIGS_OR_LOC_REGION_V
ViewIGS_OR_ORG_ACCR_DTLS_V
ViewIGS_OR_ORG_ALT_IDTYP_V
ViewIGS_OR_UNIT
ViewIGS_OR_UNIT_OUTER_V
ViewIGS_OR_UNIT_V
Package BodyIGS_OR_VAL_INS - show dependent code
Package BodyIGS_OR_VAL_OU - show dependent code
ViewIGS_PE_ACAD_HONORS_V
ViewIGS_PE_ACAD_INTENTS_V
ViewIGS_PE_ATHLETIC_DTL_V
ViewIGS_PE_ATHLETIC_PRG_V
ViewIGS_PE_COUNTRY_CD_V
ViewIGS_PE_COUNTRY_LOCATION_CD_V
ViewIGS_PE_CREDENTIALS_V
ViewIGS_PE_DEPD_ACTIVE_V
ViewIGS_PE_EIT_RESTATUS_V
ViewIGS_PE_EV_FORM_STAT_V
ViewIGS_PE_EV_FORM_V
Package BodyIGS_PE_FELONY_DTLS_PKG - show dependent code
Package BodyIGS_PE_GEN_001 - show dependent code
Package BodyIGS_PE_GEN_004 - show dependent code
ViewIGS_PE_HLTH_INS_V
ViewIGS_PE_HOLD_REL_OVR_V
ViewIGS_PE_IMMU_DTLS_V
ViewIGS_PE_INCOME_TAX_V
ViewIGS_PE_LANGUAGE_CD_V
ViewIGS_PE_MATCH_SET_DATA_V
ViewIGS_PE_MIL_SERVICE_V
ViewIGS_PE_NONIMG_EMPL_V
ViewIGS_PE_NONIMG_FORM_V
ViewIGS_PE_NONIMG_STAT_V
ViewIGS_PE_OFFICE_HRS_V
ViewIGS_PE_PERSON
ViewIGS_PE_PERSON_ALIAS_V
ViewIGS_PE_PERSON_ID_TYP_V
ViewIGS_PE_PERSON_SV
ViewIGS_PE_PERSON_V
ViewIGS_PE_PERS_DISABLTY_V
ViewIGS_PE_PERS_ENCUMB_V
Package BodyIGS_PE_PERS_IMP_001 - show dependent code
ViewIGS_PE_PERS_NOTE_V
ViewIGS_PE_PERS_PEN_ENCUMB_V
ViewIGS_PE_PRIV_LEVEL_V
ViewIGS_PE_RACE_V
ViewIGS_PE_RES_DTLS_V
ViewIGS_PE_SN_SERVICE_V
ViewIGS_PE_SP_SUBURB_PSTCD_THLOC_V
ViewIGS_PE_STAT_V
ViewIGS_PE_TEACH_PERIODS_V
ViewIGS_PE_TYP_EMP_CAT_V
Package BodyIGS_PE_TYP_INSTANCES_PKG - show dependent code
ViewIGS_PE_TYP_INSTANCES_V
Package BodyIGS_PE_USERID_PKG - show dependent code
ViewIGS_PE_USR_AVAL
ViewIGS_PE_VISA_V
ViewIGS_PE_VISIT_HISTRY_V
ViewIGS_PE_VOTE_INFO_V
Package BodyIGS_PE_WF_GEN - show dependent code
ViewIGS_PR_COHORT_INST_V
ViewIGS_PR_COHORT_V
ViewIGS_PR_UL_MARK_CNFG_V
ViewIGS_PR_UL_MARK_DTL_V
ViewIGS_PS_AWD_HNR_BASE_V
ViewIGS_PS_EMP_CATS_WL_OSS_V
ViewIGS_PS_FAC_WL_V
ViewIGS_PS_FLD_OF_STUDY
ViewIGS_PS_FLD_STDY_HIST
ViewIGS_PS_NSUS_RTN_V
ViewIGS_PS_OFR_OPT_V
ViewIGS_PS_TYPE_HIST_V
ViewIGS_PS_TYPE_V
Package BodyIGS_PS_UNIT_LGCY_PKG - show dependent code
Package BodyIGS_PS_UNIT_OFR_OPT_PKG - show dependent code
ViewIGS_PS_UNIT_OFR_OPT_V
ViewIGS_PS_UNIT_VER_V
ViewIGS_PS_USEC_OCCURS_FULL_V
ViewIGS_PS_USEC_OCCURS_V
Package BodyIGS_PS_USEC_SCHEDULE - show dependent code
ViewIGS_PS_USEC_WLST_PRI_V
Package BodyIGS_SS_ENROLL_PKG - show dependent code
Package BodyIGS_SS_ENR_DETAILS - show dependent code
ViewIGS_SS_EN_SUA_DTLS_V
Package BodyIGS_SV_BATCH_PROCESS_PKG - show dependent code
Package BodyIGS_SV_NI_BATCH_PROCESS_PKG - show dependent code
Package BodyIGS_SV_UTIL - show dependent code
ViewIGS_TR_STEP_CTLG
ViewIGS_TR_STP_CTL_TYPE_V
ViewIGS_TR_TYPE_V
Package BodyIGS_TR_VAL_TRST - show dependent code
ViewIGS_UC_MAP_OFF_RESP_V
Package BodyIGS_UC_MV_IMP_DEGSUBJ - show dependent code
Package BodyIGS_UC_MV_IMP_ERRCD - show dependent code
Package BodyIGS_UC_PROC_APPLICATION_DATA - show dependent code
Package BodyIGS_UC_PROC_REFERENCE_DATA - show dependent code
Package BodyIGS_UC_PROC_UCAS_DATA - show dependent code
ViewIGS_UC_QUAL_DETS_V
Package BodyIGS_UC_START_NEW_CYCLE - show dependent code
Package BodyIGS_UC_TRAN_PROCESSOR_PKG - show dependent code
PL/SQL PackageIGS_UC_TRAN_PROCESSOR_PKG - show dependent code
Package BodyIGS_UC_TRX_GEN_HOOK - show dependent code
ViewIGS_UC_UCAPCH_OSSAPPL_V