VIEW: APPS.IGS_PE_ATHLETIC_DTL_V

Source

View Text - Preformatted

SELECT AD.ROWID ROW_ID, AD.ATHLETIC_DETAILS_ID, AD.PERSON_ID, AD.ATHLETIC_GPA, L1.MEANING ELIGIBILITY_STATUS, AD.ELIGIBILITY_STATUS_CD, L2.MEANING PREDICT_ELIG_M, AD.PREDICT_ELIG_CODE, L3.MEANING TENTATIVE_ADM_M, AD.TENTATIVE_ADM_CODE, AD.REVIEW_DATE, AD.COMMENTS, AD.CREATED_BY, AD.CREATION_DATE, AD.LAST_UPDATED_BY, AD.LAST_UPDATE_DATE, AD.LAST_UPDATE_LOGIN FROM IGS_PE_ATHLETIC_DTL AD, IGS_LOOKUP_VALUES L1, IGS_LOOKUP_VALUES L2, IGS_LOOKUP_VALUES L3 WHERE AD.ELIGIBILITY_STATUS_CD = L1.LOOKUP_CODE(+) AND L1.LOOKUP_TYPE(+) = 'PE_ATH_ELG_STATUS' AND AD.PREDICT_ELIG_CODE = L2. LOOKUP_CODE(+) AND L2. LOOKUP_TYPE(+) = 'PE_PRE_ELIG_TYPE' AND AD.TENTATIVE_ADM_CODE = L3. LOOKUP_CODE(+) AND L3.LOOKUP_TYPE(+) = 'PE_TENTATIVE_ADM_TYPE'

View Text - HTML Formatted

SELECT AD.ROWID ROW_ID
, AD.ATHLETIC_DETAILS_ID
, AD.PERSON_ID
, AD.ATHLETIC_GPA
, L1.MEANING ELIGIBILITY_STATUS
, AD.ELIGIBILITY_STATUS_CD
, L2.MEANING PREDICT_ELIG_M
, AD.PREDICT_ELIG_CODE
, L3.MEANING TENTATIVE_ADM_M
, AD.TENTATIVE_ADM_CODE
, AD.REVIEW_DATE
, AD.COMMENTS
, AD.CREATED_BY
, AD.CREATION_DATE
, AD.LAST_UPDATED_BY
, AD.LAST_UPDATE_DATE
, AD.LAST_UPDATE_LOGIN
FROM IGS_PE_ATHLETIC_DTL AD
, IGS_LOOKUP_VALUES L1
, IGS_LOOKUP_VALUES L2
, IGS_LOOKUP_VALUES L3
WHERE AD.ELIGIBILITY_STATUS_CD = L1.LOOKUP_CODE(+)
AND L1.LOOKUP_TYPE(+) = 'PE_ATH_ELG_STATUS'
AND AD.PREDICT_ELIG_CODE = L2. LOOKUP_CODE(+)
AND L2. LOOKUP_TYPE(+) = 'PE_PRE_ELIG_TYPE'
AND AD.TENTATIVE_ADM_CODE = L3. LOOKUP_CODE(+)
AND L3.LOOKUP_TYPE(+) = 'PE_TENTATIVE_ADM_TYPE'