VIEW: APPS.IGS_RE_THS_PNL_MBR_V

Source

View Text - Preformatted

SELECT tpm.rowid row_ID, tpm.CA_PERSON_ID, tpm. CA_SEQUENCE_NUMBER, tpm.THE_SEQUENCE_NUMBER, tpm. CREATION_DT, tpm. PERSON_ID, pe.PARTY_NUMBER, tpm. PANEL_MEMBER_TYPE, DECODE(NVL(tpm.CONFIRMED_DT,SYSDATE),SYSDATE,'N','Y') CONFIRMED_IND, tpm.CONFIRMED_DT, DECODE(NVL(tpm.DECLINED_DT,SYSDATE),SYSDATE,'N','Y') DECLINED_IND, tpm. DECLINED_DT, tpm. ANONYMITY_IND, tpm. THESIS_RESULT_CD, tpm.PAID_DT, tpm. TRACKING_ID, tpm.created_by, tpm.creation_date, tpm.last_updated_by, tpm.last_update_date, tpm.last_update_login, tpm. RECOMMENDATION_SUMMARY FROM IGS_RE_THS_PNL_MBR tpm, HZ_PARTIES pe WHERE TPM.PERSON_ID = PE.PARTY_ID

View Text - HTML Formatted

SELECT TPM.ROWID ROW_ID
, TPM.CA_PERSON_ID
, TPM. CA_SEQUENCE_NUMBER
, TPM.THE_SEQUENCE_NUMBER
, TPM. CREATION_DT
, TPM. PERSON_ID
, PE.PARTY_NUMBER
, TPM. PANEL_MEMBER_TYPE
, DECODE(NVL(TPM.CONFIRMED_DT
, SYSDATE)
, SYSDATE
, 'N'
, 'Y') CONFIRMED_IND
, TPM.CONFIRMED_DT
, DECODE(NVL(TPM.DECLINED_DT
, SYSDATE)
, SYSDATE
, 'N'
, 'Y') DECLINED_IND
, TPM. DECLINED_DT
, TPM. ANONYMITY_IND
, TPM. THESIS_RESULT_CD
, TPM.PAID_DT
, TPM. TRACKING_ID
, TPM.CREATED_BY
, TPM.CREATION_DATE
, TPM.LAST_UPDATED_BY
, TPM.LAST_UPDATE_DATE
, TPM.LAST_UPDATE_LOGIN
, TPM. RECOMMENDATION_SUMMARY
FROM IGS_RE_THS_PNL_MBR TPM
, HZ_PARTIES PE
WHERE TPM.PERSON_ID = PE.PARTY_ID