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
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
Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS
Contact us to schedule a demo or if you need help with the installation
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 |
|
LOV |