PAY_TASK_PROPERTIES

Details

Schema: FUSION
Object owner: PAY
Object type: VIEW

Columns

Name
TASK_PROPERTY_ID BASE_TASK_PROPERTY_ID BASE_TASK_PROPERTY_NAME OBJECT_VERSION_NUMBER MODULE_ID BASE_TASK_ACTION_ID TASK_PROPERTY_TYPE TASK_PROPERTY_VALUE LEGISLATIVE_DATA_GROUP_ID LEGISLATION_CODE ENTERPRISE_ID ADDNL_PROPERTY_INFO LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CREATED_BY CREATION_DATE TASK_PROPERTY_NAME TASK_PROPERTY_DESC SGUID

Name

TASK_PROPERTY_ID

BASE_TASK_PROPERTY_ID

BASE_TASK_PROPERTY_NAME

OBJECT_VERSION_NUMBER

MODULE_ID

BASE_TASK_ACTION_ID

TASK_PROPERTY_TYPE

TASK_PROPERTY_VALUE

LEGISLATIVE_DATA_GROUP_ID

LEGISLATION_CODE

ENTERPRISE_ID

ADDNL_PROPERTY_INFO

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

CREATED_BY

CREATION_DATE

TASK_PROPERTY_NAME

TASK_PROPERTY_DESC

SGUID

Query

SQL_Statement
SELECT B.TASK_PROPERTY_ID, B.BASE_TASK_PROPERTY_ID, B.BASE_TASK_PROPERTY_NAME, B.OBJECT_VERSION_NUMBER, B.MODULE_ID, B.BASE_TASK_ACTION_ID, B.TASK_PROPERTY_TYPE, B.TASK_PROPERTY_VALUE, B.LEGISLATIVE_DATA_GROUP_ID, B.LEGISLATION_CODE, B.ENTERPRISE_ID, B.ADDNL_PROPERTY_INFO, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN, B.CREATED_BY, B.CREATION_DATE, TL.TASK_PROPERTY_NAME, TL.TASK_PROPERTY_DESC, B.SGUID SGUID FROM PAY_TASK_PROPERTIES B, PAY_TASK_PROPERTIES_TL TL WHERE B.TASK_PROPERTY_ID = TL.TASK_PROPERTY_ID AND USERENV('LANG') = TL.LANGUAGE

SQL_Statement

SELECT

B.TASK_PROPERTY_ID,

B.BASE_TASK_PROPERTY_ID,

B.BASE_TASK_PROPERTY_NAME,

B.OBJECT_VERSION_NUMBER,

B.MODULE_ID,

B.BASE_TASK_ACTION_ID,

B.TASK_PROPERTY_TYPE,

B.TASK_PROPERTY_VALUE,

B.LEGISLATIVE_DATA_GROUP_ID,

B.LEGISLATION_CODE,

B.ENTERPRISE_ID,

B.ADDNL_PROPERTY_INFO,

B.LAST_UPDATE_DATE,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_LOGIN,

B.CREATED_BY,

B.CREATION_DATE,

TL.TASK_PROPERTY_NAME,

TL.TASK_PROPERTY_DESC,

B.SGUID SGUID

FROM

PAY_TASK_PROPERTIES B,

PAY_TASK_PROPERTIES_TL TL

WHERE

B.TASK_PROPERTY_ID = TL.TASK_PROPERTY_ID AND USERENV('LANG') = TL.LANGUAGE