Product: | AZ - Application Implementation |
---|---|
Description: | Provies easy access to language-dependent display names for Wizard process groups |
Implementation/DBA Data: | APPS.AZ_GROUPS_V |
SELECT AG.GROUP_ID
, AG.PROCESS_TYPE
, FL.MEANING DISPLAY_NAME
, AG.DISPLAY_ORDER
, DECODE(AG.COMPLETE_FLAG
, 'N'
, 'A'
, 'C') STATUS
, AG.COMPLETE_FLAG
, AG.APPLICATION_ID
, AG.LOOKUP_CODE
, AG.COLOR_CODE
, AG.HIERARCHY_PARENT_ID
, AG.HIERARCHY_PARENT_PROCESS_TYPE
, AG.DEPENDENCY_PARENT_ID
, AG.DEPENDENCY_PARENT_PROCESS_TYPE
, AG.CREATION_DATE
, AG.CREATED_BY
, AG.LAST_UPDATE_DATE
, AG.LAST_UPDATED_BY
, AG.LAST_UPDATE_LOGIN
FROM AZ_GROUPS AG
, FND_LOOKUPS FL
WHERE AG.LOOKUP_CODE IS NOT NULL
AND FL.LOOKUP_TYPE = 'AZ_PROCESS_GROUPS'
AND FL.LOOKUP_CODE = AG.LOOKUP_CODE UNION SELECT AG.GROUP_ID
, AG.PROCESS_TYPE
, FAV.APPLICATION_NAME DISPLAY_NAME
, AG.DISPLAY_ORDER
, DECODE(AG.COMPLETE_FLAG
, 'N'
, 'A'
, 'C') STATUS
, AG.COMPLETE_FLAG
, AG.APPLICATION_ID
, AG.LOOKUP_CODE
, AG.COLOR_CODE
, AG.HIERARCHY_PARENT_ID
, AG.HIERARCHY_PARENT_PROCESS_TYPE
, AG.DEPENDENCY_PARENT_ID
, AG.DEPENDENCY_PARENT_PROCESS_TYPE
, AG.CREATION_DATE
, AG.CREATED_BY
, AG.LAST_UPDATE_DATE
, AG.LAST_UPDATED_BY
, AG.LAST_UPDATE_LOGIN
FROM AZ_GROUPS AG
, FND_APPLICATION_VL FAV
WHERE AG.APPLICATION_ID IS NOT NULL
AND AG.APPLICATION_ID = FAV.APPLICATION_ID