ECC Contract Lifecycle Management, Requisitions, SQL13

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
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