ECC Lease Contracts, Lease Quote Summary

Description
Categories: Enterprise Command Center
Columns: Contract Id, Contract Number, Quote Number, Stream Code, Asset Number, Gl Account, Gl Acct Description, Forecasted Amount, Remaining Stream Bal, Subledger Bal ...
Imported from Enterprise Command Center
Description: Lease Account Reconciliation Quote summary
Dataset Key: okl_arcon_quote_summ
Query Procedure: okl_ecc_arcon_pkg.ecc_acct_recon_data_load
Security Procedure:
select
x.*
from
(
SELECT * FROM
(select contract_id, Contract_number,to_char(quote_number) quote_number,stream_code,
asset_number,gl_account,gl_acct_description,
sum(formula_value) forecasted_amount,
sum(remaining_balance) remaining_stream_bal,
sum(subledger_value) subledger_bal,
sum(remaining_balance)-sum(formula_value) Quote_adjustnment,
contract_id||'-'||quote_number||'-'||stream_code||'-'||asset_number||'-'||gl_account ecc_spec_id,
org_id,
ledger_name,
ledger_currency
--sty_tl.language language_code
from okl_ecc_arcon_quotes oaq
--okl_strm_type_tl     sty_tl
where processing_status_flag ='N'
and   quote_line_status <> 'CANCELLED'
--and oaq.stream_code = sty_tl.name
group by contract_id, Contract_number, quote_number,asset_number,gl_account,
gl_acct_description,ledger_name,ledger_currency,org_id,stream_code)
) x
where
2=2
Parameter Name SQL text Validation
Operating Unit
x.org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:operating_unit)
LOV