VIEW: APPS.IGS_PS_FLD_STDY_HIST

Source

View Text - Preformatted

SELECT tab.rowid row_id, tab.fos_type_code fos_type_code, us.meaning fos_type_code_desc, tab.field_of_study field_of_study, tab.hist_start_dt hist_start_dt, tab.hist_end_dt hist_end_dt, tab.hist_who hist_who, tab.description description, tab.govt_field_of_study govt_field_of_study, tab.closed_ind closed_ind, tab.created_by created_by, tab.creation_date creation_date, tab.last_updated_by last_updated_by, tab.last_update_date last_update_date, tab.last_update_login last_update_login , tab.org_id org_id FROM igs_ps_fld_stdy_hist_all tab, igs_lookup_values us WHERE tab.fos_type_code = us.lookup_code AND us.lookup_type = 'PS_FOS_TYPE_CD'

View Text - HTML Formatted

SELECT TAB.ROWID ROW_ID
, TAB.FOS_TYPE_CODE FOS_TYPE_CODE
, US.MEANING FOS_TYPE_CODE_DESC
, TAB.FIELD_OF_STUDY FIELD_OF_STUDY
, TAB.HIST_START_DT HIST_START_DT
, TAB.HIST_END_DT HIST_END_DT
, TAB.HIST_WHO HIST_WHO
, TAB.DESCRIPTION DESCRIPTION
, TAB.GOVT_FIELD_OF_STUDY GOVT_FIELD_OF_STUDY
, TAB.CLOSED_IND CLOSED_IND
, TAB.CREATED_BY CREATED_BY
, TAB.CREATION_DATE CREATION_DATE
, TAB.LAST_UPDATED_BY LAST_UPDATED_BY
, TAB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TAB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TAB.ORG_ID ORG_ID
FROM IGS_PS_FLD_STDY_HIST_ALL TAB
, IGS_LOOKUP_VALUES US
WHERE TAB.FOS_TYPE_CODE = US.LOOKUP_CODE
AND US.LOOKUP_TYPE = 'PS_FOS_TYPE_CD'