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

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