ECC Lease Contracts, Lease Invoice Applications

➜ Back to Library
Description
Categories: Enterprise Command Center
Columns: Payment Schedule Id, Ecc Spec Id, Cash Receipt Id, Receipt Number, Customer Trx Id, Invoice Number, Line Type, Line Applied, Tax Applied, Line Balance ...
Imported from Enterprise Command Center
Dataset Key: okl-ar-trx-appl
Query Procedure: OKL_AR_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: 
select
x.*
from
(
SELECT * from (SELECT  /*+cardinality(trx_t 100) */ trx_appl.*,trx_t.org_id org_id
						 FROM okl_ar_inv_appl_v        trx_appl,
							  okl_ecc_trx_process_t    trx_t
						 WHERE trx_appl.payment_schedule_id = trx_t.payment_schedule_id
						    AND trx_t.incremental_flag = 'N'
						   AND language in ('US') )
						   PIVOT (max(CURRENCY) as CURRENCY
						 for LANGUAGE in ('US' "US"))
) x
where
2=2
Parameter Name SQL text Validation
Operating Unit 
x.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 Vendor Cash Flow ECC Receivables, Billing Process, SQL2 ECC Receivables, Billing Process, SQL1 ECC Receivables, Payment History, SQL1 ECC Receivables, Outstanding Receivables (2) Skeleton ecc ECC Lease Contracts, Lease Vendor Cash Summary ECC Receivables, Outstanding Receivables ECC Receivables, Outstanding Receivables (1)
Blitz Report In Action
Blitz Report™

Blitz Report™ provides multiple benefits: