1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
| select distinct tab.dt dt,tab.pid pid,tab.dur dur, tab.num num,tab.vu vu,tab.rv RV, tab.com COM, tab.ADR1 ADR1,tab.adr2 ADR2,tab.sid SID,tab.no NO
FROM
(
(select cr.at_date DT, cr.payphone_id PID, cr.duration DUR, cr.b_number NUM,cr.value_used VU, cr.remaining_value RV, pd.add_data2 COM, pp.address1 ADR1,pp.address2 ADR2, cr.serie_id sid,cr.card_no no
from n_card_transactions cr, n_payphones pp, payphone_details pd
where cr.payphone_id=pp.payphone_id and cr.payphone_id=pd.payphone_id and
cr.card_no={?no_card} AND cr.call_category <= 89 )
minus
(select cr.at_date, cr.payphone_id, cr.duration, cr.b_number,cr.value_used,
cr.remaining_value, pd.add_data2, pp.address1,pp.address2,cr.serie_id,cr.card_no
from card_transactions@GETPMS cr, payphones@GETPMS pp, payphone_details@GETPMS pd
where cr.payphone_id=pp.payphone_id and cr.payphone_id=pd.payphone_id
AND cr.card_no={?no_card} AND cr.call_category <= 89)
) TAB |
Partager