View: IGF_AP_PR_PRG_TYPE_V

Product:	IGF - Financial Aid
Description:	Stores basic information about year specific Program Types that can be used to define Grade Levels for specific program type's class standing.
Implementation/DBA Data:	APPS.IGF_AP_PR_PRG_TYPE_V

View Text

SELECT PPT.ROWID
, PPT.PPT_ID
, PPT.IGS_PR_CS_SCHDL_ID
, PT.COURSE_TYPE
, PT.DESCRIPTION
, PPT.CAL_TYPE
, PPT.SEQUENCE_NUMBER
, CI.ALTERNATE_CODE
, CI.START_DT
, CI.END_DT
, PPT.CREATED_BY
, PPT.CREATION_DATE
, PPT.LAST_UPDATED_BY
, PPT.LAST_UPDATE_DATE
, PPT.LAST_UPDATE_LOGIN
FROM IGS_PS_TYPE PT
, IGS_PR_CS_SCHDL PCSC
, IGF_AP_PR_PRG_TYPE PPT
, IGS_CA_INST_ALL CI
, IGF_AP_BATCH_AW_MAP_ALL BAM
WHERE PCSC.COURSE_TYPE = PT.COURSE_TYPE
AND PPT.IGS_PR_CS_SCHDL_ID = PCSC. IGS_PR_CS_SCHDL_ID AND PPT.CAL_TYPE = BAM.CI_CAL_TYPE AND PPT.SEQUENCE_NUMBER = BAM.CI_SEQUENCE_NUMBER
AND BAM.CI_CAL_TYPE = CI.CAL_TYPE
AND BAM.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER

Columns