Error on line 2 at column 585
Dear all,
I encountered the above error while select the multiple Production Number from the list.
Attached my SQL Script. Any one have any ideas about this? Please kindly assist.
select A.MMPMPN as "PROD_NO"
, B.SDDOCO as "SO_NO"
, TRUNC(B.SDLNID/1000,0) as "SO_LINE"
, to_date(to_char(H.SHTRDJ+1900000),'YYYYDDD') as "ORDER_DT"
, B.SDITM as "FG_ITEM_NO"
, B.SDLITM as "FG_ITEM_NO2"
, to_date(to_char(B.SDPDDJ+1900000),'YYYYDDD') as "CUST_PO_DT"
, to_date(to_char(B.SDDRQJ+1900000),'YYYYDDD') as "REQST_DT"
, to_date(to_char(B.SDOPDJ+1900000),'YYYYDDD') as "OR_PRMS_DT"