VIEW: APPS.IEX_WORK_ITEMS_AVAIL_BALI_V

Source

View Text - Preformatted

SELECT wit.work_item_temp_id , wit.name , wit.description , item.display_name WORKFLOW_ITEM_TYPE , wit.work_type , wit.category_type , lkp.meaning CATEGORY_TYPE_MEANING , wit.enabled_flag enabled_flag FROM IEX_STRY_TEMP_WORK_ITEMS_VL wit , wf_item_types_vl item , iex_lookups_v lkp WHERE item.name(+) = wit.WORKFLOW_ITEM_TYPE and lkp.lookup_type = 'IEX_STRATEGY_WORK_CATEGORY' and lkp.enabled_flag = 'Y' and wit.category_type = lkp.lookup_code

View Text - HTML Formatted

SELECT WIT.WORK_ITEM_TEMP_ID
, WIT.NAME
, WIT.DESCRIPTION
, ITEM.DISPLAY_NAME WORKFLOW_ITEM_TYPE
, WIT.WORK_TYPE
, WIT.CATEGORY_TYPE
, LKP.MEANING CATEGORY_TYPE_MEANING
, WIT.ENABLED_FLAG ENABLED_FLAG
FROM IEX_STRY_TEMP_WORK_ITEMS_VL WIT
, WF_ITEM_TYPES_VL ITEM
, IEX_LOOKUPS_V LKP
WHERE ITEM.NAME(+) = WIT.WORKFLOW_ITEM_TYPE
AND LKP.LOOKUP_TYPE = 'IEX_STRATEGY_WORK_CATEGORY'
AND LKP.ENABLED_FLAG = 'Y'
AND WIT.CATEGORY_TYPE = LKP.LOOKUP_CODE