ECC iProcurement, My Requisitions

➜ Back to Library
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
Run ECC iProcurement, My Requisitions and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Download
 
Related Blitz Reports
ECC Procurement, Requisitions ECC iProcurement, iProcurement Frequently Requested Items, SQL1 ECC iProcurement, iProcurement Top Categories, SQL1 ECC Sourcing, Negotiations, SQL1 ICX Military Interdepartmental Purchase Request ECC iStore, iStore Search ECC Project Procurement, Procurement Plan HXT Time Entry Detail MRP Financial Analysis
Blitz Report™

Blitz Report™ provides multiple benefits: