HRC_TXN_RULES_VL

Details

• Schema: FUSION

• Object owner: HRC

• Object type: VIEW

Columns

Name
TXN_RULESET_ID RULES_LEVEL TXN_RULE_ID RULE_CODE ACTIVE ROUTE_USING ROUTING_TYPE CRITERIA RULESET_CODE ENTERPRISE_ID MODULE_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER RULENAME DESCRIPTION

Query

SQL_Statement

SELECT HTR.TXN_RULESET_ID TXN_RULESET_ID, HTR.RULES_LEVEL RULES_LEVEL, HTR.TXN_RULE_ID TXN_RULE_ID, HTR.RULE_CODE RULE_CODE , HTR.ACTIVE ACTIVE, HTR.ROUTE_USING ROUTE_USING, HTR.ROUTING_TYPE ROUTING_TYPE, HTR.CRITERIA CRITERIA, HTR.RULESET_CODE RULESET_CODE, HTR.ENTERPRISE_ID ENTERPRISE_ID, HTR.MODULE_ID MODULE_ID, HTR.CREATED_BY CREATED_BY, HTR.CREATION_DATE CREATION_DATE, HTR.LAST_UPDATED_BY LAST_UPDATED_BY, HTR.LAST_UPDATE_DATE LAST_UPDATE_DATE, HTR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, HTR.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, HTRT.RULENAME RULENAME , HTRT.DESCRIPTION DESCRIPTION FROM HRC_TXN_RULES HTR, HRC_TXN_RULES_TL HTRT WHERE HTR.TXN_RULE_ID =HTRT.TXN_RULE_ID AND HTRT.LANGUAGE = USERENV('LANG')