OKS Service Contracts Summary

Description
Categories: BI Publisher
Columns: Rep Name, Customer Id, Customer Number, Customer Name, Contract Id, Contract Number, Contract Modifier, Status Code, Status Type, Status Meaning ...
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 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