VIEW: APPS.IGF_AP_CLASS_STD_MAP_V

Source

View Text - Preformatted

SELECT PCSS.IGS_PR_CSS_CLASS_STD_ID, PCSS.IGS_PR_CS_SCHDL_ID, PCS.CLASS_STANDING, PCS.DESCRIPTION, IPCS.ROWID, IPCS.IPCS_ID, IGF_AW_GEN.LOOKUP_DESC ('IGF_AP_GRADE_LEVEL', IPCS.AP_STD_CODE), IPCS.AP_STD_CODE, IGF_AW_GEN.LOOKUP_DESC ('IGF_AP_GRADE_LEVEL' , IPCS.DL_STD_CODE), IPCS.DL_STD_CODE, IGF_AW_GEN.LOOKUP_DESC ('IGF_SL_CL_GRADE_LEVEL', IPCS.CL_STD_CODE), IPCS.CL_STD_CODE, IPCS.CREATED_BY, IPCS.CREATION_DATE, IPCS.LAST_UPDATED_BY, IPCS.LAST_UPDATE_DATE, IPCS.LAST_UPDATE_LOGIN, IPCS.PPT_ID FROM IGF_AP_CLASS_STD_MAP IPCS, IGS_PR_CSS_CLASS_STD PCSS, IGS_PR_CLASS_STD PCS WHERE PCSS.IGS_PR_CLASS_STD_ID = PCS.IGS_PR_CLASS_STD_ID AND PCSS.IGS_PR_CSS_CLASS_STD_ID = IPCS.IGS_PR_CSS_CLASS_STD_ID

View Text - HTML Formatted

SELECT PCSS.IGS_PR_CSS_CLASS_STD_ID
, PCSS.IGS_PR_CS_SCHDL_ID
, PCS.CLASS_STANDING
, PCS.DESCRIPTION
, IPCS.ROWID
, IPCS.IPCS_ID
, IGF_AW_GEN.LOOKUP_DESC ('IGF_AP_GRADE_LEVEL'
, IPCS.AP_STD_CODE)
, IPCS.AP_STD_CODE
, IGF_AW_GEN.LOOKUP_DESC ('IGF_AP_GRADE_LEVEL'
, IPCS.DL_STD_CODE)
, IPCS.DL_STD_CODE
, IGF_AW_GEN.LOOKUP_DESC ('IGF_SL_CL_GRADE_LEVEL'
, IPCS.CL_STD_CODE)
, IPCS.CL_STD_CODE
, IPCS.CREATED_BY
, IPCS.CREATION_DATE
, IPCS.LAST_UPDATED_BY
, IPCS.LAST_UPDATE_DATE
, IPCS.LAST_UPDATE_LOGIN
, IPCS.PPT_ID
FROM IGF_AP_CLASS_STD_MAP IPCS
, IGS_PR_CSS_CLASS_STD PCSS
, IGS_PR_CLASS_STD PCS
WHERE PCSS.IGS_PR_CLASS_STD_ID = PCS.IGS_PR_CLASS_STD_ID
AND PCSS.IGS_PR_CSS_CLASS_STD_ID = IPCS.IGS_PR_CSS_CLASS_STD_ID