ECC Lease Contracts, Streams
Description
Categories: Enterprise Command Center
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:
Description: Contract Streams
Dataset Key: okl-cv-streams
Query Procedure: OKL_CV_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure:
Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS
Contact us to schedule a demo or if you need help with the installation
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 |
|
LOV |