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


VIEW: APPS.IGS_AD_APPL_INST_MKDES_V

Object Details
Object Name: IGS_AD_APPL_INST_MKDES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_AD_APPL_INST_MKDES_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
Name Datatype Length Mandatory Comments
PERSON_ID NUMBER (15) Yes
NOMINATED_COURSE_CD VARCHAR2 (6) Yes
SEQUENCE_NUMBER NUMBER (6) Yes
ADMISSION_APPL_NUMBER NUMBER (2) Yes
ACAD_CAL_TYPE VARCHAR2 (10) Yes
ACAD_CI_SEQUENCE_NUMBER NUMBER (6) Yes
ADM_CAL_TYPE VARCHAR2 (10)
ADM_CI_SEQUENCE_NUMBER NUMBER

ACAD_ALTERNATE_CODE VARCHAR2 (10)
ADM_ALTERNATE_CODE VARCHAR2 (10)
ADMISSION_CAT VARCHAR2 (10) Yes
S_ADMISSION_PROCESS_TYPE VARCHAR2 (30) Yes
S_ADM_PRCS_TYPE_DESC VARCHAR2 (80)
ADM_APPL_STATUS VARCHAR2 (10) Yes
APPL_DT DATE
Yes
ADM_FEE_STATUS VARCHAR2 (10) Yes
ADM_DOC_STATUS VARCHAR2 (10) Yes
ACADEMIC_INDEX VARCHAR2 (10)
ADM_ENTRY_QUAL_STATUS VARCHAR2 (10) Yes
PREDICTED_GPA NUMBER (5)
CRV_VERSION_NUMBER NUMBER (3) Yes
COURSE_TITLE_DISPLAY VARCHAR2 (90)
LOCATION_CD VARCHAR2 (10)
ATTENDANCE_MODE VARCHAR2 (2)
ATTENDANCE_TYPE VARCHAR2 (2)
UNIT_SET_CD VARCHAR2 (10)
US_VERSION_NUMBER NUMBER (3)
EXPECTED_COMPLETION_YR NUMBER (4)
COURSE_RANK_SET VARCHAR2 (30)
COURSE_RANK_SCHEDULE VARCHAR2 (10)
ADMISSION_CD VARCHAR2 (10)
ADMISSION_CD_DESC VARCHAR2 (60)
BASIS_FOR_ADMISSION_TYPE VARCHAR2 (10)
BASIS_FOR_ADMISSION_TYPE_DESC VARCHAR2 (60)
Query Text

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


SELECT PERSON_ID
,      NOMINATED_COURSE_CD
,      SEQUENCE_NUMBER
,      ADMISSION_APPL_NUMBER
,      ACAD_CAL_TYPE
,      ACAD_CI_SEQUENCE_NUMBER
,      ADM_CAL_TYPE
,      ADM_CI_SEQUENCE_NUMBER
,      ACAD_ALTERNATE_CODE
,      ADM_ALTERNATE_CODE
,      ADMISSION_CAT
,      S_ADMISSION_PROCESS_TYPE
,      S_ADM_PRCS_TYPE_DESC
,      ADM_APPL_STATUS
,      APPL_DT
,      ADM_FEE_STATUS
,      ADM_DOC_STATUS
,      ACADEMIC_INDEX
,      ADM_ENTRY_QUAL_STATUS
,      PREDICTED_GPA
,      CRV_VERSION_NUMBER
,      COURSE_TITLE_DISPLAY
,      LOCATION_CD
,      ATTENDANCE_MODE
,      ATTENDANCE_TYPE
,      UNIT_SET_CD
,      US_VERSION_NUMBER
,      EXPECTED_COMPLETION_YR
,      COURSE_RANK_SET
,      COURSE_RANK_SCHEDULE
,      ADMISSION_CD
,      ADMISSION_CD_DESC
,      BASIS_FOR_ADMISSION_TYPE
,      BASIS_FOR_ADMISSION_TYPE_DESC
FROM APPS.IGS_AD_APPL_INST_MKDES_V;

Dependencies

[top of page]

APPS.IGS_AD_APPL_INST_MKDES_V references the following:

SchemaAPPS
ViewIGS_AD_APPL
SynonymIGS_AD_BASIS_FOR_AD
SynonymIGS_AD_CD
ViewIGS_AD_PS_APPL_INST_APLINST_V
ViewIGS_CA_INST_ADM_PERD_V
PL/SQL PackageIGS_GE_GEN_001 - show dependent code
ViewIGS_LOOKUP_VALUES

APPS.IGS_AD_APPL_INST_MKDES_V is not referenced by any database object