Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

WITH EntitySpecification(payloadentityspecification) AS
(
 SELECT 
'{
  "description": "test",
  "id": "1",
  "name": "test",
 
  "productSpecificationRelationship": [

{
      "id": "10499",
      "relationshipType": "channelRelation",
      "relationshipCharacteristic": [
        {
          "name": "out_of_home",
          "value": "1"
        },
        {
          "name": "out_of_home_ios",
          "value": "1" 
        },
        {
          "name": "out_of_home_android",
          "value": "0"
        },
        {
          "name": "out_of_home_web",
          "value": "0"
        }
      ]
     }
  ]
}' FROM dual UNION ALL
 SELECT 
'{
  "description": "Channel-Map-REG_MTL",
  "id": "1",
  "name": "Channel-Map-REG_MTL",
  "productSpecificationRelationship": [

{
      "id": "10500",
      "relationshipType": "channelRelation",
      "relationshipCharacteristic": [
        {
          "name": "out_of_home",
          "value": "0"
        },
        {
          "name": "out_of_home_ios",
          "value": "0" 
        },
        {
          "name": "out_of_home_android",
          "value": "0"
        },
        {
          "name": "out_of_home_web",
          "value": "0"
        }
      ]
     }
  ]
}' FROM dual
)
 SELECT JSON_VALUE(payloadentityspecification, '$.name') AS channel_map_name,
        MAX(CASE WHEN name = 'out_of_home' THEN 
                      DECODE(value,1,'TRUE',0,'FALSE','UNDEFINED')
                  END) AS ooh,
        MAX(CASE WHEN name = 'out_of_home_android' THEN 
                      DECODE(value,1,'TRUE',0,'FALSE','UNDEFINED')
                  END) AS ooh_android,
        MAX(CASE WHEN name = 'out_of_home_ios' THEN 
                      DECODE(value,1,'TRUE',0,'FALSE','UNDEFINED')
                  END) AS ooh_ios,
        MAX(CASE WHEN name = 'out_of_home_web' THEN 
                      DECODE(value,1,'TRUE',0,'FALSE','UNDEFINED')
                  END) AS ooh_web                  
   FROM EntitySpecification ES,
   JSON_TABLE (payloadentityspecification, '$.productSpecificationRelationship[*]'
                    COLUMNS (  NESTED PATH '$.relationshipCharacteristic[*]'
                    COLUMNS (                
                             description VARCHAR2(250) PATH '$.description',
                             name        VARCHAR2(250) PATH '$.name',
                             value       VARCHAR2(250) PATH '$.value'
                            )
   )) jt
  WHERE payloadentityspecification IS JSON
  GROUP BY JSON_VALUE(payloadentityspecification, '$.name')

CHANNEL_MAP_NAME	OOH	OOH_ANDROID	OOH_IOS	OOH_WEB
test	TRUE	FALSE	TRUE	FALSE
Channel-Map-REG_MTL	FALSE	FALSE	FALSE	FALSE