ECC Enterprise Asset Management, Stores Work Order (Maintenance), SQL2

➜ Back to Library
Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: eam-store-wo
Query Procedure: EAM_ECC_STORES_WO_UTIL_PVT.GET_ECC_STORES_WO_DL_INFO
Security Procedure: eam_ecc_datasecurity_pkg_pub.GetFilterAttributeValues
Run ECC Enterprise Asset Management, Stores Work Order (Maintenance), SQL2 and other Oracle EBS reports with Blitz Report™ on our demo environment
select
x.*
from
(
SELECT /*+ leading(eswt) cardinality(eswt 10) push_pred(mtlmt) */  to_char (mtlmt.transaction_source_id || '-' || mtlmt.operation_seq_num || '-' ||
											mtlmt.inventory_item_id) as ECC_SPEC_ID,
											eswt.WIP_ENTITY_ID,
											eswt.operation_seq_num,
											eswt.inventory_item_id,
											mtlmt.transaction_date as MAT_ISSUE_DATES,
											ltrim(TO_CHAR(mtlmt.transaction_date,'yyyy-mm'),'0') as MAT_ISSUE_MONTHS,
											ltrim(TO_CHAR(mtlmt.transaction_date,'yyyy'),'0') as MAT_ISSUE_YEARS
											FROM mtl_material_transactions mtlmt, EAM_ECC_STORES_WO_TEMP eswt where
											mtlmt.transaction_source_id = eswt.WIP_ENTITY_ID
											and mtlmt.operation_seq_num = eswt.operation_seq_num
											and mtlmt.inventory_item_id = eswt.inventory_item_id
											and mtlmt.organization_id = eswt.organization_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), SQL1 ECC Enterprise Asset Management, Stores Materials (Maintenance), SQL1 ECC Enterprise Asset Management, Work Orders (Maintenance), SQL1 ECC Enterprise Asset Management, Work Order Operations (Maintenance) ECC Enterprise Asset Management, Stores Materials (Maintenance), SQL2 ECC Enterprise Asset Management, Work Requests (Maintenance) ECC Enterprise Asset Management, Work Order Assets (Maintenance) EAM Material Issue Request Pick List
Blitz Report™

Blitz Report™ provides multiple benefits: