DBA Data[Home] [Help]

VIEW: APPS.IEX_WORK_ITEM_CHECKLIST_V

Source

View Text - Preformatted

SELECT stry_temp_wkitem.name WKITEM_TEMPLATE_NAME , wkitem.work_item_template_id WKITEM_TEMP_ID, wkitem.work_item_id WKITEM_ID, wkitem.execute_start, wkitem.execute_end, wkitem.status_code, wkitem.strategy_id, wkitem.work_item_order from iex_stry_temp_work_items_vl stry_temp_wkitem, iex_strategy_work_items wkitem WHERE stry_temp_wkitem.work_item_temp_id = wkitem.work_item_template_id
View Text - HTML Formatted

SELECT STRY_TEMP_WKITEM.NAME WKITEM_TEMPLATE_NAME
, WKITEM.WORK_ITEM_TEMPLATE_ID WKITEM_TEMP_ID
, WKITEM.WORK_ITEM_ID WKITEM_ID
, WKITEM.EXECUTE_START
, WKITEM.EXECUTE_END
, WKITEM.STATUS_CODE
, WKITEM.STRATEGY_ID
, WKITEM.WORK_ITEM_ORDER
FROM IEX_STRY_TEMP_WORK_ITEMS_VL STRY_TEMP_WKITEM
, IEX_STRATEGY_WORK_ITEMS WKITEM
WHERE STRY_TEMP_WKITEM.WORK_ITEM_TEMP_ID = WKITEM.WORK_ITEM_TEMPLATE_ID