OKS Service Contracts Summary

Description
Categories: BI Publisher, Service
Application: Service Contracts
Source: Service Contracts Summary Report (XML)
Short Name: OKSSUMRP_XML
DB package: OKS_OKSSUMRP_XMLP_PKG
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
Parameter NameSQL textValidation
Currency Code
 
LOV Oracle
To Date
 
Date
From Date
 
Date
Customer Name
 
LOV Oracle
Customer Number
 
LOV Oracle
Rep Name
 
LOV Oracle
Operating Unit
 
LOV Oracle
Contract Group
 
LOV Oracle