[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 |