VIEW: APPS.IGS_AD_PANEL_MEMBRS_V

Source

View Text - Preformatted

SELECT Pnlmbr.rowid row_id ,pnlmbr.panel_code panel_code ,pnlmbr.member_person_id member_person_id ,pebase.person_number person_number ,pebase.full_name full_name ,pnlmbr.panel_seq_num panel_seq_num ,pnlmbr.role_type_code role_type_code ,lkups.meaning role_type_desc ,pnlmbr.attribute_category attribute_category ,pnlmbr.attribute1 attribute1 ,pnlmbr.attribute2 attribute2 ,pnlmbr.attribute3 attribute3 ,pnlmbr.attribute4 attribute4 ,pnlmbr.attribute5 attribute5 ,pnlmbr.attribute6 attribute6 ,pnlmbr.attribute7 attribute7 ,pnlmbr.attribute8 attribute8 ,pnlmbr.attribute9 attribute9 ,pnlmbr.attribute10 attribute10 ,pnlmbr.attribute11 attribute11 ,pnlmbr.attribute12 attribute12 ,pnlmbr.attribute13 attribute13 ,pnlmbr.attribute14 attribute14 ,pnlmbr.attribute15 attribute15 ,pnlmbr.attribute16 attribute16 ,pnlmbr.attribute17 attribute17 ,pnlmbr.attribute18 attribute18 ,pnlmbr.attribute19 attribute19 ,pnlmbr.attribute20 attribute20 ,pnlmbr.created_by created_by ,pnlmbr.creation_date creation_date ,pnlmbr.last_updated_by last_updated_by ,pnlmbr.last_update_date last_update_date ,pnlmbr.last_update_login last_update_login FROM igs_ad_panel_membrs pnlmbr, igs_pe_person_base_v pebase, igs_lookup_values lkups, IGS_AD_INTVW_PNLS pnltype WHERE pnlmbr.member_person_id = pebase.person_id AND pnlmbr.role_type_code = lkups.lookup_code AND pnlmbr.panel_code = pnltype.panel_code AND ((pnltype.panel_type_code = 'INTERVIEW' AND lkups.lookup_type = 'INTERVIEW_ROLE_TYPE') OR (pnltype.panel_type_code = 'SCREENING' AND lkups.lookup_type = 'SCREEN_ROLE_TYPE'))

View Text - HTML Formatted

SELECT PNLMBR.ROWID ROW_ID
, PNLMBR.PANEL_CODE PANEL_CODE
, PNLMBR.MEMBER_PERSON_ID MEMBER_PERSON_ID
, PEBASE.PERSON_NUMBER PERSON_NUMBER
, PEBASE.FULL_NAME FULL_NAME
, PNLMBR.PANEL_SEQ_NUM PANEL_SEQ_NUM
, PNLMBR.ROLE_TYPE_CODE ROLE_TYPE_CODE
, LKUPS.MEANING ROLE_TYPE_DESC
, PNLMBR.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, PNLMBR.ATTRIBUTE1 ATTRIBUTE1
, PNLMBR.ATTRIBUTE2 ATTRIBUTE2
, PNLMBR.ATTRIBUTE3 ATTRIBUTE3
, PNLMBR.ATTRIBUTE4 ATTRIBUTE4
, PNLMBR.ATTRIBUTE5 ATTRIBUTE5
, PNLMBR.ATTRIBUTE6 ATTRIBUTE6
, PNLMBR.ATTRIBUTE7 ATTRIBUTE7
, PNLMBR.ATTRIBUTE8 ATTRIBUTE8
, PNLMBR.ATTRIBUTE9 ATTRIBUTE9
, PNLMBR.ATTRIBUTE10 ATTRIBUTE10
, PNLMBR.ATTRIBUTE11 ATTRIBUTE11
, PNLMBR.ATTRIBUTE12 ATTRIBUTE12
, PNLMBR.ATTRIBUTE13 ATTRIBUTE13
, PNLMBR.ATTRIBUTE14 ATTRIBUTE14
, PNLMBR.ATTRIBUTE15 ATTRIBUTE15
, PNLMBR.ATTRIBUTE16 ATTRIBUTE16
, PNLMBR.ATTRIBUTE17 ATTRIBUTE17
, PNLMBR.ATTRIBUTE18 ATTRIBUTE18
, PNLMBR.ATTRIBUTE19 ATTRIBUTE19
, PNLMBR.ATTRIBUTE20 ATTRIBUTE20
, PNLMBR.CREATED_BY CREATED_BY
, PNLMBR.CREATION_DATE CREATION_DATE
, PNLMBR.LAST_UPDATED_BY LAST_UPDATED_BY
, PNLMBR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PNLMBR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_AD_PANEL_MEMBRS PNLMBR
, IGS_PE_PERSON_BASE_V PEBASE
, IGS_LOOKUP_VALUES LKUPS
, IGS_AD_INTVW_PNLS PNLTYPE
WHERE PNLMBR.MEMBER_PERSON_ID = PEBASE.PERSON_ID
AND PNLMBR.ROLE_TYPE_CODE = LKUPS.LOOKUP_CODE
AND PNLMBR.PANEL_CODE = PNLTYPE.PANEL_CODE
AND ((PNLTYPE.PANEL_TYPE_CODE = 'INTERVIEW'
AND LKUPS.LOOKUP_TYPE = 'INTERVIEW_ROLE_TYPE') OR (PNLTYPE.PANEL_TYPE_CODE = 'SCREENING'
AND LKUPS.LOOKUP_TYPE = 'SCREEN_ROLE_TYPE'))