PAY_ELE_TMPLT_CLASS_USAGES

Details

Schema: FUSION
Object owner: PAY
Object type: VIEW

Columns

Name
ELE_TEMPLATE_CLASSIFICATION_ID CLASSIFICATION_ID SECONDARY_CLASSIFICATION_ID CATEGORY BASE_CALCULATION_RULE_NAME TEMPLATE_ID MODULE_ID LEGISLATIVE_DATA_GROUP_ID LEGISLATION_CODE ENTERPRISE_ID OBJECT_VERSION_NUMBER LAST_UPDATE_DATE LAST_UPDATE_LOGIN LAST_UPDATED_BY CREATION_DATE CREATED_BY CALCULATION_RULE_NAME TEMPLATE_CATEGORY SGUID PAYROLL_LICENSE

Name

ELE_TEMPLATE_CLASSIFICATION_ID

CLASSIFICATION_ID

SECONDARY_CLASSIFICATION_ID

Query

SQL_Statement
SELECT PAY_ELE_TMPLT_CLASS_USAGES.ELE_TEMPLATE_CLASSIFICATION_ID ELE_TEMPLATE_CLASSIFICATION_ID, PAY_ELE_TMPLT_CLASS_USAGES.CLASSIFICATION_ID CLASSIFICATION_ID, PAY_ELE_TMPLT_CLASS_USAGES.SECONDARY_CLASSIFICATION_ID SECONDARY_CLASSIFICATION_ID, PAY_ELE_TMPLT_CLASS_USAGES.CATEGORY CATEGORY, PAY_ELE_TMPLT_CLASS_USAGES.BASE_CALCULATION_RULE_NAME BASE_CALCULATION_RULE_NAME, PAY_ELE_TMPLT_CLASS_USAGES.TEMPLATE_ID TEMPLATE_ID, PAY_ELE_TMPLT_CLASS_USAGES.MODULE_ID MODULE_ID, PAY_ELE_TMPLT_CLASS_USAGES.LEGISLATIVE_DATA_GROUP_ID LEGISLATIVE_DATA_GROUP_ID, PAY_ELE_TMPLT_CLASS_USAGES.LEGISLATION_CODE LEGISLATION_CODE, PAY_ELE_TMPLT_CLASS_USAGES.ENTERPRISE_ID ENTERPRISE_ID, PAY_ELE_TMPLT_CLASS_USAGES.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PAY_ELE_TMPLT_CLASS_USAGES.LAST_UPDATE_DATE LAST_UPDATE_DATE, PAY_ELE_TMPLT_CLASS_USAGES.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PAY_ELE_TMPLT_CLASS_USAGES.LAST_UPDATED_BY LAST_UPDATED_BY, PAY_ELE_TMPLT_CLASS_USAGES.CREATION_DATE CREATION_DATE, PAY_ELE_TMPLT_CLASS_USAGES.CREATED_BY CREATED_BY, PAY_ELE_TMPLT_CLASS_USAGES_TL.CALCULATION_RULE_NAME CALCULATION_RULE_NAME, PAY_ELE_TMPLT_CLASS_USAGES_TL.TEMPLATE_CATEGORY TEMPLATE_CATEGORY, PAY_ELE_TMPLT_CLASS_USAGES.SGUID SGUID, PAY_ELE_TMPLT_CLASS_USAGES.PAYROLL_LICENSE FROM PAY_ELE_TMPLT_CLASS_USAGES, PAY_ELE_TMPLT_CLASS_USAGES_TL WHERE PAY_ELE_TMPLT_CLASS_USAGES.ELE_TEMPLATE_CLASSIFICATION_ID = PAY_ELE_TMPLT_CLASS_USAGES_TL.ELE_TEMPLATE_CLASSIFICATION_ID AND PAY_ELE_TMPLT_CLASS_USAGES_TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

PAY_ELE_TMPLT_CLASS_USAGES.ELE_TEMPLATE_CLASSIFICATION_ID ELE_TEMPLATE_CLASSIFICATION_ID,

PAY_ELE_TMPLT_CLASS_USAGES.CLASSIFICATION_ID CLASSIFICATION_ID,

PAY_ELE_TMPLT_CLASS_USAGES.SECONDARY_CLASSIFICATION_ID SECONDARY_CLASSIFICATION_ID,

PAY_ELE_TMPLT_CLASS_USAGES.CATEGORY CATEGORY,

PAY_ELE_TMPLT_CLASS_USAGES.BASE_CALCULATION_RULE_NAME BASE_CALCULATION_RULE_NAME,

PAY_ELE_TMPLT_CLASS_USAGES.TEMPLATE_ID TEMPLATE_ID,

PAY_ELE_TMPLT_CLASS_USAGES.MODULE_ID MODULE_ID,

PAY_ELE_TMPLT_CLASS_USAGES.LEGISLATIVE_DATA_GROUP_ID LEGISLATIVE_DATA_GROUP_ID,

PAY_ELE_TMPLT_CLASS_USAGES.LEGISLATION_CODE LEGISLATION_CODE,

PAY_ELE_TMPLT_CLASS_USAGES.ENTERPRISE_ID ENTERPRISE_ID,

PAY_ELE_TMPLT_CLASS_USAGES.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

PAY_ELE_TMPLT_CLASS_USAGES.LAST_UPDATE_DATE LAST_UPDATE_DATE,

PAY_ELE_TMPLT_CLASS_USAGES.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

PAY_ELE_TMPLT_CLASS_USAGES.LAST_UPDATED_BY LAST_UPDATED_BY,

PAY_ELE_TMPLT_CLASS_USAGES.CREATION_DATE CREATION_DATE,

PAY_ELE_TMPLT_CLASS_USAGES.CREATED_BY CREATED_BY,

PAY_ELE_TMPLT_CLASS_USAGES_TL.CALCULATION_RULE_NAME CALCULATION_RULE_NAME,

PAY_ELE_TMPLT_CLASS_USAGES_TL.TEMPLATE_CATEGORY TEMPLATE_CATEGORY,

PAY_ELE_TMPLT_CLASS_USAGES.SGUID SGUID,

PAY_ELE_TMPLT_CLASS_USAGES.PAYROLL_LICENSE

FROM

PAY_ELE_TMPLT_CLASS_USAGES,

PAY_ELE_TMPLT_CLASS_USAGES_TL

WHERE

PAY_ELE_TMPLT_CLASS_USAGES.ELE_TEMPLATE_CLASSIFICATION_ID = PAY_ELE_TMPLT_CLASS_USAGES_TL.ELE_TEMPLATE_CLASSIFICATION_ID AND PAY_ELE_TMPLT_CLASS_USAGES_TL.LANGUAGE = USERENV('LANG')