ECC Contract Lifecycle Management, Requisitions, SQL2

Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Description: Requisitions Data Set
Dataset Key: po-clm-requisitions
Query Procedure: PO_ICX_CLM_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: PO_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValuesReq
Run ECC Contract Lifecycle Management, Requisitions, SQL2 and other Oracle EBS reports with Blitz Report™ on our demo environment
select
x.*
from
(
 SELECT gt.char1 ECC_SPEC_ID  , EXT.HiddenAddType AS COTR_OFFICE_HiddenAddType , EXT.HiddenLKPType AS COTR_OFFICE_HiddenLKPType , EXT.addresscode_DISP AS COTR_OFFICE_addresscode , EXT.addressdetails AS COTR_OFFICE_addressdetails , EXT.addressdtlsxml AS COTR_OFFICE_addressdtlsxml , EXT.addresstype_DISP AS COTR_OFFICE_addresstype , EXT.contact_DISP AS COTR_OFFICE_contact , EXT.contactdetails AS COTR_OFFICE_contactdetails , EXT.contactdtlsxml AS COTR_OFFICE_contactdtlsxml , EXT.hiddenCountry AS COTR_OFFICE_hiddenCountry , EXT.hiddenZipCode AS COTR_OFFICE_hiddenZipCode , EXT.location_DISP AS COTR_OFFICE_location FROM PO_SESSION_GT gt  ,  EXT WHERE  gt.key = 3218981 AND ext.requisition_header_id = gt.index_num1 AND ext.addresstype = 'COTR_OFFICE' 
) 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
Blitz Report™