ECC Lease Contracts, Lease Invoice Applications

Description
Categories: Enterprise Command Center
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:
Run ECC Lease Contracts, Lease Invoice Applications and other Oracle EBS reports with Blitz Report™ on our demo environment
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