[Home] [Help]
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
Name |
ROW_ID |
PPT_ID |
IGS_PR_CS_SCHDL_ID |
PROGRAM_TYPE |
DESCRIPTION |
CAL_TYPE |
SEQUENCE_NUMBER |
ALTERNATE_CODE |
START_DT |
END_DT |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |