PL/SQL (MOSC)

MOSC Banner

I keep getting error: "missing Right parenthesis"

in PL/SQL (MOSC) 4 commentsAnswered ✓

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center