OKS Service Contracts Summary

select
            REP_NAME,
            CUSTOMER_ID,
            CUSTOMER_NUMBER,
            CUSTOMER_NAME,
            CONTRACT_ID     ,
            CONTRACT_NUMBER        ,
            CONTRACT_MODIFIER,
            STATUS_CODE                 ,
            STATUS_TYPE ,
            STATUS_MEANING         ,
            START_DATE             ,
            END_DATE               ,
            oks_extwar_util_pvt.round_currency_amt(TOTAL_VALUE,CURRENCY_CODE)  total_value  ,
            Currency_Code,
            LAST_UPDATE_DATE  ,
            org_id,
                OKS_OKSSUMRP_XMLP_PKG.cf_1formula(REP_NAME, org_id) CF_salesrep_name,
                OKS_OKSSUMRP_XMLP_PKG.cf_last_intreractionformula(CONTRACT_ID) CF_last_intreraction
            from oks_repname_v
            where  'A' = 'A'
            &p_start_date_where
            &p_rep_name_where
            &p_customer_name_where
            &p_customer_number_where
            &p_currency_code_where
            &p_contract_group_where
            /*order by REP_NAME, CUSTOMER_NAME, CUSTOMER_NUMBER, Currency_Code,
            LAST_UPDATE_DATE, CONTRACT_MODIFIER, STATUS_CODE, STATUS_TYPE,
            org_id, CONTRACT_ID, CUSTOMER_ID, CONTRACT_NUMBER, STATUS_MEANING,
            START_DATE, END_DATE, total_value,
            rep_name,status_meaning, nvl(total_value,0) desc,customer_name*/
            ORDER BY 1 ASC,4 ASC,3 ASC , rep_name , status_meaning , nvl ( total_value , 0 ) desc , customer_name