OKS Service Contracts Forecast Summary

Description
Categories: BI Publisher
Application: Service Contracts
Source: Service Contracts Forecast Summary Report (XML)
Short Name: OKSFOSUM_XML
DB package: OKS_OKSFOSUM_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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
Contract Group
 
LOV Oracle
Operating Unit
 
LOV Oracle
Currency Code
 
LOV Oracle
Start Date
 
Date
End Date
 
Date
Minimum Contract Value
 
Number
Maximum Contract Value
 
Number
Recognized Revenue Date
 
Date