[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | A supplementary view used to simplify forms coding. |
| Implementation/DBA Data: | Not implemented in this database |
SELECT FTCI.ROWID
, FTCI.ACCT_ID
, FTCI.FEE_TYPE
, FTCI.FEE_CAL_TYPE
, FTCI.FEE_CI_SEQUENCE_NUMBER
, FTCI.ORDER_SEQUENCE
, FTCI.NATURAL_ACCOUNT_SEGMENT
, FTCI.REV_ACCOUNT_CD
, FTCI.LOCATION_CD
, FTCI.ATTENDANCE_TYPE
, FTCI.ATTENDANCE_MODE
, FTCI.COURSE_CD
, FTCI.CRS_VERSION_NUMBER
, FTCI.UNIT_CD
, FTCI.UNIT_VERSION_NUMBER
, FTCI.ORG_UNIT_CD
, FTCI.RESIDENCY_STATUS_CD
, LKP.MEANING
, FTCI.UOO_ID
, IGS_FI_GEN_APINT.GET_UNIT_SECTION_DESC(FTCI.UOO_ID
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL)
, FTCI.UNIT_LEVEL
, FTCI.UNIT_TYPE_ID
, PUT.LEVEL_CODE
, FTCI.UNIT_CLASS
, FTCI.UNIT_MODE
, FTCI.CREATED_BY
, FTCI.CREATION_DATE
, FTCI.LAST_UPDATED_BY
, FTCI.LAST_UPDATE_DATE
, FTCI.LAST_UPDATE_LOGIN
, FTCI.REQUEST_ID
, FTCI.PROGRAM_APPLICATION_ID
, FTCI.PROGRAM_ID
, FTCI.PROGRAM_UPDATE_DATE
FROM IGS_FI_FTCI_ACCTS FTCI
, IGS_LOOKUP_VALUES LKP
, IGS_PS_UNIT_TYPE_LVL PUT
WHERE FTCI.RESIDENCY_STATUS_CD = LKP.LOOKUP_CODE (+)
AND LKP.LOOKUP_TYPE (+) = 'PE_RES_STATUS'
AND FTCI.UNIT_TYPE_ID = PUT.UNIT_TYPE_ID (+)