VIEW: APPS.IGS_FI_SUB_ER_RT_V

Source

View Text - Preformatted

SELECT SERT.ROWID ,SERT.SUB_ERR_ID ,SERT.SUB_ER_ID ,SERT.FAR_ID ,FAR.RATE_NUMBER ,FAR.CHG_RATE ,FAR.LOCATION_CD ,FAR.ATTENDANCE_TYPE ,FAR.ATTENDANCE_MODE ,FAR.CLASS_STANDING ,FAR.COURSE_CD ,FAR.VERSION_NUMBER ,HP.PARTY_NUMBER ,FAR.RESIDENCY_STATUS_CD ,FAR.UNIT_SET_CD ,FAR.US_VERSION_NUMBER ,SERT.CREATE_DATE ,SERT.LOGICAL_DELETE_DATE ,SERT.CREATED_BY ,SERT.CREATION_DATE ,SERT.LAST_UPDATE_DATE ,SERT.LAST_UPDATED_BY ,SERT.LAST_UPDATE_LOGIN ,FAR.UNIT_CD ,FAR.UNIT_VERSION_NUMBER ,FAR.UNIT_LEVEL ,FAR.UNIT_TYPE_ID ,UTL.LEVEL_CODE ,FAR.UNIT_MODE ,FAR.UNIT_CLASS FROM IGS_FI_SUB_ER_RT SERT, IGS_FI_FEE_AS_RATE FAR, HZ_PARTIES HP, IGS_PS_UNIT_TYPE_LVL UTL WHERE SERT.FAR_ID = FAR.FAR_ID AND FAR.ORG_PARTY_ID = HP.PARTY_ID(+) AND FAR.UNIT_TYPE_ID = UTL.UNIT_TYPE_ID (+)

View Text - HTML Formatted

SELECT SERT.ROWID
, SERT.SUB_ERR_ID
, SERT.SUB_ER_ID
, SERT.FAR_ID
, FAR.RATE_NUMBER
, FAR.CHG_RATE
, FAR.LOCATION_CD
, FAR.ATTENDANCE_TYPE
, FAR.ATTENDANCE_MODE
, FAR.CLASS_STANDING
, FAR.COURSE_CD
, FAR.VERSION_NUMBER
, HP.PARTY_NUMBER
, FAR.RESIDENCY_STATUS_CD
, FAR.UNIT_SET_CD
, FAR.US_VERSION_NUMBER
, SERT.CREATE_DATE
, SERT.LOGICAL_DELETE_DATE
, SERT.CREATED_BY
, SERT.CREATION_DATE
, SERT.LAST_UPDATE_DATE
, SERT.LAST_UPDATED_BY
, SERT.LAST_UPDATE_LOGIN
, FAR.UNIT_CD
, FAR.UNIT_VERSION_NUMBER
, FAR.UNIT_LEVEL
, FAR.UNIT_TYPE_ID
, UTL.LEVEL_CODE
, FAR.UNIT_MODE
, FAR.UNIT_CLASS
FROM IGS_FI_SUB_ER_RT SERT
, IGS_FI_FEE_AS_RATE FAR
, HZ_PARTIES HP
, IGS_PS_UNIT_TYPE_LVL UTL
WHERE SERT.FAR_ID = FAR.FAR_ID
AND FAR.ORG_PARTY_ID = HP.PARTY_ID(+)
AND FAR.UNIT_TYPE_ID = UTL.UNIT_TYPE_ID (+)