Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE ary (car BLOB CHECK (car IS JSON));
INSERT INTO ary (car) VALUES ('{ "Id" : "XXX000", 
        "elements":[
      {
         "product":{
            "prodName":"Car",
            "prodCode":"CR"
         },
         "components":[
            {
               "compName":"Toyota",
               "compCode":"BRND" 
            },
            {
               "compName":"Red",
               "compCode":"CLR"
            }
         ]
      },
      {
         "product":{
            "prodName":"Truck",
            "prodCode":"TRCK"
         },
         "components":[
            {
               "compName":"Dodge",
               "compCode":"BRND"
            },
            {
               "compName":"Blue",
               "compCode":"CLR" 
            }
         ]
      }
   ]}')
1 rows affected

select id, 
       prdct,
       brnd,
       clr
from   ary
       CROSS APPLY JSON_TABLE(
         car,
         '$'
         COLUMNS (
           id PATH  '$.Id',
           NESTED PATH '$.elements[*]' COLUMNS (
             prdct PATH '$.product.prodName',
             brnd  PATH '$.components[*]?(@.compCode == "BRND").compName',
             clr   PATH '$.components[*]?(@.compCode == "CLR").compName'
           )
         )
       );


ID
PRDCT
BRND
CLR


XXX000
Car
Toyota
Red

XXX000
Truck
Dodge
Blue


select id, 
       prdct,
       brnd,
       clr
from   ary
       CROSS APPLY JSON_TABLE(
         car,
         '$'
         COLUMNS (
           id PATH  '$.Id',
           NESTED PATH '$.elements[*]' COLUMNS (
             prdct PATH '$.product.prodName',
             brnd  PATH '$.components[0].compName',
             clr   PATH '$.components[1].compName'
           )
         )
       );


ID
PRDCT
BRND
CLR


XXX000
Car
Toyota
Red

XXX000
Truck
Dodge
Blue