VIEW: APPS.IGS_SS_APPL_PERSTAT_V

Source

View Text - Preformatted

SELECT a.rowid , a.ss_perstat_id , a.person_id , a.ss_adm_appl_id , a.persl_stat_type , c.persl_stat_type_desc, c.closed_ind, a.date_received , a.created_by , a.creation_date , a.attach_exists , a.last_updated_by , a.last_update_date, a.last_update_login, b.group_number, b.mandatory, b.admission_application_type, d.group_min, d.self_message, d.group_name, d.group_required_flag from igs_ss_appl_perstat a, igs_ad_aptyp_pestat b, igs_ad_per_stm_typ c, igs_ad_pestat_group d WHERE a.persl_stat_type = b.persl_stat_type and b.persl_stat_type = c.persl_stat_type and d.group_number(+) = b.group_number and d.admission_application_type(+) = b.admission_application_type and a.admission_application_type = b.admission_application_type with CHECK OPTION

View Text - HTML Formatted

SELECT A.ROWID
, A.SS_PERSTAT_ID
, A.PERSON_ID
, A.SS_ADM_APPL_ID
, A.PERSL_STAT_TYPE
, C.PERSL_STAT_TYPE_DESC
, C.CLOSED_IND
, A.DATE_RECEIVED
, A.CREATED_BY
, A.CREATION_DATE
, A.ATTACH_EXISTS
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATE_LOGIN
, B.GROUP_NUMBER
, B.MANDATORY
, B.ADMISSION_APPLICATION_TYPE
, D.GROUP_MIN
, D.SELF_MESSAGE
, D.GROUP_NAME
, D.GROUP_REQUIRED_FLAG
FROM IGS_SS_APPL_PERSTAT A
, IGS_AD_APTYP_PESTAT B
, IGS_AD_PER_STM_TYP C
, IGS_AD_PESTAT_GROUP D
WHERE A.PERSL_STAT_TYPE = B.PERSL_STAT_TYPE
AND B.PERSL_STAT_TYPE = C.PERSL_STAT_TYPE
AND D.GROUP_NUMBER(+) = B.GROUP_NUMBER
AND D.ADMISSION_APPLICATION_TYPE(+) = B.ADMISSION_APPLICATION_TYPE
AND A.ADMISSION_APPLICATION_TYPE = B.ADMISSION_APPLICATION_TYPE WITH CHECK OPTION