PER_ALLOC_TASK_COM_CONDNS_VL

Details

• Schema: FUSION

• Object owner: PER

• Object type: VIEW

Columns

Name

ALLOC_TASK_COM_CONDITION_ID ALLOCATED_TASK_ID TASK_COM_CONDITION_ID MESSAGE_TEXT BUSINESS_OBJECT_NAME ENABLED_FLAG BUSINESS_OBJECT_CRITERIA1 BUSINESS_OBJECT_CRITERIA2 BUSINESS_OBJECT_CRITERIA3 BUSINESS_OBJECT_CRITERIA4 BUSINESS_OBJECT_CRITERIA5 ROW_COUNT_LOWER_LIMIT ROW_COUNT_UPPER_LIMIT PERSON_CRITERIA1 PERSON_CRITERIA2 PERSON_CRITERIA3 PERSON_CRITERIA4 PERSON_CRITERIA5 ENTERPRISE_ID OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT B.ALLOC_TASK_COM_CONDITION_ID, B.ALLOCATED_TASK_ID, B.TASK_COM_CONDITION_ID, T.MESSAGE_TEXT, B.BUSINESS_OBJECT_NAME, B.ENABLED_FLAG, B.BUSINESS_OBJECT_CRITERIA1, B.BUSINESS_OBJECT_CRITERIA2, B.BUSINESS_OBJECT_CRITERIA3, B.BUSINESS_OBJECT_CRITERIA4, B.BUSINESS_OBJECT_CRITERIA5, B.ROW_COUNT_LOWER_LIMIT, B.ROW_COUNT_UPPER_LIMIT, B.PERSON_CRITERIA1, B.PERSON_CRITERIA2, B.PERSON_CRITERIA3, B.PERSON_CRITERIA4, B.PERSON_CRITERIA5, B.ENTERPRISE_ID, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN FROM PER_ALLOC_TASK_COM_CONDNS_B B, PER_ALLOC_TASK_COM_CONDNS_TL T WHERE B.ALLOC_TASK_COM_CONDITION_ID = T.ALLOC_TASK_COM_CONDITION_ID AND T.LANGUAGE = USERENV('LANG')