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

Description
Categories: Enterprise Command Center
Columns: Ecc Spec Id, Mat Issue Dates, Mat Issue Months, Mat Issue Years ...
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
select
x.*
from
(
SELECT to_char (mtlmt.transaction_source_id || '-' || mtlmt.operation_seq_num || '-' ||
											mtlmt.inventory_item_id) as ECC_SPEC_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