ECC Lease Contracts, Lease Receipt Allocations

Description
Categories: Enterprise Command Center
Columns: Ecc Spec Id, Cash Receipt Id, Receipt Number, Allocated Amount, Allocated Line Amount, Allocated Tax Amount, Applied Line Amount, Applied Tax Amount, Allocated Line Balance, Allocated Tax Balance ...
Imported from Enterprise Command Center
Dataset Key: okl-cash-alloc
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_allocations_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 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