What is the script to get item not withdrawn 2 years ago?
Hi,
I am to extract non-moving items two years ago. But there are stock numbers whose transaction dates is 2013 but has also transaction dates 2015 or 2016. Below is my script.
SELECT DISTINCT mtl.segment1 sn,
substr(mtl.description,1,30) sn_desc,
mtl.inventory_item_id,
mmt.TRANSACTION_DATE LastIssueDate,
mmt.TRANSACTION_QUANTITY LastIssueQty ,
mmt.transaction_source_id,
mmt.transaction_reference remarks,
mty.transaction_type_name,
mtst.description
FROM apps.MTL_MATERIAL_TRANSACTIONS mmt,
apps.mtl_transaction_reasons reason,
apps.mtl_transaction_types mty,
apps.mtl_txn_source_types mtst,
apps.mtl_system_items_b mtl
WHERE mmt.TRANSACTION_SOURCE_TYPE_ID in (4,13,5)