ECC Lease Contracts, Streams

Description
Categories: Enterprise Command Center
Columns: Ecc Spec Id, Khr Id, Contract Number, Version Code, Org Id, Kle Id, Asset Number, Fee Name, Service Name, Stream Amount ...
Imported from Enterprise Command Center
Description: Contract Streams
Dataset Key: okl-cv-streams
Query Procedure: OKL_CV_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure:
select
x.*
from
(
SELECT * from (SELECT  strm_v.stream_type||'-'||strm_v.khr_id||'-'||strm_v.kle_id||'-'||strm_v.version_code ecc_spec_id, strm_v.*
		  FROM OKL_ECC_CV_STREAMS_V strm_v, okl_ecc_cv_process_t process_t
		 WHERE strm_v.khr_id = process_t.khr_id
		   AND process_t.incremental_flag = 'N'
		   AND language in ('US')  )
		   PIVOT (MAX(STREAM_TYPE) as STREAM_TYPE ,
		          MAX(STREAM_STATUS) as STREAM_STATUS,
		          MAX(STREAM_TYPE_PURPOSE) AS STREAM_TYPE_PURPOSE,
		          MAX(PURPOSE) AS PURPOSE,
                          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