ECC iProcurement, My Requisitions

Description
Categories: Enterprise Command Center
Columns: Ecc Spec Id, Req Header Id, Preparer Id, Req Total, Ecc Last Update Date, Creation Date, Change, Copy, Exp Rcv, Org Id ...
Imported from Enterprise Command Center
Dataset Key: icx-my-reqs
Query Procedure: ICX_ECC_UTIL_PVT.get_ecc_data_load_info
Security Procedure:
select
x.*
from
(
SELECT * FROM  ( select ECC_SPEC_ID,
                                            REQ_HEADER_ID,
                                            REQUISITION_NUMBER,
                                            PREPARER_ID,
                                            DESCRIPTION,
                                            REQ_TOTAL,
                                            AUTH_STATUS,
                                            ECC_LAST_UPDATE_DATE,
                                            LANGUAGE,
                                            creation_date,
                                            CHANGE,
                                            copy,
                                            exp_rcv,
					    ORG_ID
                                            from icx_my_reqs_v WHERE LANGUAGE in ( 'US') ) PIVOT(
              MAX(DESCRIPTION) AS DESCRIPTION,
              MAX(REQUISITION_NUMBER) AS REQUISITION_NUMBER,
              MAX(AUTH_STATUS) AS AUTH_STATUS
              FOR LANGUAGE IN ('US' "US"))
) x
where
2=2
Parameter Name SQL text Validation
Organization Code
x.organization_id in (select mp.organization_id from mtl_parameters mp where mp.organization_code=:organization_code)
LOV