USP_SIMPLEDATALIST_CREDITCREDITCARDPAYMENTS

CREATE procedure dbo.USP_SIMPLEDATALIST_CREDITCREDITCARDPAYMENTS(@CREDITID uniqueidentifier)
as
    set nocount on;

    select
        CREDITPAYMENT.ID as VALUE,
        CREDITTYPECODE.DESCRIPTION + '     ' + '****' + 
        CREDITCARDPAYMENTMETHODDETAIL.CREDITCARDPARTIALNUMBER + '     ' + 
        convert(nvarchar, CREDITPAYMENT.AMOUNT, 0) as LABEL
    from
        dbo.CREDITPAYMENT
    inner join
        dbo.FINANCIALTRANSACTION as FT on FT.ID = CREDITPAYMENT.CREDITID
    inner join
        dbo.CREDIT_EXT as EXT on EXT.ID = FT.ID
    inner join
        dbo.REVENUEPAYMENTMETHOD on REVENUEPAYMENTMETHOD.REVENUEID = CREDITPAYMENT.REVENUEID
    inner join
        dbo.CREDITCARDPAYMENTMETHODDETAIL on REVENUEPAYMENTMETHOD.PAYMENTMETHODCODE = 2 and CREDITCARDPAYMENTMETHODDETAIL.ID = REVENUEPAYMENTMETHOD.ID
    inner join
        dbo.CREDITTYPECODE on CREDITCARDPAYMENTMETHODDETAIL.CREDITTYPECODEID = CREDITTYPECODE.ID                        
    where 
        FT.ID = @CREDITID
        and (
            EXT.SALESORDERID is not null
            or exists (select * from dbo.SALESORDER where SALESORDER.REVENUEID = FT.PARENTID)
        )
    order by
        CREDITPAYMENT.AMOUNT desc;

    return 0;