OKS Service Contracts Forecast Summary

➜ Back to Library
Description
Categories: BI Publisher
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 NameSQL textValidation
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
Download
Related Blitz Reports
INV Items EC: INV Item Upload INV Item Upload OKS Service Contract Forecast Management INV Item Templates ECC Service Contracts, Service Contract Details PO Approved Supplier List MRP Pegging AR Transactions and Lines
Blitz Report™