ECC Lease Contracts, Lease Vendor Cash Summary

Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Description: This data set holds summarized data for the Vendor Cash Flow dashboard.
Dataset Key: okl-vcf-summary
Query Procedure: OKL_ECC_VCF_PVT.GET_ECC_VCF_DATA_LOAD
Security Procedure: okl_ecc_datasecurity_pkg_pub.GetFilterAttributeValues
select
x.*
from
(
SELECT * FROM
(SELECT
    contract_id||ovs.contract_number||cle_id||customer_trx_line_id||line_type ECC_SPEC_ID,
    contract_id,
    ovs.contract_number,
    cle_id,
    customer_trx_line_id,
    line_type,
    ar_inv_number,
    nvl(asset_number,'  ')  asset_number,
    ar_inv_line_amt ar_inv_line_amt,
    receipt_amt_applied,
    remaining_balance ,
    ap_inv_line_amount,
    ap_line_amount_paid ,
    summarization_date,
    nvl(sttl.name,'  ') PASSTHRU_STREAM_PURPOSE,
    (decode(ovs.passthru_stream_type_purpose,'PASS_THROUGH_ADVANCE',to_number(0),stream_amount)) stream_amount ,
    nvl(sttl.language,'US') language_code,
    ovs.org_id,
    clawback_flag
FROM
    okl_ecc_vcf_summary_dts_v ovs,
    okl_strm_type_tl sttl
WHERE  ovs.passthru_stream_type_id = sttl.id(+)
AND    sttl.language in('US')
AND    processing_status_flag='N')
PIVOT            (MAX(passthru_stream_purpose) AS passthru_stream_purpose
                  FOR language_code IN ('US' "US"))
) 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