ECC Service Contracts, Service Contract Billing Details

➜ Back to Library
Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: oks-bill-details
Query Procedure: oks_ecc_util_pvt.get_ecc_data_load_info
Security Procedure: oks_ecc_datasecurity_pkg_pub.GetFilterAttributeValues
Run ECC Service Contracts, Service Contract Billing Details and other Oracle EBS reports with Blitz Report™ on our demo environment
select
x.*
from
(
select * from (select
okbs.id ECC_SPEC_ID,
amount AMOUNT,
okcl.dnz_chr_id CONTRACT_ID ,
date_billed_from BILL_DATE
from oks_bill_sub_lines  okbs,
okc_k_lines_b okcl
where okcl.id=okbs.cle_id
 and okcl.cle_id is not null
 and okcl.lse_id=13
 and okcl.end_date >=  NVL(fnd_date.canonical_to_date(fnd_profile.value('OKS_ECC_CONTARCT_FROM_DATE')),sysdate))
) x
where
2=2
Download
Related Blitz Reports
OKS Service Contracts Billing History ECC Service Contracts, Service Contract Details RK: AR Transactions and Lines Avalara VAT listing GL Account Analysis GL Account Analysis (Distributions) OKS Service Contracts Detail OKS Service Contracts Billing Schedule OKC Contract Lines Summary
Blitz Report™

Blitz Report™ provides multiple benefits: