[Home] [Help]
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
Name |
ITEM_TYPE |
PROCESS_NAME |
DISPLAY_NAME |
CONTEXT_ID |
PARENT_ID |
DISPLAY_ORDER |
STATUS |
PROCESS_TYPE |
CONTEXT_TYPE |
CONTEXT_TYPE_NAME |
CONTEXT_NAME |
COMMENTS |
DESCRIPTION |