ECC Lease Contracts, Payments
Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Description: Contract Version Payments
Dataset Key: okl-cv-payments
Query Procedure: OKL_CV_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure:
Description: Contract Version Payments
Dataset Key: okl-cv-payments
Query Procedure: OKL_CV_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure:
Run
ECC Lease Contracts, Payments and other Oracle EBS reports with Blitz Report™ on our demo environment
select x.* from ( select * from (SELECT /*+ leading(t) push_pred(oep) */ rgp_lalevl_id || '-'||version_code||'-' || chr_id||'-'||nvl(stub_amount,0)||start_Date ecc_spec_id ,rgp_lalevl_id ,chr_id contract_id ,(select org_id from okc_k_headers_all_b where id = chr_id) org_id ,major_version version_number ,contract_number ,cle_id ,lse_id ,parent_cle_id ,rul_laslh_id ,okl_cv_ecc_util_pvt.get_fee_service_name (chr_id ,cle_id ,lse_id ,parent_cle_id ,language) fee_or_service ,okl_deal_payments_pvt.get_asset_number (chr_id ,cle_id ,lse_id) asset_number ,sty_id ,sty_name ,start_date ,frequency_code ,frequency_name ,structure_code ,structure_name ,arrears_yn ,arrears_yn_name ,periods ,periodic_amount /* ,decode (count_sll ,1 ,periods ,okl_lla_util_pvt.get_lookup_meaning ('OKL_LA_PAYMENT_PERIODS' ,'MULTIPLE')) periods ,decode (count_sll ,1 ,periodic_amount ,NULL) periodic_amount*/ ,count_sll ,currency_code ,decode (interim_payment_amount ,0 ,NULL ,okl_accounting_util.format_amount (interim_payment_amount ,currency_code)) interim_payment_amount ,to_date (decode (interim_start_date ,to_date ('1' ,'j') ,NULL ,interim_start_date)) interim_start_date ,okl_accounting_util.format_amount (evg_payment_amount ,currency_code) evg_payment_amount ,okl_lla_util_pvt.get_lookup_meaning ('OKL_FREQUENCY' ,evg_frequency_code) evg_pay_freq_name, language, stub_days, stub_amount FROM OKL_ECC_CV_PAYMENTS_V oep,okl_ecc_cv_process_t t where oep.language in ('US') and oep.chr_id = t.khr_id) PIVOT ( MAX(FREQUENCY_NAME) AS FREQUENCY_NAME , MAX(STRUCTURE_NAME) AS STRUCTURE_NAME , MAX(ARREARS_YN_NAME) AS ARREARS_YN_NAME , MAX(STY_NAME) AS STY_NAME, MAX(VERSION_NUMBER) AS VERSION_NUMBER for LANGUAGE in ('US' "US")) ) x where 2=2 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Operating Unit |
|
LOV |