VIEW: APPS.IGSFV_ADM_PRG_APPL_UNIT

Source

View Text - Preformatted

SELECT paa.PERSON_ID, p.PARTY_NUMBER, pp.PERSON_NAME, paa.ADMISSION_APPL_NUMBER, paa.NOMINATED_COURSE_CD, psv.TITLE, paa.ACAI_SEQUENCE_NUMBER, paa.UNIT_CD, psu.TITLE, paa.UV_VERSION_NUMBER, ci.description, paa.CAL_TYPE, paa.CI_SEQUENCE_NUMBER, paa.LOCATION_CD, l.DESCRIPTION, paa.UNIT_CLASS, asu.DESCRIPTION, paa.UNIT_MODE, asm.DESCRIPTION, paa.ADM_UNIT_OUTCOME_STATUS, ous.DESCRIPTION, paa.ASS_TRACKING_ID, tr.TRACKING_STATUS, tr.TRACKING_TYPE, paa.RULE_WAIVED_DT, paa.RULE_WAIVED_PERSON_ID, p1.PARTY_NUMBER, pp1.PERSON_NAME, paa.SUP_UNIT_CD, psu1.TITLE, paa.SUP_UV_VERSION_NUMBER, paa.CREATED_BY, paa.CREATION_DATE, paa.LAST_UPDATED_BY, paa.LAST_UPDATE_DATE FROM IGS_AD_PS_APLINSTUNT_ALL paa, IGS_AD_UNIT_OU_STAT ous, IGS_PS_VER_ALL psv, IGS_AD_PS_APPL_INST_ALL inst, IGS_CA_INST_ALL ci, HZ_PARTIES p, HZ_PERSON_PROFILES pp, IGS_AD_LOCATION_ALL l, IGS_PS_UNIT_VER_ALL psu, IGS_AS_UNIT_MODE asm, IGS_AS_UNIT_CLASS_ALL asu, IGS_TR_ITEM_ALL tr, HZ_PARTIES p1, HZ_PERSON_PROFILES pp1, IGS_PS_UNIT_VER_ALL psu1 WHERE paa.ADM_UNIT_OUTCOME_STATUS = ous.ADM_UNIT_OUTCOME_STATUS AND paa.UNIT_CD = psu.UNIT_CD AND paa.UV_VERSION_NUMBER = psu.VERSION_NUMBER AND paa.ASS_TRACKING_ID = TR.TRACKING_ID(+) AND inst.NOMINATED_COURSE_CD = psv.COURSE_CD AND paa.NOMINATED_COURSE_CD = inst.NOMINATED_COURSE_CD AND paa.PERSON_ID = inst.PERSON_ID AND paa.ADMISSION_APPL_NUMBER = inst.ADMISSION_APPL_NUMBER AND paa.ACAI_SEQUENCE_NUMBER = inst.SEQUENCE_NUMBER AND inst.CRV_VERSION_NUMBER = psv.VERSION_NUMBER AND paa.UNIT_CLASS = asu.UNIT_CLASS(+) AND paa.UNIT_MODE = asm.UNIT_MODE(+) AND paa.LOCATION_CD = l.LOCATION_CD(+) AND paa.SUP_UV_VERSION_NUMBER = psu1.VERSION_NUMBER(+) AND paa.SUP_UNIT_CD = psu1.UNIT_CD(+) AND paa.CAL_TYPE = ci.CAL_TYPE(+) AND paa.CI_SEQUENCE_NUMBER = ci.SEQUENCE_NUMBER(+) AND paa.PERSON_ID = p.PARTY_ID AND p.PARTY_ID = pp.PARTY_ID AND pp.CONTENT_SOURCE_TYPE = 'USER_ENTERED' AND SYSDATE BETWEEN pp.EFFECTIVE_START_DATE AND NVL(pp.EFFECTIVE_END_DATE,SYSDATE) AND paa.RULE_WAIVED_PERSON_ID = p1.PARTY_ID(+) AND p1.PARTY_ID = pp1.PARTY_ID(+) AND pp1.CONTENT_SOURCE_TYPE(+) = 'USER_ENTERED' AND SYSDATE BETWEEN pp1.EFFECTIVE_START_DATE(+) AND NVL(pp1.EFFECTIVE_END_DATE,SYSDATE) WITH READ ONLY

View Text - HTML Formatted

SELECT PAA.PERSON_ID
, P.PARTY_NUMBER
, PP.PERSON_NAME
, PAA.ADMISSION_APPL_NUMBER
, PAA.NOMINATED_COURSE_CD
, PSV.TITLE
, PAA.ACAI_SEQUENCE_NUMBER
, PAA.UNIT_CD
, PSU.TITLE
, PAA.UV_VERSION_NUMBER
, CI.DESCRIPTION
, PAA.CAL_TYPE
, PAA.CI_SEQUENCE_NUMBER
, PAA.LOCATION_CD
, L.DESCRIPTION
, PAA.UNIT_CLASS
, ASU.DESCRIPTION
, PAA.UNIT_MODE
, ASM.DESCRIPTION
, PAA.ADM_UNIT_OUTCOME_STATUS
, OUS.DESCRIPTION
, PAA.ASS_TRACKING_ID
, TR.TRACKING_STATUS
, TR.TRACKING_TYPE
, PAA.RULE_WAIVED_DT
, PAA.RULE_WAIVED_PERSON_ID
, P1.PARTY_NUMBER
, PP1.PERSON_NAME
, PAA.SUP_UNIT_CD
, PSU1.TITLE
, PAA.SUP_UV_VERSION_NUMBER
, PAA.CREATED_BY
, PAA.CREATION_DATE
, PAA.LAST_UPDATED_BY
, PAA.LAST_UPDATE_DATE
FROM IGS_AD_PS_APLINSTUNT_ALL PAA
, IGS_AD_UNIT_OU_STAT OUS
, IGS_PS_VER_ALL PSV
, IGS_AD_PS_APPL_INST_ALL INST
, IGS_CA_INST_ALL CI
, HZ_PARTIES P
, HZ_PERSON_PROFILES PP
, IGS_AD_LOCATION_ALL L
, IGS_PS_UNIT_VER_ALL PSU
, IGS_AS_UNIT_MODE ASM
, IGS_AS_UNIT_CLASS_ALL ASU
, IGS_TR_ITEM_ALL TR
, HZ_PARTIES P1
, HZ_PERSON_PROFILES PP1
, IGS_PS_UNIT_VER_ALL PSU1
WHERE PAA.ADM_UNIT_OUTCOME_STATUS = OUS.ADM_UNIT_OUTCOME_STATUS
AND PAA.UNIT_CD = PSU.UNIT_CD
AND PAA.UV_VERSION_NUMBER = PSU.VERSION_NUMBER
AND PAA.ASS_TRACKING_ID = TR.TRACKING_ID(+)
AND INST.NOMINATED_COURSE_CD = PSV.COURSE_CD
AND PAA.NOMINATED_COURSE_CD = INST.NOMINATED_COURSE_CD
AND PAA.PERSON_ID = INST.PERSON_ID
AND PAA.ADMISSION_APPL_NUMBER = INST.ADMISSION_APPL_NUMBER
AND PAA.ACAI_SEQUENCE_NUMBER = INST.SEQUENCE_NUMBER
AND INST.CRV_VERSION_NUMBER = PSV.VERSION_NUMBER
AND PAA.UNIT_CLASS = ASU.UNIT_CLASS(+)
AND PAA.UNIT_MODE = ASM.UNIT_MODE(+)
AND PAA.LOCATION_CD = L.LOCATION_CD(+)
AND PAA.SUP_UV_VERSION_NUMBER = PSU1.VERSION_NUMBER(+)
AND PAA.SUP_UNIT_CD = PSU1.UNIT_CD(+)
AND PAA.CAL_TYPE = CI.CAL_TYPE(+)
AND PAA.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER(+)
AND PAA.PERSON_ID = P.PARTY_ID
AND P.PARTY_ID = PP.PARTY_ID
AND PP.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
AND SYSDATE BETWEEN PP.EFFECTIVE_START_DATE
AND NVL(PP.EFFECTIVE_END_DATE
, SYSDATE)
AND PAA.RULE_WAIVED_PERSON_ID = P1.PARTY_ID(+)
AND P1.PARTY_ID = PP1.PARTY_ID(+)
AND PP1.CONTENT_SOURCE_TYPE(+) = 'USER_ENTERED'
AND SYSDATE BETWEEN PP1.EFFECTIVE_START_DATE(+)
AND NVL(PP1.EFFECTIVE_END_DATE
, SYSDATE) WITH READ ONLY