VIEW: APPS.AZ_PROCESSES_ALL_V

Source

View Text - Preformatted

SELECT ap.item_type,ap.process_name,wav.display_name, ap.context_id,ap.parent_id,ap.display_order,ap.status_code, ap.process_type, ap.context_type, fl.meaning context_type_name, ap.context_name, ap.comments, wav.description from az_processes ap, wf_activities_vl wav, fnd_lookups fl where ap.item_type = wav.item_type and ap.process_name = wav.name and wav.item_type like 'AZ%' and wav.name like 'AZ%' and wav.end_date IS NULL and fl.lookup_type = 'AZ_CONTEXT_TYPE' and fl.lookup_code = ap.context_type

View Text - HTML Formatted

SELECT AP.ITEM_TYPE
, AP.PROCESS_NAME
, WAV.DISPLAY_NAME
, AP.CONTEXT_ID
, AP.PARENT_ID
, AP.DISPLAY_ORDER
, AP.STATUS_CODE
, AP.PROCESS_TYPE
, AP.CONTEXT_TYPE
, FL.MEANING CONTEXT_TYPE_NAME
, AP.CONTEXT_NAME
, AP.COMMENTS
, WAV.DESCRIPTION
FROM AZ_PROCESSES AP
, WF_ACTIVITIES_VL WAV
, FND_LOOKUPS FL
WHERE AP.ITEM_TYPE = WAV.ITEM_TYPE
AND AP.PROCESS_NAME = WAV.NAME
AND WAV.ITEM_TYPE LIKE 'AZ%'
AND WAV.NAME LIKE 'AZ%'
AND WAV.END_DATE IS NULL
AND FL.LOOKUP_TYPE = 'AZ_CONTEXT_TYPE'
AND FL.LOOKUP_CODE = AP.CONTEXT_TYPE