Product: | CZ - Configurator |
---|---|
Description: | |
Implementation/DBA Data: | APPS.CZ_GROUPED_ACTION_TYPES_V |
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 (+)