VIEW: APPS.IEX_WORK_ITEM_BALI_V

Source

View Text - Preformatted

SELECT wkitem.strategy_id STRATEGY_Id, wkitem.strategy_temp_id STRATEGY_TEMPLATE_ID, wkitem.work_item_order WKITEM_ORDER, wkitem.work_item_id WKITEM_ID, wkitem.work_item_template_id WKITEM_TEMPLATE_ID, stry_temp_wkitem_tl.name WKITEM_TEMPLATE_NAME , iex_utilities.get_lookup_meaning('IEX_STRATEGY_WORK_CATEGORY',stry_temp_wkitem_b.category_type) CATEGORY_TYPE_MEANING, stry_temp_wkitem_b.category_type CATEGORY, wkitem.EXECUTE_START START_TIME, wkitem.EXECUTE_END END_TIME, wkitem.resource_id ASSIGNED_TO, res.source_name ASSIGNEE, stry_temp_wkitem_b.escalate_yn ESCALATE_YN, item.display_name WORKFLOW_ITEM_TYPE, wkitem.status_code STATUS, iex_utilities.get_lookup_meaning('IEX_STRATEGY_WORK_STATUS',wkitem.status_code) STATUS_MEANING, 0 STRATEGY_USER_ITEM_ID, wkitem.CREATION_DATE CREATION_DATE, wkitem.CREATED_BY CREATED_BY, wkitem.LAST_UPDATE_DATE LAST_UPDATE_DATE, wkitem.LAST_UPDATED_BY LAST_UPDATED_BY, wkitem.escalated_yn escalted_yn, ARPT_SQL_FUNC_UTIL.get_lookup_meaning('YES/NO', wkitem.escalated_yn) escalated_meaning, 'N' archived_code, iex_utilities.get_lookup_meaning('IEX_YES_NO','N') archived, stry_temp_wkitem_b.ATTRIBUTE_CATEGORY, stry_temp_wkitem_b.ATTRIBUTE1, stry_temp_wkitem_b.ATTRIBUTE2, stry_temp_wkitem_b.ATTRIBUTE3, stry_temp_wkitem_b.ATTRIBUTE4, stry_temp_wkitem_b.ATTRIBUTE5, stry_temp_wkitem_b.ATTRIBUTE6, stry_temp_wkitem_b.ATTRIBUTE7, stry_temp_wkitem_b.ATTRIBUTE8, stry_temp_wkitem_b.ATTRIBUTE9, stry_temp_wkitem_b.ATTRIBUTE10, stry_temp_wkitem_b.ATTRIBUTE11, stry_temp_wkitem_b.ATTRIBUTE12, stry_temp_wkitem_b.ATTRIBUTE13, stry_temp_wkitem_b.ATTRIBUTE14, stry_temp_wkitem_b.ATTRIBUTE15 from iex_strategy_work_items wkitem, iex_stry_temp_work_items_b stry_temp_wkitem_b, iex_stry_temp_work_items_tl stry_temp_wkitem_tl, wf_item_types_tl item, jtf_rs_resource_extns res WHERE wkitem.work_item_template_id = stry_temp_wkitem_b.work_item_temp_id and stry_temp_wkitem_b.work_item_temp_id =stry_temp_wkitem_tl.work_item_temp_id and stry_temp_wkitem_tl.LANGUAGE = userenv('LANG') and stry_temp_wkitem_b.WORKFLOW_ITEM_TYPE = item.name(+) and item.language(+) = userenv('LANG') and wkitem.resource_id = res.resource_id(+) union all SELECT stry.STRATEGY_ID STRATEGY_ID , xref.STRATEGY_TEMP_ID STRATEGY_TEMPLATE_ID , xref.WORK_ITEM_ORDER WKITEM_ORDER , TO_NUMBER(NULL) WKITEM_ID , xref.WORK_ITEM_TEMP_ID WKITEM_TEMPLATE_ID , stry_temp_wkitem_tl.NAME WKITEM_TEMPLATE_NAME , iex_utilities.get_lookup_meaning('IEX_STRATEGY_WORK_CATEGORY',stry_temp_wkitem_b.category_type) CATEGORY_TYPE_MEANING , stry_temp_wkitem_b.category_type CATEGORY , TO_DATE(NULL) START_TIME , TO_DATE(NULL) END_TIME , TO_NUMBER(NULL) ASSIGNED_TO , NULL ASSIGNEE , stry_temp_wkitem_b.ESCALATE_YN , item.display_name WORKFLOW_ITEM_TYPE , 'NOTCREATED' STATUS , iex_utilities.get_lookup_meaning('IEX_STRATEGY_WORK_STATUS','NOTCREATED') STATUS_MEANING, 0 STRATEGY_USER_ITEM_ID, to_date(NULL) CREATION_DATE, to_number(NULL) CREATED_BY, to_date(NULL) LAST_UPDATE_DATE, to_number(NULL) LAST_UPDATED_BY, NULL escalted_yn, NULL escalated_meaning, 'N' archived_code, iex_utilities.get_lookup_meaning('IEX_YES_NO','N') archived, stry_temp_wkitem_b.ATTRIBUTE_CATEGORY, stry_temp_wkitem_b.ATTRIBUTE1, stry_temp_wkitem_b.ATTRIBUTE2, stry_temp_wkitem_b.ATTRIBUTE3, stry_temp_wkitem_b.ATTRIBUTE4, stry_temp_wkitem_b.ATTRIBUTE5, stry_temp_wkitem_b.ATTRIBUTE6, stry_temp_wkitem_b.ATTRIBUTE7, stry_temp_wkitem_b.ATTRIBUTE8, stry_temp_wkitem_b.ATTRIBUTE9, stry_temp_wkitem_b.ATTRIBUTE10, stry_temp_wkitem_b.ATTRIBUTE11, stry_temp_wkitem_b.ATTRIBUTE12, stry_temp_wkitem_b.ATTRIBUTE13, stry_temp_wkitem_b.ATTRIBUTE14, stry_temp_wkitem_b.ATTRIBUTE15 FROM IEX_STRATEGIES stry , IEX_STRATEGY_WORK_TEMP_XREF xref , iex_stry_temp_work_items_b stry_temp_wkitem_b, iex_stry_temp_work_items_tl stry_temp_wkitem_tl, wf_item_types_tl item WHERE stry.STRATEGY_TEMPLATE_ID = xref.STRATEGY_TEMP_ID AND xref.WORK_ITEM_TEMP_ID = stry_temp_wkitem_b.WORK_ITEM_TEMP_ID AND stry_temp_wkitem_b.work_item_temp_id =stry_temp_wkitem_tl.work_item_temp_id and stry_temp_wkitem_tl.LANGUAGE = userenv('LANG') and stry_temp_wkitem_b.WORKFLOW_ITEM_TYPE = ITEM.NAME(+) and item.language(+) = userenv('LANG') and xref.work_item_order > (select max(wkitem.work_item_order) from iex_strategy_work_items wkitem where wkitem.strategy_id = stry.strategy_id ) and not exists ( select 'x' from iex_strategy_user_items uitems where uitems.strategy_id = stry.strategy_id and uitems.work_item_temp_id = xref.work_item_temp_id and uitems.work_item_order = xref.work_item_order and uitems.operation in ('SKIP','NOTCREATED')) AND STRY.STATUS_CODE NOT IN ('CANCELLED','CLOSED') union ALL SELECT stry.STRATEGY_ID STRATEGY_ID , uitem.STRATEGY_TEMPLATE_ID STRATEGY_TEMPLATE_ID , uitem.WORK_ITEM_ORDER WKITEM_ORDER , TO_NUMBER(NULL) WKITEM_ID , uitem.WORK_ITEM_TEMP_ID WKITEM_TEMPLATE_ID , stry_temp_wkitem_tl.NAME WKITEM_TEMPLATE_NAME , iex_utilities.get_lookup_meaning('IEX_STRATEGY_WORK_CATEGORY',stry_temp_wkitem_b.category_type) CATEGORY_TYPE_MEANING , stry_temp_wkitem_b.category_type CATEGORY , TO_DATE(NULL) START_TIME , TO_DATE(NULL) END_TIME , TO_NUMBER(NULL) ASSIGNED_TO , NULL ASSIGNEE , stry_temp_wkitem_b.ESCALATE_YN , item.display_name WORKFLOW_ITEM_TYPE , uitem.operation STATUS , iex_utilities.get_lookup_meaning('IEX_STRATEGY_WORK_STATUS',uitem.operation) STATUS_MEANING, uitem.strategy_user_item_id STRATEGY_USER_ITEM_ID, to_date(NULL) CREATION_DATE, to_number(NULL) CREATED_BY, to_date(NULL) LAST_UPDATE_DATE, to_number(NULL) LAST_UPDATED_BY, NULL escalted_yn, NULL escalated_meaning, 'N' archived_code, iex_utilities.get_lookup_meaning('IEX_YES_NO','N') archived, stry_temp_wkitem_b.ATTRIBUTE_CATEGORY, stry_temp_wkitem_b.ATTRIBUTE1, stry_temp_wkitem_b.ATTRIBUTE2, stry_temp_wkitem_b.ATTRIBUTE3, stry_temp_wkitem_b.ATTRIBUTE4, stry_temp_wkitem_b.ATTRIBUTE5, stry_temp_wkitem_b.ATTRIBUTE6, stry_temp_wkitem_b.ATTRIBUTE7, stry_temp_wkitem_b.ATTRIBUTE8, stry_temp_wkitem_b.ATTRIBUTE9, stry_temp_wkitem_b.ATTRIBUTE10, stry_temp_wkitem_b.ATTRIBUTE11, stry_temp_wkitem_b.ATTRIBUTE12, stry_temp_wkitem_b.ATTRIBUTE13, stry_temp_wkitem_b.ATTRIBUTE14, stry_temp_wkitem_b.ATTRIBUTE15 FROM IEX_STRATEGIES stry , IEX_STRATEGY_user_items uitem , iex_stry_temp_work_items_b stry_temp_wkitem_b, iex_stry_temp_work_items_tl stry_temp_wkitem_tl, wf_item_types_tl item WHERE stry.STRATEGY_ID = uitem.STRATEGY_ID and uitem.WORK_ITEM_TEMP_ID = stry_temp_wkitem_b.WORK_ITEM_TEMP_ID AND stry_temp_wkitem_b.work_item_temp_id =stry_temp_wkitem_tl.work_item_temp_id and stry_temp_wkitem_tl.LANGUAGE = userenv('LANG') and stry_temp_wkitem_b.WORKFLOW_ITEM_TYPE = item.name(+) AND item.language(+) = userenv('LANG') and not exists ( select 'x' from iex_strategy_work_items wkitem where wkitem.strategy_id = stry.strategy_id and wkitem.work_item_template_id = uitem.work_item_temp_id and uitem.work_item_order = wkitem.work_item_order) UNION ALL SELECT wkitem.strategy_id STRATEGY_Id, wkitem.strategy_temp_id STRATEGY_TEMPLATE_ID, wkitem.work_item_order WKITEM_ORDER, wkitem.work_item_id WKITEM_ID, wkitem.work_item_template_id WKITEM_TEMPLATE_ID, stry_temp_wkitem_tl.name WKITEM_TEMPLATE_NAME , iex_utilities.get_lookup_meaning('IEX_STRATEGY_WORK_CATEGORY',stry_temp_wkitem_b.category_type) CATEGORY_TYPE_MEANING, stry_temp_wkitem_b.category_type CATEGORY, wkitem.EXECUTE_START START_TIME, wkitem.EXECUTE_END END_TIME, wkitem.resource_id ASSIGNED_TO, res.source_name ASSIGNEE, stry_temp_wkitem_b.escalate_yn ESCALATE_YN, item.display_name WORKFLOW_ITEM_TYPE, wkitem.status_code STATUS, iex_utilities.get_lookup_meaning('IEX_STRATEGY_WORK_STATUS',wkitem.status_code) STATUS_MEANING, 0 STRATEGY_USER_ITEM_ID, wkitem.CREATION_DATE CREATION_DATE, wkitem.CREATED_BY CREATED_BY, wkitem.LAST_UPDATE_DATE LAST_UPDATE_DATE, wkitem.LAST_UPDATED_BY LAST_UPDATED_BY, wkitem.escalated_yn escalted_yn, ARPT_SQL_FUNC_UTIL.get_lookup_meaning('YES/NO', wkitem.escalated_yn) escalated_meaning, 'Y' archived_code, iex_utilities.get_lookup_meaning('IEX_YES_NO','Y') archived, stry_temp_wkitem_b.ATTRIBUTE_CATEGORY, stry_temp_wkitem_b.ATTRIBUTE1, stry_temp_wkitem_b.ATTRIBUTE2, stry_temp_wkitem_b.ATTRIBUTE3, stry_temp_wkitem_b.ATTRIBUTE4, stry_temp_wkitem_b.ATTRIBUTE5, stry_temp_wkitem_b.ATTRIBUTE6, stry_temp_wkitem_b.ATTRIBUTE7, stry_temp_wkitem_b.ATTRIBUTE8, stry_temp_wkitem_b.ATTRIBUTE9, stry_temp_wkitem_b.ATTRIBUTE10, stry_temp_wkitem_b.ATTRIBUTE11, stry_temp_wkitem_b.ATTRIBUTE12, stry_temp_wkitem_b.ATTRIBUTE13, stry_temp_wkitem_b.ATTRIBUTE14, stry_temp_wkitem_b.ATTRIBUTE15 FROM iex_strategy_work_item_his wkitem, iex_stry_temp_work_items_b stry_temp_wkitem_b, iex_stry_temp_work_items_tl stry_temp_wkitem_tl, wf_item_types_tl item, jtf_rs_resource_extns res WHERE wkitem.work_item_template_id = stry_temp_wkitem_b.work_item_temp_id AND stry_temp_wkitem_b.work_item_temp_id =stry_temp_wkitem_tl.work_item_temp_id AND stry_temp_wkitem_tl.LANGUAGE = userenv('LANG') AND stry_temp_wkitem_b.WORKFLOW_ITEM_TYPE = item.name(+) AND item.language(+) = userenv('LANG') AND wkitem.resource_id = res.resource_id(+)

View Text - HTML Formatted

SELECT WKITEM.STRATEGY_ID STRATEGY_ID
, WKITEM.STRATEGY_TEMP_ID STRATEGY_TEMPLATE_ID
, WKITEM.WORK_ITEM_ORDER WKITEM_ORDER
, WKITEM.WORK_ITEM_ID WKITEM_ID
, WKITEM.WORK_ITEM_TEMPLATE_ID WKITEM_TEMPLATE_ID
, STRY_TEMP_WKITEM_TL.NAME WKITEM_TEMPLATE_NAME
, IEX_UTILITIES.GET_LOOKUP_MEANING('IEX_STRATEGY_WORK_CATEGORY'
, STRY_TEMP_WKITEM_B.CATEGORY_TYPE) CATEGORY_TYPE_MEANING
, STRY_TEMP_WKITEM_B.CATEGORY_TYPE CATEGORY
, WKITEM.EXECUTE_START START_TIME
, WKITEM.EXECUTE_END END_TIME
, WKITEM.RESOURCE_ID ASSIGNED_TO
, RES.SOURCE_NAME ASSIGNEE
, STRY_TEMP_WKITEM_B.ESCALATE_YN ESCALATE_YN
, ITEM.DISPLAY_NAME WORKFLOW_ITEM_TYPE
, WKITEM.STATUS_CODE STATUS
, IEX_UTILITIES.GET_LOOKUP_MEANING('IEX_STRATEGY_WORK_STATUS'
, WKITEM.STATUS_CODE) STATUS_MEANING
, 0 STRATEGY_USER_ITEM_ID
, WKITEM.CREATION_DATE CREATION_DATE
, WKITEM.CREATED_BY CREATED_BY
, WKITEM.LAST_UPDATE_DATE LAST_UPDATE_DATE
, WKITEM.LAST_UPDATED_BY LAST_UPDATED_BY
, WKITEM.ESCALATED_YN ESCALTED_YN
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO'
, WKITEM.ESCALATED_YN) ESCALATED_MEANING
, 'N' ARCHIVED_CODE
, IEX_UTILITIES.GET_LOOKUP_MEANING('IEX_YES_NO'
, 'N') ARCHIVED
, STRY_TEMP_WKITEM_B.ATTRIBUTE_CATEGORY
, STRY_TEMP_WKITEM_B.ATTRIBUTE1
, STRY_TEMP_WKITEM_B.ATTRIBUTE2
, STRY_TEMP_WKITEM_B.ATTRIBUTE3
, STRY_TEMP_WKITEM_B.ATTRIBUTE4
, STRY_TEMP_WKITEM_B.ATTRIBUTE5
, STRY_TEMP_WKITEM_B.ATTRIBUTE6
, STRY_TEMP_WKITEM_B.ATTRIBUTE7
, STRY_TEMP_WKITEM_B.ATTRIBUTE8
, STRY_TEMP_WKITEM_B.ATTRIBUTE9
, STRY_TEMP_WKITEM_B.ATTRIBUTE10
, STRY_TEMP_WKITEM_B.ATTRIBUTE11
, STRY_TEMP_WKITEM_B.ATTRIBUTE12
, STRY_TEMP_WKITEM_B.ATTRIBUTE13
, STRY_TEMP_WKITEM_B.ATTRIBUTE14
, STRY_TEMP_WKITEM_B.ATTRIBUTE15
FROM IEX_STRATEGY_WORK_ITEMS WKITEM
, IEX_STRY_TEMP_WORK_ITEMS_B STRY_TEMP_WKITEM_B
, IEX_STRY_TEMP_WORK_ITEMS_TL STRY_TEMP_WKITEM_TL
, WF_ITEM_TYPES_TL ITEM
, JTF_RS_RESOURCE_EXTNS RES
WHERE WKITEM.WORK_ITEM_TEMPLATE_ID = STRY_TEMP_WKITEM_B.WORK_ITEM_TEMP_ID
AND STRY_TEMP_WKITEM_B.WORK_ITEM_TEMP_ID =STRY_TEMP_WKITEM_TL.WORK_ITEM_TEMP_ID
AND STRY_TEMP_WKITEM_TL.LANGUAGE = USERENV('LANG')
AND STRY_TEMP_WKITEM_B.WORKFLOW_ITEM_TYPE = ITEM.NAME(+)
AND ITEM.LANGUAGE(+) = USERENV('LANG')
AND WKITEM.RESOURCE_ID = RES.RESOURCE_ID(+) UNION ALL SELECT STRY.STRATEGY_ID STRATEGY_ID
, XREF.STRATEGY_TEMP_ID STRATEGY_TEMPLATE_ID
, XREF.WORK_ITEM_ORDER WKITEM_ORDER
, TO_NUMBER(NULL) WKITEM_ID
, XREF.WORK_ITEM_TEMP_ID WKITEM_TEMPLATE_ID
, STRY_TEMP_WKITEM_TL.NAME WKITEM_TEMPLATE_NAME
, IEX_UTILITIES.GET_LOOKUP_MEANING('IEX_STRATEGY_WORK_CATEGORY'
, STRY_TEMP_WKITEM_B.CATEGORY_TYPE) CATEGORY_TYPE_MEANING
, STRY_TEMP_WKITEM_B.CATEGORY_TYPE CATEGORY
, TO_DATE(NULL) START_TIME
, TO_DATE(NULL) END_TIME
, TO_NUMBER(NULL) ASSIGNED_TO
, NULL ASSIGNEE
, STRY_TEMP_WKITEM_B.ESCALATE_YN
, ITEM.DISPLAY_NAME WORKFLOW_ITEM_TYPE
, 'NOTCREATED' STATUS
, IEX_UTILITIES.GET_LOOKUP_MEANING('IEX_STRATEGY_WORK_STATUS'
, 'NOTCREATED') STATUS_MEANING
, 0 STRATEGY_USER_ITEM_ID
, TO_DATE(NULL) CREATION_DATE
, TO_NUMBER(NULL) CREATED_BY
, TO_DATE(NULL) LAST_UPDATE_DATE
, TO_NUMBER(NULL) LAST_UPDATED_BY
, NULL ESCALTED_YN
, NULL ESCALATED_MEANING
, 'N' ARCHIVED_CODE
, IEX_UTILITIES.GET_LOOKUP_MEANING('IEX_YES_NO'
, 'N') ARCHIVED
, STRY_TEMP_WKITEM_B.ATTRIBUTE_CATEGORY
, STRY_TEMP_WKITEM_B.ATTRIBUTE1
, STRY_TEMP_WKITEM_B.ATTRIBUTE2
, STRY_TEMP_WKITEM_B.ATTRIBUTE3
, STRY_TEMP_WKITEM_B.ATTRIBUTE4
, STRY_TEMP_WKITEM_B.ATTRIBUTE5
, STRY_TEMP_WKITEM_B.ATTRIBUTE6
, STRY_TEMP_WKITEM_B.ATTRIBUTE7
, STRY_TEMP_WKITEM_B.ATTRIBUTE8
, STRY_TEMP_WKITEM_B.ATTRIBUTE9
, STRY_TEMP_WKITEM_B.ATTRIBUTE10
, STRY_TEMP_WKITEM_B.ATTRIBUTE11
, STRY_TEMP_WKITEM_B.ATTRIBUTE12
, STRY_TEMP_WKITEM_B.ATTRIBUTE13
, STRY_TEMP_WKITEM_B.ATTRIBUTE14
, STRY_TEMP_WKITEM_B.ATTRIBUTE15
FROM IEX_STRATEGIES STRY
, IEX_STRATEGY_WORK_TEMP_XREF XREF
, IEX_STRY_TEMP_WORK_ITEMS_B STRY_TEMP_WKITEM_B
, IEX_STRY_TEMP_WORK_ITEMS_TL STRY_TEMP_WKITEM_TL
, WF_ITEM_TYPES_TL ITEM
WHERE STRY.STRATEGY_TEMPLATE_ID = XREF.STRATEGY_TEMP_ID
AND XREF.WORK_ITEM_TEMP_ID = STRY_TEMP_WKITEM_B.WORK_ITEM_TEMP_ID
AND STRY_TEMP_WKITEM_B.WORK_ITEM_TEMP_ID =STRY_TEMP_WKITEM_TL.WORK_ITEM_TEMP_ID
AND STRY_TEMP_WKITEM_TL.LANGUAGE = USERENV('LANG')
AND STRY_TEMP_WKITEM_B.WORKFLOW_ITEM_TYPE = ITEM.NAME(+)
AND ITEM.LANGUAGE(+) = USERENV('LANG')
AND XREF.WORK_ITEM_ORDER > (SELECT MAX(WKITEM.WORK_ITEM_ORDER)
FROM IEX_STRATEGY_WORK_ITEMS WKITEM
WHERE WKITEM.STRATEGY_ID = STRY.STRATEGY_ID )
AND NOT EXISTS ( SELECT 'X'
FROM IEX_STRATEGY_USER_ITEMS UITEMS
WHERE UITEMS.STRATEGY_ID = STRY.STRATEGY_ID
AND UITEMS.WORK_ITEM_TEMP_ID = XREF.WORK_ITEM_TEMP_ID
AND UITEMS.WORK_ITEM_ORDER = XREF.WORK_ITEM_ORDER
AND UITEMS.OPERATION IN ('SKIP'
, 'NOTCREATED'))
AND STRY.STATUS_CODE NOT IN ('CANCELLED'
, 'CLOSED') UNION ALL SELECT STRY.STRATEGY_ID STRATEGY_ID
, UITEM.STRATEGY_TEMPLATE_ID STRATEGY_TEMPLATE_ID
, UITEM.WORK_ITEM_ORDER WKITEM_ORDER
, TO_NUMBER(NULL) WKITEM_ID
, UITEM.WORK_ITEM_TEMP_ID WKITEM_TEMPLATE_ID
, STRY_TEMP_WKITEM_TL.NAME WKITEM_TEMPLATE_NAME
, IEX_UTILITIES.GET_LOOKUP_MEANING('IEX_STRATEGY_WORK_CATEGORY'
, STRY_TEMP_WKITEM_B.CATEGORY_TYPE) CATEGORY_TYPE_MEANING
, STRY_TEMP_WKITEM_B.CATEGORY_TYPE CATEGORY
, TO_DATE(NULL) START_TIME
, TO_DATE(NULL) END_TIME
, TO_NUMBER(NULL) ASSIGNED_TO
, NULL ASSIGNEE
, STRY_TEMP_WKITEM_B.ESCALATE_YN
, ITEM.DISPLAY_NAME WORKFLOW_ITEM_TYPE
, UITEM.OPERATION STATUS
, IEX_UTILITIES.GET_LOOKUP_MEANING('IEX_STRATEGY_WORK_STATUS'
, UITEM.OPERATION) STATUS_MEANING
, UITEM.STRATEGY_USER_ITEM_ID STRATEGY_USER_ITEM_ID
, TO_DATE(NULL) CREATION_DATE
, TO_NUMBER(NULL) CREATED_BY
, TO_DATE(NULL) LAST_UPDATE_DATE
, TO_NUMBER(NULL) LAST_UPDATED_BY
, NULL ESCALTED_YN
, NULL ESCALATED_MEANING
, 'N' ARCHIVED_CODE
, IEX_UTILITIES.GET_LOOKUP_MEANING('IEX_YES_NO'
, 'N') ARCHIVED
, STRY_TEMP_WKITEM_B.ATTRIBUTE_CATEGORY
, STRY_TEMP_WKITEM_B.ATTRIBUTE1
, STRY_TEMP_WKITEM_B.ATTRIBUTE2
, STRY_TEMP_WKITEM_B.ATTRIBUTE3
, STRY_TEMP_WKITEM_B.ATTRIBUTE4
, STRY_TEMP_WKITEM_B.ATTRIBUTE5
, STRY_TEMP_WKITEM_B.ATTRIBUTE6
, STRY_TEMP_WKITEM_B.ATTRIBUTE7
, STRY_TEMP_WKITEM_B.ATTRIBUTE8
, STRY_TEMP_WKITEM_B.ATTRIBUTE9
, STRY_TEMP_WKITEM_B.ATTRIBUTE10
, STRY_TEMP_WKITEM_B.ATTRIBUTE11
, STRY_TEMP_WKITEM_B.ATTRIBUTE12
, STRY_TEMP_WKITEM_B.ATTRIBUTE13
, STRY_TEMP_WKITEM_B.ATTRIBUTE14
, STRY_TEMP_WKITEM_B.ATTRIBUTE15
FROM IEX_STRATEGIES STRY
, IEX_STRATEGY_USER_ITEMS UITEM
, IEX_STRY_TEMP_WORK_ITEMS_B STRY_TEMP_WKITEM_B
, IEX_STRY_TEMP_WORK_ITEMS_TL STRY_TEMP_WKITEM_TL
, WF_ITEM_TYPES_TL ITEM
WHERE STRY.STRATEGY_ID = UITEM.STRATEGY_ID
AND UITEM.WORK_ITEM_TEMP_ID = STRY_TEMP_WKITEM_B.WORK_ITEM_TEMP_ID
AND STRY_TEMP_WKITEM_B.WORK_ITEM_TEMP_ID =STRY_TEMP_WKITEM_TL.WORK_ITEM_TEMP_ID
AND STRY_TEMP_WKITEM_TL.LANGUAGE = USERENV('LANG')
AND STRY_TEMP_WKITEM_B.WORKFLOW_ITEM_TYPE = ITEM.NAME(+)
AND ITEM.LANGUAGE(+) = USERENV('LANG')
AND NOT EXISTS ( SELECT 'X'
FROM IEX_STRATEGY_WORK_ITEMS WKITEM
WHERE WKITEM.STRATEGY_ID = STRY.STRATEGY_ID
AND WKITEM.WORK_ITEM_TEMPLATE_ID = UITEM.WORK_ITEM_TEMP_ID
AND UITEM.WORK_ITEM_ORDER = WKITEM.WORK_ITEM_ORDER) UNION ALL SELECT WKITEM.STRATEGY_ID STRATEGY_ID
, WKITEM.STRATEGY_TEMP_ID STRATEGY_TEMPLATE_ID
, WKITEM.WORK_ITEM_ORDER WKITEM_ORDER
, WKITEM.WORK_ITEM_ID WKITEM_ID
, WKITEM.WORK_ITEM_TEMPLATE_ID WKITEM_TEMPLATE_ID
, STRY_TEMP_WKITEM_TL.NAME WKITEM_TEMPLATE_NAME
, IEX_UTILITIES.GET_LOOKUP_MEANING('IEX_STRATEGY_WORK_CATEGORY'
, STRY_TEMP_WKITEM_B.CATEGORY_TYPE) CATEGORY_TYPE_MEANING
, STRY_TEMP_WKITEM_B.CATEGORY_TYPE CATEGORY
, WKITEM.EXECUTE_START START_TIME
, WKITEM.EXECUTE_END END_TIME
, WKITEM.RESOURCE_ID ASSIGNED_TO
, RES.SOURCE_NAME ASSIGNEE
, STRY_TEMP_WKITEM_B.ESCALATE_YN ESCALATE_YN
, ITEM.DISPLAY_NAME WORKFLOW_ITEM_TYPE
, WKITEM.STATUS_CODE STATUS
, IEX_UTILITIES.GET_LOOKUP_MEANING('IEX_STRATEGY_WORK_STATUS'
, WKITEM.STATUS_CODE) STATUS_MEANING
, 0 STRATEGY_USER_ITEM_ID
, WKITEM.CREATION_DATE CREATION_DATE
, WKITEM.CREATED_BY CREATED_BY
, WKITEM.LAST_UPDATE_DATE LAST_UPDATE_DATE
, WKITEM.LAST_UPDATED_BY LAST_UPDATED_BY
, WKITEM.ESCALATED_YN ESCALTED_YN
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO'
, WKITEM.ESCALATED_YN) ESCALATED_MEANING
, 'Y' ARCHIVED_CODE
, IEX_UTILITIES.GET_LOOKUP_MEANING('IEX_YES_NO'
, 'Y') ARCHIVED
, STRY_TEMP_WKITEM_B.ATTRIBUTE_CATEGORY
, STRY_TEMP_WKITEM_B.ATTRIBUTE1
, STRY_TEMP_WKITEM_B.ATTRIBUTE2
, STRY_TEMP_WKITEM_B.ATTRIBUTE3
, STRY_TEMP_WKITEM_B.ATTRIBUTE4
, STRY_TEMP_WKITEM_B.ATTRIBUTE5
, STRY_TEMP_WKITEM_B.ATTRIBUTE6
, STRY_TEMP_WKITEM_B.ATTRIBUTE7
, STRY_TEMP_WKITEM_B.ATTRIBUTE8
, STRY_TEMP_WKITEM_B.ATTRIBUTE9
, STRY_TEMP_WKITEM_B.ATTRIBUTE10
, STRY_TEMP_WKITEM_B.ATTRIBUTE11
, STRY_TEMP_WKITEM_B.ATTRIBUTE12
, STRY_TEMP_WKITEM_B.ATTRIBUTE13
, STRY_TEMP_WKITEM_B.ATTRIBUTE14
, STRY_TEMP_WKITEM_B.ATTRIBUTE15
FROM IEX_STRATEGY_WORK_ITEM_HIS WKITEM
, IEX_STRY_TEMP_WORK_ITEMS_B STRY_TEMP_WKITEM_B
, IEX_STRY_TEMP_WORK_ITEMS_TL STRY_TEMP_WKITEM_TL
, WF_ITEM_TYPES_TL ITEM
, JTF_RS_RESOURCE_EXTNS RES
WHERE WKITEM.WORK_ITEM_TEMPLATE_ID = STRY_TEMP_WKITEM_B.WORK_ITEM_TEMP_ID
AND STRY_TEMP_WKITEM_B.WORK_ITEM_TEMP_ID =STRY_TEMP_WKITEM_TL.WORK_ITEM_TEMP_ID
AND STRY_TEMP_WKITEM_TL.LANGUAGE = USERENV('LANG')
AND STRY_TEMP_WKITEM_B.WORKFLOW_ITEM_TYPE = ITEM.NAME(+)
AND ITEM.LANGUAGE(+) = USERENV('LANG')
AND WKITEM.RESOURCE_ID = RES.RESOURCE_ID(+)