OKS Service Contracts Summary

Description
Categories: BI Publisher
Application: Service Contracts
Source: Service Contracts Summary Report (XML)
Short Name: OKSSUMRP_XML
DB package: OKS_OKSSUMRP_XMLP_PKG
Run OKS Service Contracts Summary and other Oracle EBS reports with Blitz Report™ on our demo environment
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 Name SQL text Validation
Contract Group
 
LOV Oracle
Operating Unit
 
LOV Oracle
Rep Name
 
LOV Oracle
Customer Number
 
LOV Oracle
Customer Name
 
LOV Oracle
From Date
 
Date
To Date
 
Date
Currency Code
 
LOV Oracle
Blitz Report™