Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This view is created by joining table IGS_FI_BALANCE_RULES and IGS_LOOKUPS_VIEW to obtain meaning of lookup codes for Balance Types. |
Implementation/DBA Data: | Not implemented in this database |
SELECT BALRULE.ROWID
, BALRULE.BALANCE_RULE_ID
, BALRULE.BALANCE_NAME
, LKV.MEANING
, LKV.DESCRIPTION
, BALRULE.VERSION_NUMBER
, BALRULE.EFFECTIVE_START_DATE
, BALRULE.EFFECTIVE_END_DATE
, BALRULE.EXCLUDE_TXN_DATE_LOW
, BALRULE.EXCLUDE_TXN_DATE_HIGH
, BALRULE.EXCLUDE_EFF_DATE_LOW
, BALRULE.EXCLUDE_EFF_DATE_HIGH
, BALRULE.LAST_UPDATED_BY
, BALRULE.LAST_UPDATE_DATE
, BALRULE.LAST_UPDATE_LOGIN
, BALRULE.CREATED_BY
, BALRULE.CREATION_DATE
, BALRULE.LAST_CONVERSION_DATE
FROM IGS_FI_BALANCE_RULES BALRULE
, IGS_LOOKUPS_VIEW LKV
WHERE BALRULE.BALANCE_NAME = LKV.LOOKUP_CODE
AND LKV.LOOKUP_TYPE = 'IGS_FI_BALANCE_TYPE'
AND BALRULE.BALANCE_NAME <> 'STANDARD'