IEX_STRY_TEMP_WORK_ITEMS

Details

Schema: FUSION
Object owner: IEX
Object type: VIEW

Columns

Name
WORK_ITEM_TEMP_ID COMPETENCE_ID OPTIONAL_YN OPTION_WAIT_TIME OPTION_WAIT_TIME_UOM PRE_EXECUTION_WAIT POST_EXECUTION_WAIT EXECUTION_TIME_UOM WORKFLOW_ITEM_TYPE SAME_RESOURCE_YN LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY PROGRAM_ID OBJECT_VERSION_NUMBER REQUEST_ID PROGRAM_APPLICATION_ID PROGRAM_UPDATE_DATE SECURITY_GROUP_ID FULFIL_TEMP_ID XDO_TEMPLATE_ID ESCALATE_YN NOTIFY_YN NAME DESCRIPTION WORK_TYPE CATEGORY_TYPE PRIORITY_TYPE CALLBACK_WAIT CALLBACK_UOM CLOSURE_TIME_LIMIT CLOSURE_TIME_UOM SCHEDULE_WAIT SCHEDULE_UOM ENABLED_FLAG SOURCE_LANG LANGUAGE TEMPLATE_NAME FULFIL_TEMP_NAME TRX_LEVEL_FLAG EXECUTION_CONDITION_CODE EXECUTION_CONDITION_OPERATOR EXECUTION_CONDITION_VALUE

Name

WORK_ITEM_TEMP_ID

COMPETENCE_ID

OPTIONAL_YN

OPTION_WAIT_TIME

OPTION_WAIT_TIME_UOM

PRE_EXECUTION_WAIT

POST_EXECUTION_WAIT

EXECUTION_TIME_UOM

WORKFLOW_ITEM_TYPE

SAME_RESOURCE_YN

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

CREATION_DATE

CREATED_BY

PROGRAM_ID

OBJECT_VERSION_NUMBER

REQUEST_ID

PROGRAM_APPLICATION_ID

PROGRAM_UPDATE_DATE

SECURITY_GROUP_ID

FULFIL_TEMP_ID

XDO_TEMPLATE_ID

ESCALATE_YN

NOTIFY_YN

NAME

DESCRIPTION

WORK_TYPE

CATEGORY_TYPE

PRIORITY_TYPE

CALLBACK_WAIT

CALLBACK_UOM

CLOSURE_TIME_LIMIT

CLOSURE_TIME_UOM

SCHEDULE_WAIT

SCHEDULE_UOM

ENABLED_FLAG

SOURCE_LANG

LANGUAGE

TEMPLATE_NAME

FULFIL_TEMP_NAME

TRX_LEVEL_FLAG

EXECUTION_CONDITION_CODE

EXECUTION_CONDITION_OPERATOR

EXECUTION_CONDITION_VALUE

Query

SQL_Statement
SELECT B.WORK_ITEM_TEMP_ID, B.COMPETENCE_ID, B.OPTIONAL_YN, B.OPTION_WAIT_TIME, B.OPTION_WAIT_TIME_UOM, B.PRE_EXECUTION_WAIT, B.POST_EXECUTION_WAIT, B.EXECUTION_TIME_UOM, B.WORKFLOW_ITEM_TYPE, B.SAME_RESOURCE_YN, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.CREATION_DATE, B.CREATED_BY, B.PROGRAM_ID, B.OBJECT_VERSION_NUMBER, B.REQUEST_ID, B.PROGRAM_APPLICATION_ID, B.PROGRAM_UPDATE_DATE, B.SECURITY_GROUP_ID, B.FULFIL_TEMP_ID, B.XDO_TEMPLATE_ID, B.ESCALATE_YN, B.NOTIFY_YN, TL.NAME, TL.DESCRIPTION, B.WORK_TYPE, B.CATEGORY_TYPE, B.PRIORITY_TYPE, B.SCHEDULE_WAIT as CALLBACK_WAIT, B.SCHEDULE_UOM as CALLBACK_UOM, B.CLOSURE_TIME_LIMIT, B.CLOSURE_TIME_UOM, B.SCHEDULE_WAIT, B.SCHEDULE_UOM, B.ENABLED_FLAG, TL.SOURCE_LANG, TL.LANGUAGE, B.TEMPLATE_NAME, B.FULFIL_TEMP_NAME, B.TRX_LEVEL_FLAG, B.EXECUTION_CONDITION_CODE, B.EXECUTION_CONDITION_OPERATOR, B.EXECUTION_CONDITION_VALUE FROM IEX_STRY_TEMP_WORK_ITEMS_B B, IEX_STRY_TEMP_WORK_ITEMS_TL TL WHERE B.work_item_temp_id =TL.work_item_temp_id AND TL.LANGUAGE = userenv('LANG')

SQL_Statement

SELECT B.WORK_ITEM_TEMP_ID,

B.COMPETENCE_ID,

B.OPTIONAL_YN,

B.OPTION_WAIT_TIME,

B.OPTION_WAIT_TIME_UOM,

B.PRE_EXECUTION_WAIT,

B.POST_EXECUTION_WAIT,

B.EXECUTION_TIME_UOM,

B.WORKFLOW_ITEM_TYPE,

B.SAME_RESOURCE_YN,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATE_LOGIN,

B.CREATION_DATE,

B.CREATED_BY,

B.PROGRAM_ID,

B.OBJECT_VERSION_NUMBER,

B.REQUEST_ID,

B.PROGRAM_APPLICATION_ID,

B.PROGRAM_UPDATE_DATE,

B.SECURITY_GROUP_ID,

B.FULFIL_TEMP_ID,

B.XDO_TEMPLATE_ID,

B.ESCALATE_YN,

B.NOTIFY_YN,

TL.NAME,

TL.DESCRIPTION,

B.WORK_TYPE,

B.CATEGORY_TYPE,

B.PRIORITY_TYPE,

B.SCHEDULE_WAIT as CALLBACK_WAIT,

B.SCHEDULE_UOM as CALLBACK_UOM,

B.CLOSURE_TIME_LIMIT,

B.CLOSURE_TIME_UOM,

B.SCHEDULE_WAIT,

B.SCHEDULE_UOM,

B.ENABLED_FLAG,

TL.SOURCE_LANG,

TL.LANGUAGE,

B.TEMPLATE_NAME,

B.FULFIL_TEMP_NAME,

B.TRX_LEVEL_FLAG,

B.EXECUTION_CONDITION_CODE,

B.EXECUTION_CONDITION_OPERATOR,

B.EXECUTION_CONDITION_VALUE

FROM IEX_STRY_TEMP_WORK_ITEMS_B B,

IEX_STRY_TEMP_WORK_ITEMS_TL TL

WHERE B.work_item_temp_id =TL.work_item_temp_id

AND TL.LANGUAGE = userenv('LANG')