[Home] [Help]
View: IGS_FI_APP_RULES_V
Product: | IGS - Student System (Obsolete) |
Description: | This view selects those records from the Application Hierarchy Rules table that are of Rule type 'ALLOW' only |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT AHR.ROWID
, AHR.APPL_RULE_ID
, AHR.APPL_HIERARCHY_ID
, AHR.RULE_SEQUENCE
, AHR.FEE_TYPE
, FEE.DESCRIPTION
, AHR.RULE_TYPE
, LKP.MEANING
, AHR.ENABLED_FLAG
, AHR.CREATED_BY
, AHR.CREATION_DATE
, AHR.LAST_UPDATED_BY
, AHR.LAST_UPDATE_DATE
, AHR.LAST_UPDATE_LOGIN
FROM IGS_FI_APP_RULES AHR
, IGS_FI_A_HIERARCHIES AH
, IGS_FI_FEE_TYPE FEE
, IGS_LOOKUPS_VIEW LKP
WHERE AHR.APPL_HIERARCHY_ID = AH.APPL_HIERARCHY_ID
AND AHR.FEE_TYPE = FEE.FEE_TYPE
AND LKP.LOOKUP_TYPE = 'IGS_FI_RULE_TYPE'
AND LKP.LOOKUP_CODE = AHR.RULE_TYPE
AND LKP.LOOKUP_CODE = 'ALLOW'
Columns
Name |
ROW_ID |
APPL_RULE_ID |
APPL_HIERARCHY_ID |
RULE_SEQUENCE |
FEE_TYPE |
DESCRIPTION |
RULE_TYPE |
RULE_TYPE_DESC |
ENABLED_FLAG |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |