I have a interactive report which has some columns include APEX.ITEM . The data of APEX.ITEMs should store in a seperate table which this table is not the main table of my query . for example :

SELECT RAWTOHEX(STANDARD_HASH(
(‘”HEADER””DATETIMEISSUED””2023-05-25T00:34:00Z””RECEIPTNUMBER””001″”UUID””””PREVIOUSUUID””””REFERENCEOLDUUID””””CURRENCY””EGP””EXCHANGERATE””0″”SORDERNAMECODE””sOrderNameCode””ORDERDELIVERYMODE””””GROSSWEIGHT””6.58″”NETWEIGHT””6.89″”DOCUMENTTYPE””RECEIPTTYPE””S””TYPEVERSION””1.2″”SELLER””RIN””100334776″”COMPANYTRADENAME””Minapharm””BRANCHCODE””0″”BRANCHADDRESS””COUNTRY””EG””GOVERNATE””cairo””REGIONCITY””city center””STREET””16 street””BUILDINGNUMBER””14BN””POSTALCODE””74235″”FLOOR””1F””ROOM””3R””LANDMARK””tahrir square””ADDITIONALINFORMATION””talaat harb street””DEVICESERIALNUMBER””Sofy123″”SYNDICATELICENSENUMBER””1000056″”ACTIVITYCODE””4620″”BUYER””TYPE””F””ID””313717919″”NAME””taxpayer 1″”MOBILENUMBER””+201020567462″”PAYMENTNUMBER””987654″”ITEMDATA””ITEMDATA””INTERNALCODE””880609″”DESCRIPTION””Samsung A02 32GB_LTE_BLACK_DS_SM-A022FZKDMEB_A022 _ A022_SM-A022FZKDMEB””ITEMTYPE””GS1″”ITEMCODE””037000401629″”UNITTYPE””EA””QUANTITY””35″”UNITPRICE””247.96000″”NETSALE””7810.74000″”TOTALSALE””8678.60000″”TOTAL””8887.04360″”COMMERCIALDISCOUNTDATA””COMMERCIALDISCOUNTDATA””AMOUNT””867.86000″”DESCRIPTION””XYZ””ITEMDISCOUNTDATA””ITEMDISCOUNTDATA””AMOUNT””10″”DESCRIPTION””ABC””ITEMDISCOUNTDATA””AMOUNT””10″”DESCRIPTION””XYZ””VALUEDIFFERENCE””20″”TAXABLEITEMS””TAXABLEITEMS””TAXTYPE””T1″”AMOUNT””1096.30360″”SUBTYPE””V009″”RATE””14″”TOTALSALES””8678.60000″”TOTALCOMMERCIALDISCOUNT””867.86000″”TOTALITEMSDISCOUNT””20″”EXTRARECEIPTDISCOUNTDATA””EXTRARECEIPTDISCOUNTDATA””AMOUNT””0″”DESCRIPTION””ABC””NETAMOUNT””7810.74000″”FEESAMOUNT””0″”TOTALAMOUNT””8887.04360″”TAXTOTALS””TAXTOTALS””TAXTYPE””T1″”AMOUNT””1096.30360″”PAYMENTMETHOD””C””ADJUSTMENT””0″”CONTRACTOR””NAME””contractor1″”AMOUNT””2.563″”RATE””2.3″”BENEFICIARY””AMOUNT””20.569″”RATE””2.147″‘)
,’SHA256’)) as standard_hash_SHA256
FROM DUAL