VIEW: APPS.CZ_GROUPED_ACTION_TYPES_V

Source

View Text - Preformatted

SELECT action_group_list_name, action_group_name, action_group_numeric_value, action_group_seq, action_group_data_type, action_group_null_flag, action_group_label, action_group_description, act.value_seq as action_seq, nvl (act.numeric_id_value, action_group_numeric_value) as action_code, NVL (act.data_value, ACTION_GROUP_NAME) as action_name, NVL (act.data_type_id, ACTION_GROUP_DATA_TYPE) as action_data_type, NVL (act.value_label, ACTION_GROUP_LABEL) as action_label, NVL (ACT.value_description, ACTION_GROUP_DESCRIPTION) as action_description, ACT.VALUE_NOTES AS ACTION_NOTES, ACT.LANGUAGE, ACT.SOURCE_LANG FROM ( SELECT grp.LIST_NAME AS ACTION_GROUP_LIST_NAME, decode (grp.DATA_VALUE, 'DISPLAY_UPDATE', 'ACTION_DISPLAY_UPDT', 'MODEL_INTERACTION', 'ACTION_MODEL_INTER', 'NAVIGATION', 'ACTION_NAV', 'SESSION_CONTROL', 'ACTION_SESSION_CTRL', grp.DATA_VALUE ) as ACTION_GROUP_NAME, grp.NUMERIC_ID_VALUE AS ACTION_GROUP_NUMERIC_VALUE, grp.VALUE_SEQ AS ACTION_GROUP_SEQ, grp.DATA_TYPE_ID AS ACTION_GROUP_DATA_TYPE, grp.NULL_VALUE_FLAG AS ACTION_GROUP_NULL_FLAG, grp.VALUE_LABEL AS ACTION_GROUP_LABEL, grp.VALUE_DESCRIPTION AS ACTION_GROUP_DESCRIPTION, grp.VALUE_NOTES FROM cz_lookup_values_vl grp WHERE GRP.list_name ='ACTION_TYPE_GROUP' ) grp, CZ_LOOKUP_VALUES_VL ACT WHERE grp.action_group_name = act.list_name (+)

View Text - HTML Formatted

SELECT ACTION_GROUP_LIST_NAME
, ACTION_GROUP_NAME
, ACTION_GROUP_NUMERIC_VALUE
, ACTION_GROUP_SEQ
, ACTION_GROUP_DATA_TYPE
, ACTION_GROUP_NULL_FLAG
, ACTION_GROUP_LABEL
, ACTION_GROUP_DESCRIPTION
, ACT.VALUE_SEQ AS ACTION_SEQ
, NVL (ACT.NUMERIC_ID_VALUE
, ACTION_GROUP_NUMERIC_VALUE) AS ACTION_CODE
, NVL (ACT.DATA_VALUE
, ACTION_GROUP_NAME) AS ACTION_NAME
, NVL (ACT.DATA_TYPE_ID
, ACTION_GROUP_DATA_TYPE) AS ACTION_DATA_TYPE
, NVL (ACT.VALUE_LABEL
, ACTION_GROUP_LABEL) AS ACTION_LABEL
, NVL (ACT.VALUE_DESCRIPTION
, ACTION_GROUP_DESCRIPTION) AS ACTION_DESCRIPTION
, ACT.VALUE_NOTES AS ACTION_NOTES
, ACT.LANGUAGE
, ACT.SOURCE_LANG
FROM ( SELECT GRP.LIST_NAME AS ACTION_GROUP_LIST_NAME
, DECODE (GRP.DATA_VALUE
, 'DISPLAY_UPDATE'
, 'ACTION_DISPLAY_UPDT'
, 'MODEL_INTERACTION'
, 'ACTION_MODEL_INTER'
, 'NAVIGATION'
, 'ACTION_NAV'
, 'SESSION_CONTROL'
, 'ACTION_SESSION_CTRL'
, GRP.DATA_VALUE ) AS ACTION_GROUP_NAME
, GRP.NUMERIC_ID_VALUE AS ACTION_GROUP_NUMERIC_VALUE
, GRP.VALUE_SEQ AS ACTION_GROUP_SEQ
, GRP.DATA_TYPE_ID AS ACTION_GROUP_DATA_TYPE
, GRP.NULL_VALUE_FLAG AS ACTION_GROUP_NULL_FLAG
, GRP.VALUE_LABEL AS ACTION_GROUP_LABEL
, GRP.VALUE_DESCRIPTION AS ACTION_GROUP_DESCRIPTION
, GRP.VALUE_NOTES
FROM CZ_LOOKUP_VALUES_VL GRP
WHERE GRP.LIST_NAME ='ACTION_TYPE_GROUP' ) GRP
, CZ_LOOKUP_VALUES_VL ACT
WHERE GRP.ACTION_GROUP_NAME = ACT.LIST_NAME (+)