Inventory Items (APC/PLM/PIM) - EBS (MOSC)

MOSC Banner

What is the script to get item not withdrawn 2 years ago?

edited Feb 16, 2016 4:05AM in Inventory Items (APC/PLM/PIM) - EBS (MOSC) 1 commentAnswered

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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center