PAY_TMPLT_RULE_GROUPS_VL

Details

• Schema: FUSION

• Object owner: PAY

• Object type: VIEW

Columns

Name
RULE_GROUP_ID BASE_RULE_GROUP_NAME GROUP_TEXT OBJECT_VERSION_NUMBER LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CREATED_BY CREATION_DATE GROUP_LOCATION TEMPLATE_ID LEGISLATIVE_DATA_GROUP_ID LEGISLATION_CODE ENTERPRISE_ID MODULE_ID SGUID

Query

SQL_Statement

SELECT PTRG.RULE_GROUP_ID RULE_GROUP_ID, PTRG.BASE_RULE_GROUP_NAME BASE_RULE_GROUP_NAME, PTRGTL.GROUP_TEXT GROUP_TEXT, PTRG.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PTRG.LAST_UPDATE_DATE LAST_UPDATE_DATE, PTRG.LAST_UPDATED_BY LAST_UPDATED_BY, PTRG.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PTRG.CREATED_BY CREATED_BY, PTRG.CREATION_DATE CREATION_DATE, PTRG.GROUP_LOCATION, PTRG.TEMPLATE_ID, PTRG.LEGISLATIVE_DATA_GROUP_ID, PTRG.LEGISLATION_CODE, PTRG.ENTERPRISE_ID, PTRG.MODULE_ID, PTRG.SGUID SGUID FROM PAY_TMPLT_RULE_GROUPS PTRG, PAY_TMPLT_RULE_GROUPS_TL PTRGTL WHERE PTRG.RULE_GROUP_ID = PTRGTL.RULE_GROUP_ID AND PTRGTL.LANGUAGE = USERENV('LANG')