VIEW: APPS.IGS_FI_APP_RULES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'