PAY_REPORT_CATEGORIES_VL

Details

• Schema: FUSION

• Object owner: PAY

• Object type: VIEW

Columns

Name
REPORT_CATEGORY_ID REPORT_GROUP_ID BASE_CATEGORY_NAME SHORT_NAME LEGISLATION_CODE LEGISLATIVE_DATA_GROUP_ID ENTERPRISE_ID MODULE_ID CATEGORY_NAME DESCRIPTION LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN CREATED_BY CREATION_DATE OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT PAY_REPORT_CATEGORIES.REPORT_CATEGORY_ID REPORT_CATEGORY_ID, PAY_REPORT_CATEGORIES.REPORT_GROUP_ID REPORT_GROUP_ID, PAY_REPORT_CATEGORIES.base_CATEGORY_NAME BASE_CATEGORY_NAME, PAY_REPORT_CATEGORIES.SHORT_NAME SHORT_NAME, PAY_REPORT_CATEGORIES.LEGISLATION_CODE LEGISLATION_CODE, PAY_REPORT_CATEGORIES.LEGISLATIVE_DATA_GROUP_ID LEGISLATIVE_DATA_GROUP_ID, PAY_REPORT_CATEGORIES.ENTERPRISE_ID ENTERPRISE_ID, PAY_REPORT_CATEGORIES.MODULE_ID MODULE_ID, PAY_REPORT_CATEGORIES_TL.CATEGORY_NAME CATEGORY_NAME, PAY_REPORT_CATEGORIES_TL.DESCRIPTION DESCRIPTION, PAY_REPORT_CATEGORIES.LAST_UPDATED_BY LAST_UPDATED_BY, PAY_REPORT_CATEGORIES.LAST_UPDATE_DATE LAST_UPDATE_DATE, PAY_REPORT_CATEGORIES.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PAY_REPORT_CATEGORIES.CREATED_BY CREATED_BY, PAY_REPORT_CATEGORIES.CREATION_DATE CREATION_DATE, PAY_REPORT_CATEGORIES.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER FROM PAY_REPORT_CATEGORIES , PAY_REPORT_CATEGORIES_TL where pay_report_categories.REPORT_category_ID = pay_report_categories_tl.REPORT_category_ID AND pay_report_categories_tl.LANGUAGE = USERENV('LANG')