SELECT ALOC_DETAIL_5 sv_number
FROM ID_PAYMENT_ALLOCATION_DETAILS,id_payment_header
WHERE
ALOC_DOC_NUMBER=PH_DOC_NUMBER and
ph_status not in ('C','R')
and ALOC_DOC_NUMBER LIKE 'BPVS%' AND ALOC_DETAIL_1<>'APVR' AND ALOC_ALLOCATION_TYPE<>'INC_EXD'