[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
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 |
|
SECURITY_ALLOWED_IND |
VARCHAR2 |
(1) |
|
|
STEP_TYPE_RESTRICTION_NUM_IND |
VARCHAR2 |
(1) |
|
|
UNIT_OUTCOME_IND |
VARCHAR2 |
(1) |
|
|
DISPLAY_NAME |
VARCHAR2 |
(30) |
|
|
DISPLAY_ORDER |
NUMBER |
(22) |
|
|
STEP_ORDER_APPLICABLE_IND |
VARCHAR2 |
(1) |
|
|
ACADEMIC_TRANSCRIPT_IND |
VARCHAR2 |
(1) |
|
|
AV_TRANSCRIPT_DISP_OPTIONS |
VARCHAR2 |
(10) |
|
This will have value if the Academic_Transcript_ind is set to Yes and it will have value CPT, CPE, PUE for the respective options. |
CMPLTN_REQUIREMENTS_IND |
VARCHAR2 |
(1) |
|
|
FEE_ASS_IND |
VARCHAR2 |
(1) |
|
|
STEP_GROUP_TYPE |
VARCHAR2 |
(10) |
|
|
FINAL_RESULT_IND |
VARCHAR2 |
(1) |
|
|
S_TRACKING_TYPE |
VARCHAR2 |
(0) |
|
Obsolete |
SYSTEM_GENERATED_IND |
VARCHAR2 |
(1) |
|
|
TRANSACTION_CAT |
VARCHAR2 |
(10) |
|
|
OPEN_FOR_ENROLLMENTS |
VARCHAR2 |
(1) |
|
|
SYSTEM_CALCULATED |
VARCHAR2 |
(1) |
|
|
SYSTEM_MANDATORY_IND |
VARCHAR2 |
(1) |
|
Indicator to designate whether the region is mandatory in the self service form |
DEFAULT_DISPLAY_SEQ |
NUMBER |
(15) |
|
Default display sequence for attributes for a region |
CREATED_BY |
NUMBER |
(15) |
|
|
CREATION_DATE |
DATE |
|
|
|
LAST_UPDATED_BY |
NUMBER |
(15) |
|
|
LAST_UPDATE_DATE |
DATE |
|
|
|
LAST_UPDATE_LOGIN |
NUMBER |
(15) |
|
|
DESCRIPTION |
VARCHAR2 |
(240) |
|
|
START_DATE_ACTIVE |
DATE |
|
|
|
END_DATE_ACTIVE |
DATE |
|
|
|
ENCUMBRANCE_LEVEL |
NUMBER |
(1) |
|
|
TRACKING_USED_BY |
VARCHAR2 |
(0) |
|
Obsolete |
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.IGS_LOOKUPS_VIEW references the following:
-
APPS
-
FND_LOOKUP_VALUES
-
IGS_LOOKUPS_VAL
APPS.IGS_LOOKUPS_VIEW is referenced by following:
-
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