I keep getting error: "missing Right parenthesis"
SELECT
bu.name AS legal_entity_name,
sup.vendor_name,
--cat.category_name,
rsh.receipt_num,
rsh.WAYBILL_AIRBILL_NUM,
poh.segment1,
le.invoice_num as Num_Factura,
DECODE( (TRUNC(CAST((FROM_TZ(CAST((rt.transaction_date) AS TIMESTAMP),'+00:00') AT TIME ZONE 'America/Mexico_City') AS DATE))), TRUNC(CAST((FROM_TZ(CAST(:P_DATE_TO AS TIMESTAMP),'America/Mexico_City') AT TIME ZONE '+00:00') AS DATE)), TO_CHAR((TRUNC(CAST((FROM_TZ(CAST(:P_DATE_FROM AS TIMESTAMP),'America/Mexico_City') AT TIME ZONE '+00:00') AS DATE))), 'YYYY-MM-DD HH24:MI:SS'),
TO_CHAR(CAST(TRUNC(FROM_TZ(CAST((rt.transaction_date) AS TIMESTAMP),'+00:00') AT TIME ZONE 'America/Mexico_City') AS DATE))) AS transaction_date,