PER_TASK_LIB_COM_CONDNS_VL

Details

• Schema: FUSION

• Object owner: PER

• Object type: VIEW

Columns

Name

TASK_LIB_COM_CONDITION_ID CHECKLIST_TASK_ID BUSINESS_OBJECT_NAME ENABLED_FLAG MESSAGE_TEXT 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 PERSON_RULE_ID OBJECT_RULE_ID ENTERPRISE_ID OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT B.TASK_LIB_COM_CONDITION_ID, B.CHECKLIST_TASK_ID, B.BUSINESS_OBJECT_NAME, B.ENABLED_FLAG, T.MESSAGE_TEXT, 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.PERSON_RULE_ID, B.OBJECT_RULE_ID, 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_TASK_LIB_COM_CONDNS_B B, PER_TASK_LIB_COM_CONDNS_TL T WHERE B.TASK_LIB_COM_CONDITION_ID = T.TASK_LIB_COM_CONDITION_ID AND T.LANGUAGE = USERENV('LANG')