VIEW: APPS.IGS_EN_SPI_RCONDS_V

Source

View Text - Preformatted

SELECT SRC.ROWID, SRC.PERSON_ID, SRC.COURSE_CD, SRC.START_DT, SRC.LOGICAL_DELETE_DATE, SRC.RETURN_CONDITION, SRC.STATUS_CODE, lk.meaning, APPROVED_DT, APPROVED_BY, SRC.CREATED_BY, SRC.CREATION_DATE, SRC.LAST_UPDATED_BY, SRC.LAST_UPDATE_DATE, SRC.LAST_UPDATE_LOGIN, RC.DESCRIPTION RETURN_CONDITION_DESC, H.PARTY_NUMBER APPROVER_NUMBER, H.PARTY_NAME FROM IGS_EN_SPI_RCONDS SRC, HZ_PARTIES H, IGS_EN_INTM_RCONDS RC, IGS_LOOKUP_VALUES lk WHERE SRC.APPROVED_BY = H.PARTY_ID(+) AND RC.RETURN_CONDITION = SRC.RETURN_CONDITION AND lk.lookup_type = 'IGS_EN_INTM_RCOND_STS' AND src.status_code = lk.lookup_code

View Text - HTML Formatted

SELECT SRC.ROWID
, SRC.PERSON_ID
, SRC.COURSE_CD
, SRC.START_DT
, SRC.LOGICAL_DELETE_DATE
, SRC.RETURN_CONDITION
, SRC.STATUS_CODE
, LK.MEANING
, APPROVED_DT
, APPROVED_BY
, SRC.CREATED_BY
, SRC.CREATION_DATE
, SRC.LAST_UPDATED_BY
, SRC.LAST_UPDATE_DATE
, SRC.LAST_UPDATE_LOGIN
, RC.DESCRIPTION RETURN_CONDITION_DESC
, H.PARTY_NUMBER APPROVER_NUMBER
, H.PARTY_NAME
FROM IGS_EN_SPI_RCONDS SRC
, HZ_PARTIES H
, IGS_EN_INTM_RCONDS RC
, IGS_LOOKUP_VALUES LK
WHERE SRC.APPROVED_BY = H.PARTY_ID(+)
AND RC.RETURN_CONDITION = SRC.RETURN_CONDITION
AND LK.LOOKUP_TYPE = 'IGS_EN_INTM_RCOND_STS'
AND SRC.STATUS_CODE = LK.LOOKUP_CODE