View: AZ_PROCESSES_ALL_V

Product:	AZ - Application Implementation
Description:	Provides easy access to language-dependent display names as well as statuses for all Wizard processes
Implementation/DBA Data:	APPS.AZ_PROCESSES_ALL_V

View Text

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

Columns