eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.IGF_AP_PR_PRG_TYPE_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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