VIEW: APPS.IGS_RE_CDT_FLD_OF_SY_V

Source

View Text - Preformatted

SELECT fs.rowid row_id, fs.person_id, fs.ca_sequence_number, fos.fos_type_code, fos.fos_type_code_desc, fs.field_of_study, fs.percentage, fs.created_by, fs.creation_date, fs.last_updated_by, fs.last_update_date, fs.last_update_login FROM igs_re_cdt_fld_of_sy fs, igs_ps_fld_of_study fos WHERE fs.field_of_study = fos.field_of_study

View Text - HTML Formatted

SELECT FS.ROWID ROW_ID
, FS.PERSON_ID
, FS.CA_SEQUENCE_NUMBER
, FOS.FOS_TYPE_CODE
, FOS.FOS_TYPE_CODE_DESC
, FS.FIELD_OF_STUDY
, FS.PERCENTAGE
, FS.CREATED_BY
, FS.CREATION_DATE
, FS.LAST_UPDATED_BY
, FS.LAST_UPDATE_DATE
, FS.LAST_UPDATE_LOGIN
FROM IGS_RE_CDT_FLD_OF_SY FS
, IGS_PS_FLD_OF_STUDY FOS
WHERE FS.FIELD_OF_STUDY = FOS.FIELD_OF_STUDY