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
SQL 14 lines
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 |
Parameters 8
| Parameter | Type | List of values SQL |
|---|---|---|
| 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 |