ECC Lease Contracts, Fees

Description
Categories: Enterprise Command Center
Columns: Contract Number, Ecc Spec Id, Org Id, Id, Start Date, End Date, Line Amount, Line Status Code, Line Type, Dnz Chr Id ...
Imported from Enterprise Command Center
Description: Contract Version Fees
Dataset Key: okl-cv-fees
Query Procedure: OKL_CV_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure:
select
x.*
from
(
SELECT * from (SELECT fees.*
		  FROM OKL_ECC_CV_FEES_V fees, okl_ecc_cv_process_t process_t
		 WHERE fees.dnz_chr_id = process_t.khr_id
		   AND process_t.incremental_flag = 'N'
		   AND language in ('US')
		   )
		   PIVOT (
		          MAX(OPERATING_UNIT) as OPERATING_UNIT,
		          MAX(LINE_NAME) as LINE_NAME ,
		          MAX(LINE_STATUS_MEANING) as LINE_STATUS_MEANING,
		          MAX(LINE_TYPE_MEANING) as LINE_TYPE_MEANING,
                          MAX(MAJOR_VERSION) AS MAJOR_VERSION
		          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