ECC Lease Contracts, Lease Receipt Allocations

Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: okl-cash-alloc
Query Procedure: OKL_AR_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: okl_ecc_datasecurity_pkg_pub.GetFilterAttributeValues
Run ECC Lease Contracts, Lease Receipt Allocations and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Blitz Report™