[Home] [Help] [Dependency Information]

VIEW: APPS.IGS_LOOKUPS_VIEW

Object Details

Object Name:	IGS_LOOKUPS_VIEW
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_LOOKUPS_VIEW
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 LOOKUP_TYPE
,      LOOKUP_CODE
,      MEANING
,      CLOSED_IND
,      ENABLED_FLAG
,      SECURITY_ALLOWED_IND
,      STEP_TYPE_RESTRICTION_NUM_IND
,      UNIT_OUTCOME_IND
,      DISPLAY_NAME
,      DISPLAY_ORDER
,      STEP_ORDER_APPLICABLE_IND
,      ACADEMIC_TRANSCRIPT_IND
,      AV_TRANSCRIPT_DISP_OPTIONS
,      CMPLTN_REQUIREMENTS_IND
,      FEE_ASS_IND
,      STEP_GROUP_TYPE
,      FINAL_RESULT_IND
,      S_TRACKING_TYPE
,      SYSTEM_GENERATED_IND
,      TRANSACTION_CAT
,      OPEN_FOR_ENROLLMENTS
,      SYSTEM_CALCULATED
,      SYSTEM_MANDATORY_IND
,      DEFAULT_DISPLAY_SEQ
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      DESCRIPTION
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      ENCUMBRANCE_LEVEL
,      TRACKING_USED_BY
FROM APPS.IGS_LOOKUPS_VIEW;

Dependencies

[top of page]

APPS

FND_LOOKUP_VALUES

IGS_LOOKUPS_VAL

APPS

IGF_AP_HOUSING_MAP_V

IGF_AP_IA_LOOKUP_V

IGF_AP_OSS_INTEGR - show dependent code

IGF_AP_OSS_INTEGR - show dependent code

IGF_AW_ANTICIPATED_DATA - show dependent code

IGF_AW_FISAP_PKG - show dependent code

IGF_AW_FUND_FEECLAS_V

IGF_AW_GEN - show dependent code

IGF_AW_LI_IMPORT - show dependent code

IGF_DB_DL_DISB_ORIG - show dependent code

IGF_DB_SF_INTEGRATION - show dependent code

IGF_SL_DL_CHG_ORIG - show dependent code

IGF_SL_DL_ORIG - show dependent code

IGF_SL_GEN - show dependent code

IGF_SL_GEN - show dependent code

IGF_SL_LOR_DTLS_V

IGF_SL_PE_CITI_MAP_V

IGF_SP_AWARD - show dependent code

IGF_SP_FC_V

IGF_SP_STD_FC_V

IGR_AD_VAL_ES - show dependent code

IGR_IMP_003 - show dependent code

IGR_IMP_004 - show dependent code

IGS_AD_ADM_UNIT_STAT_V

IGS_AD_ADM_UT_STA_GD_V

IGS_AD_ADM_UT_STT_LD_V

IGS_AD_APCTR_RU_V

IGS_AD_APLINS_ADMREQ_APLPRC_V

IGS_AD_APPL_STAT_V

IGS_AD_AUS_SEC_ED_SC_V

IGS_AD_CNDNL_OFRSTAT_V

IGS_AD_DOC_STAT_V

IGS_AD_DSCP_ATTR_V

IGS_AD_ENT_QF_STAT_V

IGS_AD_FEE_STAT_V

IGS_AD_GEN_011 - show dependent code

IGS_AD_GEN_015 - show dependent code

IGS_AD_IMP_OFF_RESP_DATA - show dependent code

IGS_AD_INQ_ENTRY_STAT_V

IGS_AD_INTAK_TRG_TYP_V

IGS_AD_I_ENTRY_STATS_V

IGS_AD_LOCATION_TYPE_V

IGS_AD_MISSING_ITEMS_LETTER_V

IGS_AD_OFRDFRMT_STAT_V

IGS_AD_OFR_RESP_STAT_V

IGS_AD_OU_STAT_V

IGS_AD_PANEL_DTLS_PKG - show dependent code

IGS_AD_PNMEMBR_DTLS_PKG - show dependent code

IGS_AD_POSTADM_MISS_ITM_LTR_V

IGS_AD_PRCS_CAT_AC_V

IGS_AD_PRCS_CAT_ADMPRCS_V

IGS_AD_PRCS_CAT_STEP_V

IGS_AD_PRCS_CAT_V

IGS_AD_PRD_AD_PRC_CA_V

IGS_AD_ROOM_V

IGS_AD_SBMINTAK_TRGT_V

IGS_AD_SBMPS_FN_ITTT_V

IGS_AD_SOURCE_CAT_V

IGS_AD_SS_APPL_UPD_PAGE - show dependent code

IGS_AD_SS_PRC_CAT_V

IGS_AD_TER_ED_UNI_AT_V

IGS_AD_TEST_TYPES_V

IGS_AD_TRANSCRIPT_V

IGS_AD_UNIT_OU_STAT_V

IGS_AD_VAL_ACAI_STATUS - show dependent code

IGS_AD_VAL_APCS - show dependent code

IGS_AD_VAL_AUOS - show dependent code

IGS_AD_VAL_ITT - show dependent code

IGS_AS_DOCUMENTS_API - show dependent code

IGS_AS_DOC_DETAILS_PKG - show dependent code

IGS_AS_GEN_006 - show dependent code

IGS_AS_GPC_ACA_STNDG_V

IGS_AS_GPC_PE_ID_GRP_V

IGS_AS_GPC_PROGRAMS_V

IGS_AS_GPC_UNIT_SETS_V

IGS_AS_GRD_SCHEMA_V

IGS_AS_GRD_SCH_GRADE_V

IGS_AS_ORDER_PAYMENT_INFO_V

IGS_AS_RESULT_TYPE_OSES_V

IGS_AS_SERVIC_PLAN_V

IGS_AS_SRESTYPE_V

IGS_AS_SS_DOC_REQUEST - show dependent code

IGS_AS_SUAH_LOAD_V

IGS_AS_SUA_LOAD_V

IGS_AS_SU_ATTEMPT_LKUP_V

IGS_AS_VAL_NESO - show dependent code

IGS_AS_VAL_SUAO - show dependent code

IGS_AV_ACAD_HISTORY_V

IGS_AV_GEN_001 - show dependent code

IGS_AV_VAL_ASU - show dependent code

IGS_CA_DA_INST_OFCNT_V

IGS_CA_DA_OFFCNT_V

IGS_CA_STAT_LKUP_V

IGS_CA_TYPE_V

IGS_CA_VAL_DAIOC - show dependent code

IGS_CO_GEN_003 - show dependent code

IGS_CO_PROCESS - show dependent code

IGS_CO_SUBMIT - show dependent code

IGS_CO_S_LTR_V

IGS_CO_VAL_SLET - show dependent code

IGS_DA_CNFG_SRT_ORD_V

IGS_DA_EXPL_PRG_CAT_V

IGS_DA_FTR_VAL_V

IGS_DA_RQST_V

IGS_EN_CAT_PRC_DTL_V

IGS_EN_CAT_PRC_STEP_LKUP_V

IGS_EN_CPD_EXT_V

IGS_EN_DCNT_REASONCD_V

IGS_EN_DISC_DL_CONS_V

IGS_EN_ELGBL_OVERRIDE - show dependent code

IGS_EN_ELGBL_PERSON - show dependent code

IGS_EN_ELGBL_PROGRAM - show dependent code

IGS_EN_ELGBL_UNIT - show dependent code

IGS_EN_ELGB_OVR_STEP_V

IGS_EN_ELGB_OVR_SYS_STEP_V

IGS_EN_ENCMB_EFCTTYP_V

IGS_EN_GEN_001 - show dependent code

IGS_EN_GEN_003 - show dependent code

IGS_EN_GEN_006 - show dependent code

IGS_EN_GEN_012 - show dependent code

IGS_EN_GEN_013 - show dependent code

IGS_EN_GEN_015 - show dependent code

IGS_EN_NOTE_TYPE_V

IGS_EN_NSD_DLSTP

IGS_EN_NSTD_USEC_DL_V

IGS_EN_NSU_DLSTP

IGS_EN_OR_UNIT_WLST_PRI_V

IGS_EN_PIG_S_SETUP_V

IGS_EN_SEVIS - show dependent code

IGS_EN_SEVIS_AUTH_V

IGS_EN_STDNT_PS_ATT_CRV_V

IGS_EN_STDNT_PS_ATT_V

IGS_EN_SUA_YEAR_V

IGS_EN_SUSA_YEAR_V

IGS_EN_TIMESLOT_PARA_V

IGS_EN_TIMESLOT_PREF_V

IGS_EN_TIMESLOT_PRTY_V

IGS_EN_TIMESLOT_REVW_V

IGS_EN_TIMESLOT_STUP_V

IGS_EN_USEC_STAT_DSP_V

IGS_EN_VAL_DR - show dependent code

IGS_EN_VAL_ECPS - show dependent code

IGS_EN_VAL_SCT - show dependent code

IGS_EN_VAL_SUA - show dependent code

IGS_FI_ADL_APP_RUL_V

IGS_FI_AD_HOC_WAV - show dependent code

IGS_FI_AD_HOC_WAV - show dependent code

IGS_FI_APP_RULES_V

IGS_FI_BALANCE_RULES_V

IGS_FI_CNG_FCAT_LBL_SCA_PR_V

IGS_FI_CR_TYPES_V

IGS_FI_FEE_ASS_DEBT_V

IGS_FI_FIN_LT_PLAN_V

IGS_FI_F_CAT_FEE_LBL_SCA_PRR_V

IGS_FI_F_CAT_FEE_LBL_SCA_V

IGS_FI_GEN_001 - show dependent code

IGS_FI_GEN_005 - show dependent code

IGS_FI_GEN_REFUNDS - show dependent code

IGS_FI_GEN_REFUNDS - show dependent code

IGS_FI_GOV_HEC_PA_OP_V

IGS_FI_HIER_ACCT_TBL_V

IGS_FI_INV_WAV_DET_V

IGS_FI_POSTING_PROCESS - show dependent code

IGS_FI_PRC_ACCT_PKG - show dependent code

IGS_FI_PRC_BALANCES - show dependent code

IGS_FI_PRC_BALANCES - show dependent code

IGS_FI_PRC_DISC_SUA - show dependent code

IGS_FI_PRC_FEE_ASS - show dependent code

IGS_FI_PRC_FEE_ASS - show dependent code

IGS_FI_PRC_REFUNDS - show dependent code

IGS_FI_PRC_SP_FEES - show dependent code

IGS_FI_REFUNDS_PROCESS - show dependent code

IGS_FI_REFUNDS_PROCESS - show dependent code

IGS_FI_SS_ACCT_PAYMENT - show dependent code

IGS_FI_VAL_CFAR - show dependent code

IGS_FI_VAL_FAS - show dependent code

IGS_GE_REF_CD_TYPE_V

IGS_HE_EN_SUSA_V

IGS_HE_IMPORT_DATA - show dependent code

IGS_HE_POOUS_DTLS_V

IGS_HE_ST_PRG_DTLS_V

IGS_HE_ST_SPA_DTLS_V

IGS_IN_ENQUIRY_APPL_V

IGS_IN_ENQ_STATUS_V

IGS_IN_LVLTYP_PKG_IT_V

IGS_LOOKUPS_VIEW_PKG - show dependent code

IGS_OR_INST_IMP_001 - show dependent code

IGS_OR_ORG_INST_TYPE_V

IGS_PE_CODE_CLASSES_V

IGS_PE_DATA_ELEMENTS_V

IGS_PE_FAMILY_DTLS_V

IGS_PE_FUND_SOURCE_V

IGS_PE_MATCH_SETS_PKG - show dependent code

IGS_PE_PERSON_TYPES_V

IGS_PE_SET_REM_HOLDS - show dependent code

IGS_PE_SRC_TYPES_V

IGS_PE_STAT_V

IGS_PE_TYP_INSTANCES_PKG - show dependent code

IGS_PE_TYP_RSP_DFLT_V

IGS_PE_USR_AVAL_V

IGS_PR_COHINST_RANK_PKG - show dependent code

IGS_PR_CS_SCHDL_V

IGS_PR_MS_STAT_V

IGS_PR_OU_TYPE_V

IGS_PR_STA_TYPE_ELE_V

IGS_PR_VAL_POT - show dependent code

IGS_PS_EXP_WL_V

IGS_PS_GEN_007 - show dependent code

IGS_PS_GRP_TYPE_V

IGS_PS_RSV_OGPRI_V

IGS_PS_RSV_UOP_PRI_V

IGS_PS_RSV_USEC_PRI_V

IGS_PS_UOFR_WLST_PRI_V

IGS_PS_VALIDATE_LGCY_PKG - show dependent code

IGS_PS_VAL_CGT - show dependent code

IGS_PS_VAL_RCT - show dependent code

IGS_PS_VAL_UV - show dependent code

IGS_RE_THESIS_RESULT_V

IGS_RE_VAL_THE - show dependent code

IGS_RE_WORKFLOW - show dependent code

IGS_SS_ADMAPPL_SETUP_V

IGS_SS_ENR_DETAILS - show dependent code

IGS_SS_ENR_DETAILS - show dependent code

IGS_SS_EN_POST_ADREQ_V

IGS_SS_EN_WRAPPERS - show dependent code

IGS_TR_STEP_V

IGS_TR_TYPE_STEP_V

IGS_UC_ADM_SYSTEMS_V

IGS_UC_MAP_OUT_STAT_V