1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
| SELECT dp.credit_card_payment_numcard,
tx.transaction_date,
TO_CHAR(tx.transaction_date, 'DD/MM/YYYY HH24:MI:SS'),
tx.TICKET_SERIAL_NUMBER,
dp.EQUIPMENT_ID,
dp.DETAIL_PAYT_AMOUNT
FROM DETAIL_PAYMENT dp,
TRANSACTION tx
WHERE SUBSTR(dp.CREDIT_CARD_PAYMENT_NUMCARD, INSTR(dp.CREDIT_CARD_PAYMENT_NUMCARD, '=', 1, 1) - 4, 4) = '9535' AND
dp.DETAIL_PAYT_AMOUNT = '8' AND
dp.EQUIPMENT_ID = tx.EQUIPMENT_ID AND
dp.POST_ID = tx.POST_ID AND
dp.POST_BEGIN = tx.POST_BEGIN AND
dp.TRANSACTION_ID = tx.TRANSACTION_ID
ORDER BY tx.transaction_date DESC |