ECC iProcurement, My Requisitions

Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: icx-my-reqs
Query Procedure: ICX_ECC_UTIL_PVT.get_ecc_data_load_info
Security Procedure: icx_ecc_datasecurity_pkg_pub.GetFilterAttributeValues

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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
Operating Unit
x.org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:operating_unit)
LOV