OKS Service Contracts Forecast Summary

Description
Categories: BI Publisher, Service
Application: Service Contracts
Source: Service Contracts Forecast Summary Report (XML)
Short Name: OKSFOSUM_XML
DB package: OKS_OKSFOSUM_XMLP_PKG
select run_flag,
            run_time,
            status_type,
            status_code,
            currency,
            number_of_contracts ,
            oks_extwar_util_pvt.round_currency_amt(contract_value,currency) contract_value,
            oks_extwar_util_pvt.round_currency_amt(booking_forecast,currency) booking_forecast,
            oks_extwar_util_pvt.round_currency_amt(rev_rec_value,currency) rev_rec_value,
            oks_extwar_util_pvt.round_currency_amt(forecast_value,currency) forecast_value
            from
            oks_status_forecast
            where conc_request_id = :p_conc_request_id
Parameter Name SQL text Validation
Recognized Revenue Date
 
Date
Maximum Contract Value
 
Number
Minimum Contract Value
 
Number
End Date
 
Date
Start Date
 
Date
Currency Code
 
LOV Oracle
Operating Unit
 
LOV Oracle
Contract Group
 
LOV Oracle