PAY_GENERIC_ANA_TYPES_VL

Details

• Schema: FUSION

• Object owner: PAY

• Object type: VIEW

Columns

Name
PAY_GEN_ANA_TYPE_ID BASE_GEN_ANA_TYPE ANALYTICS_CATEGORY LEGISLATIVE_DATA_GROUP_ID LEGISLATION_CODE METHOD_TYPE METHOD SEED_DATA_SOURCE CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATE_LOGIN LAST_UPDATED_BY MODULE_ID ENTERPRISE_ID OBJECT_VERSION_NUMBER GEN_ANA_TYPE_NAME DESCRIPTION

Query

SQL_Statement

SELECT pgat.PAY_GEN_ANA_TYPE_ID PAY_GEN_ANA_TYPE_ID, pgat.BASE_GEN_ANA_TYPE BASE_GEN_ANA_TYPE, pgat.ANALYTICS_CATEGORY ANALYTICS_CATEGORY, pgat.LEGISLATIVE_DATA_GROUP_ID LEGISLATIVE_DATA_GROUP_ID, pgat.LEGISLATION_CODE LEGISLATION_CODE, pgat.METHOD_TYPE METHOD_TYPE, pgat.METHOD METHOD, pgat.SEED_DATA_SOURCE SEED_DATA_SOURCE, pgat.CREATED_BY CREATED_BY, pgat.CREATION_DATE CREATION_DATE, pgat.LAST_UPDATE_DATE LAST_UPDATE_DATE, pgat.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, pgat.LAST_UPDATED_BY LAST_UPDATED_BY, pgat.MODULE_ID MODULE_ID, pgat.ENTERPRISE_ID ENTERPRISE_ID, pgat.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, pgattl.GEN_ANA_TYPE_NAME GEN_ANA_TYPE_NAME, pgattl.DESCRIPTION DESCRIPTION FROM PAY_GENERIC_ANA_TYPES pgat, PAY_GENERIC_ANA_TYPES_TL pgattl WHERE pgat.PAY_GEN_ANA_TYPE_ID = pgattl.PAY_GEN_ANA_TYPE_ID AND pgattl.LANGUAGE = USERENV('LANG')