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


VIEW: APPS.IGS_AD_APPL

Object Details
Object Name: IGS_AD_APPL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_AD_APPL
Subobject Name:
Status: VALID

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ORG_ID NUMBER (15)
ACAD_CI_SEQUENCE_NUMBER NUMBER (6) Yes
ADM_CAL_TYPE VARCHAR2 (10) Yes
ADM_CI_SEQUENCE_NUMBER NUMBER (6) Yes
ADMISSION_CAT VARCHAR2 (10) Yes
S_ADMISSION_PROCESS_TYPE VARCHAR2 (30) Yes
ADM_APPL_STATUS VARCHAR2 (10) Yes
ADM_FEE_STATUS VARCHAR2 (10) Yes
TAC_APPL_IND VARCHAR2 (1) Yes
SPCL_GRP_1 NUMBER

SPCL_GRP_2 NUMBER

COMMON_APP VARCHAR2 (1)
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

APPL_DT DATE
Yes
ACAD_CAL_TYPE VARCHAR2 (10) Yes
PERSON_ID NUMBER (15) Yes
ADMISSION_APPL_NUMBER NUMBER (2) Yes
APPLICATION_TYPE VARCHAR2 (30)
CHOICE_NUMBER NUMBER (3)
Choice number
ROUTEB_PREF VARCHAR2 (30)
Route B preference
APPLICATION_ID NUMBER (15)
Application identifier.
ALT_APPL_ID VARCHAR2 (30)
APPL_FEE_AMT NUMBER

Application Fee Amount
Query Text

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


SELECT ROW_ID
,      ORG_ID
,      ACAD_CI_SEQUENCE_NUMBER
,      ADM_CAL_TYPE
,      ADM_CI_SEQUENCE_NUMBER
,      ADMISSION_CAT
,      S_ADMISSION_PROCESS_TYPE
,      ADM_APPL_STATUS
,      ADM_FEE_STATUS
,      TAC_APPL_IND
,      SPCL_GRP_1
,      SPCL_GRP_2
,      COMMON_APP
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      APPL_DT
,      ACAD_CAL_TYPE
,      PERSON_ID
,      ADMISSION_APPL_NUMBER
,      APPLICATION_TYPE
,      CHOICE_NUMBER
,      ROUTEB_PREF
,      APPLICATION_ID
,      ALT_APPL_ID
,      APPL_FEE_AMT
FROM APPS.IGS_AD_APPL;

Dependencies

[top of page]

APPS.IGS_AD_APPL references the following:

SchemaAPPS
SynonymIGS_AD_APPL_ALL
APPS.IGS_AD_APPL is referenced by following:

SchemaAPPS
Package BodyIGF_AP_GEN_001 - show dependent code
Package BodyIGF_AP_OSS_INTEGR - show dependent code
Package BodyIGF_AP_OSS_INTR_DTLS - show dependent code
PL/SQL PackageIGF_AP_OSS_INTR_DTLS - show dependent code
Package BodyIGS_ADMAPPLICATION_PUB - show dependent code
Package BodyIGS_AD_AC_COMP - show dependent code
Package BodyIGS_AD_ADM_REQ - show dependent code
ViewIGS_AD_APPL_ADMAPPL_V
ViewIGS_AD_APPL_HIST_APHSTRY_V
ViewIGS_AD_APPL_INST_MKDES_V
Package BodyIGS_AD_APPL_LTR_PKG - show dependent code
ViewIGS_AD_APPL_V
Package BodyIGS_AD_APP_REQ_PKG - show dependent code
Package BodyIGS_AD_CANCEL_RECONSIDER - show dependent code
PL/SQL PackageIGS_AD_DEF_APPL_PKG - show dependent code
Package BodyIGS_AD_DEF_APPL_PKG - show dependent code
Package BodyIGS_AD_GEN_001 - show dependent code
Package BodyIGS_AD_GEN_002 - show dependent code
Package BodyIGS_AD_GEN_004 - show dependent code
Package BodyIGS_AD_GEN_007 - show dependent code
Package BodyIGS_AD_GEN_008 - show dependent code
Package BodyIGS_AD_GEN_010 - show dependent code
Package BodyIGS_AD_GEN_011 - show dependent code
Package BodyIGS_AD_GEN_012 - show dependent code
Package BodyIGS_AD_GEN_014 - show dependent code
Package BodyIGS_AD_GEN_015 - show dependent code
Package BodyIGS_AD_IMP_004 - show dependent code
Package BodyIGS_AD_IMP_010 - show dependent code
Package BodyIGS_AD_IMP_027 - show dependent code
Package BodyIGS_AD_IMP_ADM_DES - show dependent code
PL/SQL PackageIGS_AD_IMP_ADM_DES - show dependent code
Package BodyIGS_AD_IMP_OFF_RESP_DATA - show dependent code
Package BodyIGS_AD_INS_ADMPERD - show dependent code
PL/SQL PackageIGS_AD_INT_RECONSIDER - show dependent code
Package BodyIGS_AD_INT_RECONSIDER - show dependent code
ViewIGS_AD_KEY_ACAD_IND_V
ViewIGS_AD_MKADM_DES_INT_V
Package BodyIGS_AD_OFFRESP_STATUS_WF - show dependent code
Package BodyIGS_AD_PANEL_DTLS_PKG - show dependent code
ViewIGS_AD_PANEL_DTLS_V
Package BodyIGS_AD_PNMEMBR_DTLS_PKG - show dependent code
Package BodyIGS_AD_PRC_TAC_OFFER - show dependent code
Package BodyIGS_AD_PS_APLINSTUNT_PKG - show dependent code
ViewIGS_AD_PS_APL_INST_CNTX_V
ViewIGS_AD_PS_APPL_INST_APLINST_V
ViewIGS_AD_PS_APPL_INST_APLSUMR_V
ViewIGS_AD_PS_APPL_INST_CONTEXT_V
Package BodyIGS_AD_PS_APPL_INST_PKG - show dependent code
Package BodyIGS_AD_PS_APPL_PKG - show dependent code
ViewIGS_AD_RESI_LETTER_V
Package BodyIGS_AD_SS_APPL_FEE_PKG - show dependent code
Package BodyIGS_AD_SS_GEN_001 - show dependent code
Package BodyIGS_AD_TI_COMP - show dependent code
Package BodyIGS_AD_UPD_INITIALISE - show dependent code
Package BodyIGS_AD_VAL_AA - show dependent code
Package BodyIGS_AD_VAL_ACA - show dependent code
Package BodyIGS_AD_VAL_ACAI - show dependent code
Package BodyIGS_AD_VAL_ACAIU - show dependent code
Package BodyIGS_AD_VAL_ACAI_FTR_OFFER - show dependent code
PL/SQL PackageIGS_AD_VAL_ACAI_FTR_OFFER - show dependent code
Package BodyIGS_AD_VAL_ACAI_STATUS - show dependent code
Package BodyIGS_AD_WF_001 - show dependent code
Package BodyIGS_AD_WRKFLOW_PKG - show dependent code
PL/SQL PackageIGS_AD_WRKFLOW_PKG - show dependent code
Package BodyIGS_CO_GEN_002 - show dependent code
Package BodyIGS_EN_GEN_002 - show dependent code
Package BodyIGS_EN_GEN_006 - show dependent code
Package BodyIGS_EN_GEN_008 - show dependent code
Package BodyIGS_EN_GEN_010 - show dependent code
Package BodyIGS_EN_VAL_SCA - show dependent code
Package BodyIGS_EN_VAL_SCT - show dependent code
Package BodyIGS_FI_CRDAPI_UTIL - show dependent code
Package BodyIGS_FI_CREDIT_PVT - show dependent code
Package BodyIGS_FI_GL_INTERFACE - show dependent code
Package BodyIGS_FI_POSTING_PROCESS - show dependent code
Package BodyIGS_FI_PRC_STDNT_DPSTS - show dependent code
Package BodyIGS_IN_GEN_001 - show dependent code
Package BodyIGS_PS_GEN_002 - show dependent code
Package BodyIGS_RE_GEN_001 - show dependent code
Package BodyIGS_RE_GEN_002 - show dependent code
Package BodyIGS_RE_VAL_CA - show dependent code
Package BodyIGS_UC_TRX_GEN_HOOK - show dependent code
PL/SQL PackageIGS_UC_TRX_GEN_HOOK - show dependent code