DBA Data[Home] [Help]

VIEW: APPS.IGS_PR_UL_MARK_CNFG_V

Source

View Text - Preformatted

SELECT ULMC.ROWID ROW_ID , ULMC.MARK_CONFIG_ID, ULMC.UNIT_LEVEL, UL.DESCRIPTION UNIT_LEVEL_DESC, ULMC.COURSE_CD, ULMC.VERSION_NUMBER, PV.TITLE AS COURSE_TITLE, ULMC.TOTAL_UNIT_LEVEL_CREDITS, ULMC.SELECTION_METHOD_CODE, LKUP.MEANING SELECTION_METHOD, ULMC.CREATED_BY, ULMC.CREATION_DATE, ULMC.LAST_UPDATED_BY, ULMC.LAST_UPDATE_DATE, ULMC.LAST_UPDATE_LOGIN FROM IGS_PR_UL_MARK_CNFG ULMC, IGS_PS_UNIT_LEVEL_ALL UL, IGS_PS_VER_ALL PV, IGS_LOOKUP_VALUES LKUP WHERE ULMC.UNIT_LEVEL = UL.UNIT_LEVEL AND ULMC. SELECTION_METHOD_CODE = LKUP.LOOKUP_CODE AND LKUP.LOOKUP_TYPE = 'IGS_PR_MARK_CFG_SELECTION' AND ULMC.COURSE_CD = PV.COURSE_CD(+) AND ULMC.VERSION_NUMBER = PV.VERSION_NUMBER(+)
View Text - HTML Formatted

SELECT ULMC.ROWID ROW_ID
, ULMC.MARK_CONFIG_ID
, ULMC.UNIT_LEVEL
, UL.DESCRIPTION UNIT_LEVEL_DESC
, ULMC.COURSE_CD
, ULMC.VERSION_NUMBER
, PV.TITLE AS COURSE_TITLE
, ULMC.TOTAL_UNIT_LEVEL_CREDITS
, ULMC.SELECTION_METHOD_CODE
, LKUP.MEANING SELECTION_METHOD
, ULMC.CREATED_BY
, ULMC.CREATION_DATE
, ULMC.LAST_UPDATED_BY
, ULMC.LAST_UPDATE_DATE
, ULMC.LAST_UPDATE_LOGIN
FROM IGS_PR_UL_MARK_CNFG ULMC
, IGS_PS_UNIT_LEVEL_ALL UL
, IGS_PS_VER_ALL PV
, IGS_LOOKUP_VALUES LKUP
WHERE ULMC.UNIT_LEVEL = UL.UNIT_LEVEL
AND ULMC. SELECTION_METHOD_CODE = LKUP.LOOKUP_CODE
AND LKUP.LOOKUP_TYPE = 'IGS_PR_MARK_CFG_SELECTION'
AND ULMC.COURSE_CD = PV.COURSE_CD(+)
AND ULMC.VERSION_NUMBER = PV.VERSION_NUMBER(+)