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'