ECC Contract Lifecycle Management, Requisitions, SQL5

➜ Back to Library
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, SQL5 and other Oracle EBS reports with Blitz Report™ on our demo environment
select
x.*
from
(
 SELECT gt.char1 ECC_SPEC_ID  , EXT.HiddenAddType AS PAY_OFFICE_HiddenAddType , EXT.HiddenLKPType AS PAY_OFFICE_HiddenLKPType , EXT.addresscode_DISP AS PAY_OFFICE_addresscode , EXT.addressdetails AS PAY_OFFICE_addressdetails , EXT.addressdtlsxml AS PAY_OFFICE_addressdtlsxml , EXT.addresstype_DISP AS PAY_OFFICE_addresstype , EXT.contact_DISP AS PAY_OFFICE_contact , EXT.contactdetails AS PAY_OFFICE_contactdetails , EXT.contactdtlsxml AS PAY_OFFICE_contactdtlsxml , EXT.hiddenCountry AS PAY_OFFICE_hiddenCountry , EXT.hiddenZipCode AS PAY_OFFICE_hiddenZipCode , EXT.location_DISP AS PAY_OFFICE_location FROM PO_SESSION_GT gt  ,  EXT WHERE  gt.key = 3218981 AND ext.requisition_header_id = gt.index_num1 AND ext.addresstype = 'PAY_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
Download
Related Blitz Reports
ECC Contract Lifecycle Management, Requisitions, SQL1 ECC Contract Lifecycle Management, Solicitations, SQL7 ECC Contract Lifecycle Management, Requisitions, SQL13 ECC Contract Lifecycle Management, Requisitions, SQL8 ECC Contract Lifecycle Management, Requisitions, SQL7 ECC Contract Lifecycle Management, Requisitions, SQL6 ECC Contract Lifecycle Management, Requisitions, SQL4 ECC Contract Lifecycle Management, Requisitions, SQL3 ECC Contract Lifecycle Management, Requisitions, SQL2
Blitz Report™

Blitz Report™ provides multiple benefits:

Blitz Report™