HRC_TXN_RULESET_VL

Details

• Schema: FUSION

• Object owner: HRC

• Object type: VIEW

Columns

Name
TXN_RULESET_ID MODULE_IDENTIFIER RULESET_CODE SUB_MODULE_IDENTIFIER ACTIVE PROCESS_ID ENTERPRISE_ID MODULE_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER RULESET_NAME DESCRIPTION

Query

SQL_Statement

SELECT HTR.TXN_RULESET_ID TXN_RULESET_ID, HTR.MODULE_IDENTIFIER MODULE_IDENTIFIER, HTR.RULESET_CODE RULESET_CODE, HTR.SUB_MODULE_IDENTIFIER SUB_MODULE_IDENTIFIER, HTR.ACTIVE ACTIVE, HTR.PROCESS_ID PROCESS_ID, 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.RULESET_NAME, HTRT.DESCRIPTION FROM HRC_TXN_RULESET HTR, HRC_TXN_RULESET_TL HTRT WHERE HTR.TXN_RULESET_ID =HTRT.TXN_RULESET_ID AND HTRT.LANGUAGE = USERENV('LANG')