SELECT BUILTIN.DF(status) as statustxt, trackingNumberList FROM transaction where tranid = '${params.custpage_sales_order}';

But this is not returning the trackingNumberList.

try this, use internalid instead of tranid or update the query a bit to use tranid.

SELECT
            LISTAGG (tracking_num, ';') AS tracking_num
        FROM
            (
                SELECT DISTINCT
                    tracking_num AS tracking_num
                FROM
                    (
                        SELECT
                            packagetrackingnumber AS tracking_num,
                        FROM
                            transaction AS ifTrans
                            INNER JOIN TransactionLine AS ifLine ON ifLine.Transaction = ifTrans.id
                            LEFT OUTER JOIN itemfulfillmentpackage AS p ON p.itemfulfillment = ifTrans.id
                        WHERE
                            ifTrans.type = 'ItemShip'
                            AND ifLine.mainline = 'T'
                            AND ifLine.createdfrom IN (${salesOrderInternalId})
                    )
            )