[Home] [Help]
516: AND inv.fee_ci_sequence_number = cp_fee_ci_sequence_number
517: AND inv.fee_type = cp_fee_type
518: AND inv.transaction_type = cp_transaction_type
519: AND NOT EXISTS( SELECT 'X'
520: FROM igs_fi_credits fc,
521: igs_fi_cr_types crt,
522: igs_fi_applications app
523: WHERE app.invoice_id = inv.invoice_id
524: AND app.credit_id = fc.credit_id