ORA-01840

[João OtávioParticipante]

RESULTADO CONSULTA
NLS_DATE_FORMAT DD/MM/RRRR HH:MI:SS

PRIMEIRA LINHA
“AETC_CODE”,”PLANT_CODE”,”SENDER_CODE”,”SENDER_NAME”,”SENDER_STREET1″,”SENDER_CITY”,”SENDER_STATE”,”SENDER_ZIP”,”SENDER_COUNTRY”,
“RECHARGE_PERCENTAGE_SENDER”,”URGENT_COST_RECHARGE_SENDER”,”RECEIVER_CODE”,”RECEIVER_NAME”,”RECEIVER_STREET1″,”RECEIVER_CITY”,
“RECEIVER_STATE”,”RECEIVER_ZIP”,”RECEIVER_COUNTRY”,”RECHARGE_PERCENTAGE_RECEIVER”,”URGENT_COST_RECHARGE_RECEIVER”,”MBU_Prod_Line_Code_1″,
“MBU_Prod_Line_Name_1″,”MBU_Prod_Line_Perc_1″,”MBU_Prod_Line_Code_2″,”MBU_Prod_Line_Name_2″,”MBU_Prod_Line_Perc_2″,”MBU_Prod_Line_Code_3”,
“MBU_Prod_Line_Name_3″,”MBU_Prod_Line_Perc_3″,”PICKUP_DATE”,”PICKUP_DATE_BETWEEN_HOUR”,”PICKUP_DATE_BETWEEN_MINUTE”,
“PICKUP_DATE_AND_HOUR”,”PICKUP_DATE_AND_MINUTE”,”DELIVERY_DATE”,”DELIVERY_DATE_BETWEEN_HOUR”,”DELIVERY_DATE_BETWEEN_MINUTE”,
“DELIVERY_DATE_AND_HOUR”,”DELIVERY_DATE_AND_MINUTE”,”CNH_AUTHORIZER”,”CNH_AUTHORIZERLEVEL1″,”CNH_AUTHORIZERLEVEL2″,”CNH_AUTHORIZERLEVEL3″,
“REASON_CODE”,”REMARKS”,”PREMIUM_CATEGORY”,”EQUIPMENT_TYPE_ID”,”GROSSWEIGHT”,”UOMDESCGROSSWEIGHT”,”UOMGROSSWEIGHT”,
“TOTAL_VOLUME”,”UOMTOTALVOLUME”,”UOMDESCTOTALVOLUME”,”NOTE”,”CARRIER_ID”,”CARRIER_NAME”,”CURRENCY”,”COST”,”Cost Center/ Project Number”,”CREATION_DATE”,”SHIPMENT_ID”,
“PICKUP_REQUEST_ID”,”CARRIER_CODE”,”PARTNUMBER”,”NR_PIECES”,”PCONTACT_CSCN_ID”,”PCONTACT_CSCN_USERID_SUFFIX”,”PCONTACT_EMAIL”,
“PCONTACT_FAX”,”PCONTACT_FIRST_NAME”,”PCONTACT_LAST_NAME”,”PCONTACT_PHONE”,”PICKUP_EARLY”,”PICKUP_LATE”,”PICKUP_TYPE”,”REMARK”,
“SCONTACT_CSCN_ID”,”SCONTACT_CSCN_USERID_SUFFIX”,”SCONTACT_EMAIL”,”SCONTACT_FAX”,”SCONTACT_FIRST_NAME”,”SCONTACT_LAST_NAME”,
“SCONTACT_PHONE”,”SHIP_FROM_CITY”,”SHIP_FROM_ISO_COUNTRY”,”SHIP_FROM_LOCATION_ID”,”SHIP_FROM_NAME”,”SHIP_FROM_STATE”,
“SHIP_FROM_STREET1″,”SHIP_FROM_STREET2″,”SHIP_FROM_ZIP”,”SHIP_TO_CITY”,”SHIP_TO_ISO_COUNTRY”,”SHIP_TO_LOCATION_ID”,”SHIP_TO_NAME”,
“SHIP_TO_STATE”,”SHIP_TO_STREET1″,”SHIP_TO_STREET2″,”SHIP_TO_ZIP”,”EXPEDITED_AUTHORIZATION_CODE”,”EXPEDITED_AUTHORIZED_BY”,
“STATUS”,”PUR_DATE_INSERTED”,”PUR_DUE_DATE”,”PUR_EQUIPMENT_TYPE_ID”,”PUR_ER_CODE”,”PUR_SML_CODE”,”SHIP_CARRIER_NAME”,
“SHIP_CARRIER_REFERENCE”,”SHIP_DATE_INSERTED”,”SHIP_DUE_DATE”,”SHIP_EQUIPMENT_TYPE_ID”,
“SHIP_ESTIMATED_DEL_DATE”,”SHIP_STATUS_DATE”,”SHIP_STATUS_REASON”

São muitas colunas no banco, mas as que usam o campo no formato DATE são:
– PICKUP_DATE
– DELIVERY_DATE
– CREATION_DATE
– PUR_DATE_INSERTED
– PUR_DUE_DATE
– SHIP_DATE_INSERTED
– SHIP_DUE_DATE
– SHIP_ESTIMATED_DEL_DATE
– SHIP_STATUS_DATE