ECC Lease Contracts, Lease Invoice Lines

Description
Categories: Enterprise Command Center
Columns: Ecc Spec Id, Line Number, Contract Number, Amount Due Original, Amount Paid, Amount Applied, Amount Credited, Tax Amount, Balance, Invoice Number ...
Imported from Enterprise Command Center
Dataset Key: okl-ar-trx-lines
Query Procedure: OKL_AR_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure:
select
x.*
from
(
SELECT * from (SELECT /*+cardinality(trxl_v.trx 10) */ trxl_v.*
			  FROM okl_ari_ecc_trxl_v        trxl_v,
				   okl_ecc_trx_process_t    trx_t
			 WHERE trxl_v.payment_schedule_id = trx_t.payment_schedule_id
			  AND trx_t.incremental_flag = 'N'
			   AND language in ('US') )
			 PIVOT (max(STREAM_TYPE) as STREAM_TYPE,
					max(STREAM_PURPOSE_MEANING) as STREAM_PURPOSE_MEANING
					for LANGUAGE in ('US' "US"))
) x
where
2=2
Parameter Name SQL text Validation
Operating Unit
x.operating_unit_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:operating_unit)
LOV
Sold From Org.
x.sold_from_org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:operating_unit)
LOV