ECC Contract Lifecycle Management, Requisitions, SQL13

➜ 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, SQL13 and other Oracle EBS reports with Blitz Report™ on our demo environment
select
x.*
from
(
SELECT gt.char1 ecc_spec_id, prl.requisition_line_id ,
                                       CASE WHEN EXT.FSC_PSC_DISP IS NULL THEN 'NA'
                                        ELSE ext.FSC_PSC_DISP
                                        END FSC_PSC FROM PO_SESSION_GT gt,
                                       ECC_REQ_LINE_FED_CUST_DESG_AGV EXT , po_requisition_lines_all prl
                                       WHERE
                                       prl.requisition_line_id = ext.requisition_line_id (+)
                                       and prl.requisition_line_id = gt.index_num2
                                       AND gt.KEY =3218981
) 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, SQL9 ECC Project Procurement, Procurement Plan ECC Procurement, Purchase Orders ECC Contract Lifecycle Management, Requisitions, SQL12 ECC Contract Lifecycle Management, Solicitations, SQL2 ECC Procurement, Indirect Procurement, SQL4 ECC Procurement, Indirect Procurement, SQL3 ECC Procurement, Indirect Procurement, SQL1 ECC Procurement, Agreements
Blitz Report™

Blitz Report™ provides multiple benefits:

Blitz Report™