ECC Lease Contracts, Lease Receipt Applications

Description
Categories: Enterprise Command Center
Columns: Ecc Spec Id, Cash Receipt Id, Receipt Number, Customer Trx Id, Invoice Number, Line Type, Line Applied, Tax Applied, Line Balance, Tax Balance ...
Imported from Enterprise Command Center
Dataset Key: okl-cash-appl
Query Procedure: OKL_AR_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure:
select
x.*
from
(
SELECT * from (SELECT appl.*,process_t.org_id org_id
		   FROM okl_rcpt_applications_uv appl,
				okl_ecc_process_t process_t
		 WHERE appl.cash_receipt_id = process_t.id
       		   AND language in ('US')
		   AND process_t.incremental_flag = 'N'
		   AND process_t.record_type = 'ARCASHRCPT')
		PIVOT (max(CURRENCY) as CURRENCY
			  for LANGUAGE in ('US' "US"))
) x
where
2=2
Parameter NameSQL textValidation
Operating Unit
x.org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:operating_unit)
LOV