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, wit.ATTRIBUTE_CATEGORY, wit.ATTRIBUTE1, wit.ATTRIBUTE2, wit.ATTRIBUTE3, wit.ATTRIBUTE4, wit.ATTRIBUTE5, wit.ATTRIBUTE6, wit.ATTRIBUTE7, wit.ATTRIBUTE8, wit.ATTRIBUTE9, wit.ATTRIBUTE10, wit.ATTRIBUTE11, wit.ATTRIBUTE12, wit.ATTRIBUTE13, wit.ATTRIBUTE14, wit.ATTRIBUTE15 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
, WIT.ATTRIBUTE_CATEGORY
, WIT.ATTRIBUTE1
, WIT.ATTRIBUTE2
, WIT.ATTRIBUTE3
, WIT.ATTRIBUTE4
, WIT.ATTRIBUTE5
, WIT.ATTRIBUTE6
, WIT.ATTRIBUTE7
, WIT.ATTRIBUTE8
, WIT.ATTRIBUTE9
, WIT.ATTRIBUTE10
, WIT.ATTRIBUTE11
, WIT.ATTRIBUTE12
, WIT.ATTRIBUTE13
, WIT.ATTRIBUTE14
, WIT.ATTRIBUTE15
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