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