ECC Lease Contracts, Lease Invoice Lines

➜ Back to Library
Description
Categories: Enterprise Command Center
Columns: Ecc Spec Id, Line Number, Contract Number, Amount Due Original, Amount Paid, Amount Applied, Amount Credited, Tax Amount, Balance, Invoice Number ...
Imported from Enterprise Command Center
Dataset Key: okl-ar-trx-lines
Query Procedure: OKL_AR_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: 
select
x.*
from
(
SELECT * from (SELECT /*+cardinality(trxl_v.trx 10) */ trxl_v.*
			  FROM okl_ari_ecc_trxl_v        trxl_v,
				   okl_ecc_trx_process_t    trx_t
			 WHERE trxl_v.payment_schedule_id = trx_t.payment_schedule_id
			  AND trx_t.incremental_flag = 'N'
			   AND language in ('US') )
			 PIVOT (max(STREAM_TYPE) as STREAM_TYPE,
					max(STREAM_PURPOSE_MEANING) as STREAM_PURPOSE_MEANING
					for LANGUAGE in ('US' "US"))
) x
where
2=2
Parameter Name SQL text Validation
Operating Unit 
x.operating_unit_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:operating_unit)
 LOV
Sold From Org. 
x.sold_from_org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:operating_unit)
 LOV
Download
Related Blitz Reports
ECC Lease Contracts, Lease Outstanding Receivables ECC Receivables, Outstanding Receivables (1) Skeleton ecc ECC Receivables, Outstanding Receivables ECC Lease Contracts, Lease Unapplied Cash Invoices ECC Lease Contracts, Lease Invoice Applications ECC Receivables, Billing Process, SQL2 ECC Lease Contracts, Lease Receipts ECC Receivables, Payment History, SQL1
Blitz Report In Action
Blitz Report™

Blitz Report™ provides multiple benefits: