SELECT E.ORDER_ID,E.ORDER_ITEM_ID,E.CREATED_DATE,E.ORDER_ITEM_STATUS
FROM ECP_ORDER_ITEM E
WHERE SYSDATE > (E.CREATED_DATE + 30/(24*60))
AND E.ORDER_ITEM_STATUS ='NOT_PAY'
AND E.ORDER_ITEM_STATUS!= 'USER_REVOKED'
FROM ECP_ORDER_ITEM E
WHERE SYSDATE > (E.CREATED_DATE + 30/(24*60))
AND E.ORDER_ITEM_STATUS ='NOT_PAY'
AND E.ORDER_ITEM_STATUS!= 'USER_REVOKED'
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
