ECC Enterprise Asset Management, Stores Materials (Maintenance), SQL2

➜ Back to Library
Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: eam-store-mat
Query Procedure: EAM_ECC_MAT_UTIL_PVT.GET_ECC_STORES_MAT_DL_INFO
Security Procedure:
Run ECC Enterprise Asset Management, Stores Materials (Maintenance), SQL2 and other Oracle EBS reports with Blitz Report™ on our demo environment
select
x.*
from
(
SELECT eesmt.ecc_spec_id,mcikfv.concatenated_segments item_category
    FROM mtl_item_categories mci,mtl_categories_kfv mcikfv,eam_ecc_stores_mat_temp eesmt
    WHERE mci.inventory_item_id = eesmt.inventory_item_id
    AND mci.organization_id = eesmt.organization_id
    AND mci.category_id = mcikfv.category_id
) x
where
2=2
Download
 
Related Blitz Reports
ECC Enterprise Asset Management, Stores Work Order (Maintenance), SQL3 ECC Enterprise Asset Management, Stores Work Order (Maintenance), SQL2 ECC Enterprise Asset Management, Stores Materials (Maintenance), SQL1 EAM Work Orders ECC Enterprise Asset Management, Stores Work Order (Maintenance), SQL1 INV Intercompany Invoice Reconciliation INV Inventory Item Upload FND Attached Documents EAM Assets
Blitz Report™

Blitz Report™ provides multiple benefits: