[Home] [Help]
View: IGS_FI_BAL_EX_F_TYPS_V
Product: | IGS - Student System (Obsolete) |
Description: | This view is created by joining table IGS_FI_BAL_EX_F_TYPS and view IGS_FI_FEE_TYPE to obtain Fee Type Description by resolving foreign keys. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT BALFEE.ROWID
, BALFEE.BAL_EXC_FEE_TYPE_ID
, BALFEE.BALANCE_RULE_ID
, BALFEE.FEE_TYPE
, FEE.DESCRIPTION
, BALFEE.ENABLED_FLAG
, BALFEE.LAST_UPDATED_BY
, BALFEE.LAST_UPDATE_DATE
, BALFEE.LAST_UPDATE_LOGIN
, BALFEE.CREATED_BY
, BALFEE.CREATION_DATE
FROM IGS_FI_BAL_EX_F_TYPS BALFEE
, IGS_FI_FEE_TYPE FEE
WHERE BALFEE.FEE_TYPE = FEE.FEE_TYPE
AND FEE.CLOSED_IND = 'N'
Columns
Name |
ROW_ID |
BAL_EXC_FEE_TYPE_ID |
BALANCE_RULE_ID |
FEE_TYPE |
DESCRIPTION |
ENABLED_FLAG |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |
CREATED_BY |
CREATION_DATE |