DBA Data[Home] [Help]

VIEW: APPS.IGS_PS_PRG_UNIT_REL_V

Source

View Text - Preformatted

SELECT PRRUL.ROWID ROW_ID, PRRUL.PS_PRUN_REL_ID, PRRUL.STUDENT_CAREER_LEVEL, PRRUL.UNIT_TYPE_ID, ULVL.LEVEL_CODE, PRRUL.STUDENT_CAREER_TRANSCRIPT, PRRUL.STUDENT_CAREER_STATISTICS, PRRUL.CREATED_BY, PRRUL.CREATION_DATE, PRRUL.LAST_UPDATED_BY, PRRUL.LAST_UPDATE_DATE, PRRUL.LAST_UPDATE_LOGIN FROM IGS_PS_PRG_UNIT_REL PRRUL, IGS_PS_UNIT_TYPE_LVL ULVL WHERE PRRUL.UNIT_TYPE_ID = ULVL.UNIT_TYPE_ID
View Text - HTML Formatted

SELECT PRRUL.ROWID ROW_ID
, PRRUL.PS_PRUN_REL_ID
, PRRUL.STUDENT_CAREER_LEVEL
, PRRUL.UNIT_TYPE_ID
, ULVL.LEVEL_CODE
, PRRUL.STUDENT_CAREER_TRANSCRIPT
, PRRUL.STUDENT_CAREER_STATISTICS
, PRRUL.CREATED_BY
, PRRUL.CREATION_DATE
, PRRUL.LAST_UPDATED_BY
, PRRUL.LAST_UPDATE_DATE
, PRRUL.LAST_UPDATE_LOGIN
FROM IGS_PS_PRG_UNIT_REL PRRUL
, IGS_PS_UNIT_TYPE_LVL ULVL
WHERE PRRUL.UNIT_TYPE_ID = ULVL.UNIT_TYPE_ID