VIEW: APPS.IGS_PS_TYPE_V

Source

View Text - Preformatted

SELECT TAB.ROWID ROW_ID, TAB.COURSE_TYPE COURSE_TYPE, TAB.DESCRIPTION DESCRIPTION, TAB.GOVT_COURSE_TYPE GOVT_COURSE_TYPE, TAB.AWARD_COURSE_IND AWARD_COURSE_IND, TAB.COURSE_TYPE_GROUP_CD COURSE_TYPE_GROUP_CD, TAB.TAC_COURSE_LEVEL TAC_COURSE_LEVEL, TAB.RESEARCH_TYPE_IND RESEARCH_TYPE_IND, TAB.CLOSED_IND CLOSED_IND, TAB.PRIMARY_AUTO_SELECT PRIMARY_AUTO_SELECT, TAB.FIN_AID_PROGRAM_TYPE FIN_AID_PROGRAM_TYPE, LV.MEANING, TAB.CREATED_BY CREATED_BY, TAB.CREATION_DATE CREATION_DATE, TAB.LAST_UPDATED_BY LAST_UPDATED_BY, TAB.LAST_UPDATE_DATE LAST_UPDATE_DATE, TAB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, TAB.ORG_ID ORG_ID, TAB.ENROLMENT_CAT ENROLMENT_CAT FROM IGS_PS_TYPE TAB, IGS_LOOKUP_VALUES LV WHERE TAB.FIN_AID_PROGRAM_TYPE = LV.LOOKUP_CODE (+) AND LV.LOOKUP_TYPE (+) = 'IGS_PS_FA_PROGRAM_TYPE'

View Text - HTML Formatted

SELECT TAB.ROWID ROW_ID
, TAB.COURSE_TYPE COURSE_TYPE
, TAB.DESCRIPTION DESCRIPTION
, TAB.GOVT_COURSE_TYPE GOVT_COURSE_TYPE
, TAB.AWARD_COURSE_IND AWARD_COURSE_IND
, TAB.COURSE_TYPE_GROUP_CD COURSE_TYPE_GROUP_CD
, TAB.TAC_COURSE_LEVEL TAC_COURSE_LEVEL
, TAB.RESEARCH_TYPE_IND RESEARCH_TYPE_IND
, TAB.CLOSED_IND CLOSED_IND
, TAB.PRIMARY_AUTO_SELECT PRIMARY_AUTO_SELECT
, TAB.FIN_AID_PROGRAM_TYPE FIN_AID_PROGRAM_TYPE
, LV.MEANING
, TAB.CREATED_BY CREATED_BY
, TAB.CREATION_DATE CREATION_DATE
, TAB.LAST_UPDATED_BY LAST_UPDATED_BY
, TAB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TAB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TAB.ORG_ID ORG_ID
, TAB.ENROLMENT_CAT ENROLMENT_CAT
FROM IGS_PS_TYPE TAB
, IGS_LOOKUP_VALUES LV
WHERE TAB.FIN_AID_PROGRAM_TYPE = LV.LOOKUP_CODE (+)
AND LV.LOOKUP_TYPE (+) = 'IGS_PS_FA_PROGRAM_TYPE'