PAY_GENERIC_ANA_ATT_DEFS_VL

Details

• Schema: FUSION

• Object owner: PAY

• Object type: VIEW

Columns

Name
PAY_GEN_ANA_ATTDEF_ID PAY_GEN_ANA_TYPE_ID BASE_ATTRDEF_NAME DATA_COLUMN DISPLAY_SEQUENCE DISPLAY_LABEL SEED_DATA_SOURCE CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATE_LOGIN LAST_UPDATED_BY MODULE_ID ENTERPRISE_ID OBJECT_VERSION_NUMBER PAY_GEN_ANA_ATTDEF_NAME DESCRIPTION

Query

SQL_Statement

SELECT pgaad.PAY_GEN_ANA_ATTDEF_ID PAY_GEN_ANA_ATTDEF_ID, pgaad.PAY_GEN_ANA_TYPE_ID PAY_GEN_ANA_TYPE_ID, pgaad.BASE_ATTRDEF_NAME BASE_ATTRDEF_NAME, pgaad.DATA_COLUMN DATA_COLUMN, pgaad.DISPLAY_SEQUENCE DISPLAY_SEQUENCE, pgaad.DISPLAY_LABEL DISPLAY_LABEL, pgaad.SEED_DATA_SOURCE SEED_DATA_SOURCE, pgaad.CREATED_BY CREATED_BY, pgaad.CREATION_DATE CREATION_DATE, pgaad.LAST_UPDATE_DATE LAST_UPDATE_DATE, pgaad.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, pgaad.LAST_UPDATED_BY LAST_UPDATED_BY, pgaad.MODULE_ID MODULE_ID, pgaad.ENTERPRISE_ID ENTERPRISE_ID, pgaad.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, pgaadtl.PAY_GEN_ANA_ATTDEF_NAME PAY_GEN_ANA_ATTDEF_NAME, pgaadtl.DESCRIPTION DESCRIPTION FROM PAY_GENERIC_ANA_ATT_DEFS pgaad, PAY_GENERIC_ANA_ATT_DEFS_TL pgaadtl WHERE pgaad.PAY_GEN_ANA_ATTDEF_ID = pgaadtl.PAY_GEN_ANA_ATTDEF_ID AND pgaadtl.LANGUAGE = USERENV('LANG')