VIEW: APPS.IGS_PR_OU_TYPE_V

Source

View Text - Preformatted

SELECT drvtab.ROWID ROW_ID , drvtab.PROGRESSION_OUTCOME_TYPE PROGRESSION_OUTCOME_TYPE, drvtab.DESCRIPTION DESCRIPTION, drvtab.S_PROGRESSION_OUTCOME_TYPE S_PROGRESSION_OUTCOME_TYPE, lkup.MEANING MEANING, drvtab.positive_outcome_ind POSITIVE_OUTCOME_IND , drvtab.CLOSED_IND CLOSED_IND, ATTYP.DESCRIPTION ATT_TYP_DESCRIPTION, lkup.CLOSED_IND LOOKUP_CLOSED_IND, drvtab.ENCUMBRANCE_TYPE ENCUMBRANCE_TYPE, ET.DESCRIPTION ENCUMB_DESCRIPTION, ATTYP.CLOSED_IND ATT_TYP_CLOSED_IND, lkup.LOOKUP_TYPE LOOKUP_TYPE, ET.S_ENCUMBRANCE_CAT S_ENCUMBRANCE_CAT, ET.CLOSED_IND ENCUMB_CLOSED_IND, drvtab.DFLT_RESTRICTED_ENROLMENT_CP DFLT_RESTRICTED_ENROLMENT_CP, drvtab.DFLT_RESTRICTED_ATT_TYPE DFLT_RESTRICTED_ATT_TYPE, drvtab.COMMENTS COMMENTS, drvtab.CREATED_BY CREATED_BY, drvtab.CREATION_DATE CREATION_DATE, drvtab.LAST_UPDATED_BY LAST_UPDATED_BY, drvtab.LAST_UPDATE_DATE LAST_UPDATE_DATE, drvtab.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM IGS_PR_OU_TYPE drvtab, IGS_LOOKUPS_VIEW lkup, IGS_EN_ATD_TYPE ATTYP, IGS_FI_ENCMB_TYPE ET WHERE (lkup.LOOKUP_TYPE = 'PROGRESSION_OUTCOME_TYPE' AND lkup.LOOKUP_CODE = drvtab.S_PROGRESSION_OUTCOME_TYPE) AND ATTYP.ATTENDANCE_TYPE(+) = drvtab.DFLT_RESTRICTED_ATT_TYPE AND ET.ENCUMBRANCE_TYPE(+) = DRVTAB.ENCUMBRANCE_TYPE

View Text - HTML Formatted

SELECT DRVTAB.ROWID ROW_ID
, DRVTAB.PROGRESSION_OUTCOME_TYPE PROGRESSION_OUTCOME_TYPE
, DRVTAB.DESCRIPTION DESCRIPTION
, DRVTAB.S_PROGRESSION_OUTCOME_TYPE S_PROGRESSION_OUTCOME_TYPE
, LKUP.MEANING MEANING
, DRVTAB.POSITIVE_OUTCOME_IND POSITIVE_OUTCOME_IND
, DRVTAB.CLOSED_IND CLOSED_IND
, ATTYP.DESCRIPTION ATT_TYP_DESCRIPTION
, LKUP.CLOSED_IND LOOKUP_CLOSED_IND
, DRVTAB.ENCUMBRANCE_TYPE ENCUMBRANCE_TYPE
, ET.DESCRIPTION ENCUMB_DESCRIPTION
, ATTYP.CLOSED_IND ATT_TYP_CLOSED_IND
, LKUP.LOOKUP_TYPE LOOKUP_TYPE
, ET.S_ENCUMBRANCE_CAT S_ENCUMBRANCE_CAT
, ET.CLOSED_IND ENCUMB_CLOSED_IND
, DRVTAB.DFLT_RESTRICTED_ENROLMENT_CP DFLT_RESTRICTED_ENROLMENT_CP
, DRVTAB.DFLT_RESTRICTED_ATT_TYPE DFLT_RESTRICTED_ATT_TYPE
, DRVTAB.COMMENTS COMMENTS
, DRVTAB.CREATED_BY CREATED_BY
, DRVTAB.CREATION_DATE CREATION_DATE
, DRVTAB.LAST_UPDATED_BY LAST_UPDATED_BY
, DRVTAB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, DRVTAB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_PR_OU_TYPE DRVTAB
, IGS_LOOKUPS_VIEW LKUP
, IGS_EN_ATD_TYPE ATTYP
, IGS_FI_ENCMB_TYPE ET
WHERE (LKUP.LOOKUP_TYPE = 'PROGRESSION_OUTCOME_TYPE'
AND LKUP.LOOKUP_CODE = DRVTAB.S_PROGRESSION_OUTCOME_TYPE)
AND ATTYP.ATTENDANCE_TYPE(+) = DRVTAB.DFLT_RESTRICTED_ATT_TYPE
AND ET.ENCUMBRANCE_TYPE(+) = DRVTAB.ENCUMBRANCE_TYPE