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_VCS_DATA_LOAD
Security Procedure:
Run ECC Lease Contracts, Lease Vendor Cash Summary and other Oracle EBS reports with Blitz Report™ on our demo environment
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,  --bug 30047715 blanking out of consolidated tab
    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,
    stream_amount,
    nvl(sttl.language,'US') language_code,
    ovs.org_id,
    clawback_flag
FROM
    okl_ecc_vcf_summary_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
Blitz Report™