ECC Service Contracts, Service Contract Billing Details

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
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