View: IGR_I_APPL_V

Product:	IGS - Student System
Description:	This view will be based on OMO public view AS_SALES_LEADS_V and IGR_I_APPL_ALL junction table.
Implementation/DBA Data:	APPS.IGR_I_APPL_V

View Text

SELECT EAP.ROW_ID ROW_ID
, EAP.SALES_LEAD_ID
, EAP.PERSON_ID
, PDV.PARTY_NUMBER PERSON_NUMBER
, EAP.ENQUIRY_APPL_NUMBER
, EAP.ACAD_CAL_TYPE
, EAP.ACAD_CI_SEQUENCE_NUMBER
, EAP.ADM_CAL_TYPE
, EAP.ADM_CI_SEQUENCE_NUMBER
, EAP.ENQUIRY_STATUS
, EAP.S_ENQUIRY_STATUS
, DECODE (EAP.ENQUIRY_STATUS
, NULL
, NULL
, (SELECT DESCRIPTION
FROM AS_STATUSES_VL
WHERE STATUS_CODE = EAP.S_ENQUIRY_STATUS)) MEANING
, EAP.ENABLED_FLAG
, EAP.DSP_DESCRIPTION
, EAP.INQUIRY_METHOD
, EAP.DSP_CLOSED_IND
, EAP.ENQUIRY_DT
, EAP.INQUIRY_METHOD_CODE
, EAP.INQ_ENTRY_LEVEL_ID
, IEL.INQ_ENTRY_LEVEL
, IEL.DESCRIPTION INQ_ENTRY_LEVEL_DESCRIPTION
, EAP.EDU_GOAL_ID
, CC1.NAME EDU_GOAL_NAME
, CC1.DESCRIPTION EDU_GOAL_DESCRIPTION
, NULL
, SATV.ORG_UNIT_CD
, SATV.DESCRIPTION ORG_UNIT_DESCRIPTION
, EAP.HOW_KNOWUS_ID
, CC2.NAME HOW_KNOWUS_NAME
, CC2.DESCRIPTION HOW_KNOWUS_DESC
, EAP.WHO_INFLUENCED_ID
, CC3.NAME WHO_INFLUENCED_NAME
, CC3.DESCRIPTION WHO_INFLUENCED_DESC
, EAP.REGISTERING_PERSON_ID
, NVL(PDV.KNOWN_AS
, SUBSTR (PDV.PERSON_FIRST_NAME
, 1
, DECODE(INSTR(PDV.PERSON_FIRST_NAME
, ' ')
, 0
, LENGTH(PDV.PERSON_FIRST_NAME)
, (INSTR(PDV.PERSON_FIRST_NAME
, ' ')-1)))) || ' ' || PDV.PERSON_LAST_NAME DSP_PREFERRED_NAME
, EAP.OVERRIDE_PROCESS_IND
, EAP.INDICATED_MAILING_DT
, EAP.LAST_PROCESS_DT
, EAP.COMMENTS
, EAP.REQUEST_ID
, EAP.PROGRAM_APPLICATION_ID
, EAP.PROGRAM_ID
, EAP.PROGRAM_UPDATE_DATE
, EAP.CREATED_BY
, EAP.CREATION_DATE
, EAP.LAST_UPDATED_BY
, EAP.LAST_UPDATE_DATE
, EAP.LAST_UPDATE_LOGIN
, PDV.KNOWN_AS PREFERRED_GIVEN_NAME
, EAP.ATTRIBUTE_CATEGORY
, EAP.ATTRIBUTE1
, EAP.ATTRIBUTE2
, EAP.ATTRIBUTE3
, EAP.ATTRIBUTE4
, EAP.ATTRIBUTE5
, EAP.ATTRIBUTE6
, EAP.ATTRIBUTE7
, EAP.ATTRIBUTE8
, EAP.ATTRIBUTE9
, EAP.ATTRIBUTE10
, EAP.ATTRIBUTE11
, EAP.ATTRIBUTE12
, EAP.ATTRIBUTE13
, EAP.ATTRIBUTE14
, EAP.ATTRIBUTE15
, EAP.ATTRIBUTE16
, EAP.ATTRIBUTE17
, EAP.ATTRIBUTE18
, EAP.ATTRIBUTE19
, EAP.ATTRIBUTE20
, DECODE (EAP.ADM_CAL_TYPE
, NULL
, NULL
, (SELECT ALTERNATE_CODE
FROM IGS_CA_INST
WHERE CAL_TYPE = EAP.ADM_CAL_TYPE
AND SEQUENCE_NUMBER = EAP.ADM_CI_SEQUENCE_NUMBER)) ADM_ALTERNATE_CODE
, SATV.SCHOOL_APPLYING_TO
, EAP.SOURCE_PROMOTION_ID SOURCE_PROMOTION_ID
, SC.SOURCE_CODE SOURCE_PROMOTION_CODE
, SC.NAME SOURCE_PROMOTION_NAME
, DECODE (SC.SOURCE_TYPE
, NULL
, NULL
, (SELECT MEANING
FROM AMS_LOOKUPS
WHERE SC.SOURCE_TYPE = LOOKUP_CODE
AND LOOKUP_TYPE = 'AMS_SYS_ARC_QUALIFIER')) SOURCE_PROMOTION_TYPE
, EAP.PARTY_ID SCH_APL_TO_ID
, EAP.PKG_REDUCT_IND
FROM IGR_I_APPL EAP
, IGS_AD_CODE_CLASSES CC1
, IGS_AD_CODE_CLASSES CC2
, IGS_AD_CODE_CLASSES CC3
, IGR_I_ENTRY_LVLS IEL
, HZ_PARTIES PDV
, IGS_AD_SCHL_APLY_TO SATV
, AMS_P_SOURCE_CODES_V SC
WHERE IEL.INQ_ENTRY_LEVEL_ID(+) = EAP.INQ_ENTRY_LEVEL_ID
AND CC1.CODE_ID (+) = EAP.EDU_GOAL_ID
AND CC2.CODE_ID(+) = EAP.HOW_KNOWUS_ID
AND CC3.CODE_ID(+) = EAP.WHO_INFLUENCED_ID
AND PDV.PARTY_ID(+) = EAP.REGISTERING_PERSON_ID
AND EAP.PARTY_ID = SATV.SCH_APL_TO_ID (+)
AND EAP.SOURCE_PROMOTION_ID = SC.SOURCE_CODE_ID (+)

Columns