VIEW: APPS.AZ_GROUPS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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