VIEW: APPS.IGR_I_APPL_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)