inventory item tracker

Description

Categories: Toolkit - Setup & Support
Columns: Inventory Item Id, Organization Id, Last Update Date, Last Updated By, Creation Date, Created By, Last Update Login, Summary Flag, Enabled Flag, Start Date Active ... Columns: Inventory Item Id, Organization Id, Last Update Date, Last Updated By, Creation Date, Created By, Last Update Login, Summary Flag, Enabled Flag, Start Date Active, End Date Active, Description, Buyer Id, Accounting Rule Id, Invoicing Rule Id, Segment1, Segment2, Segment3, Segment4, Segment5, Segment6, Segment7, Segment8, Segment9, Segment10, Segment11, Segment12, Segment13, Segment14, Segment15, Segment16, Segment17, Segment18, Segment19, Segment20, Attribute Category, Attribute1, Attribute2, Attribute3, Attribute4, Attribute5, Attribute6, Attribute7, Attribute8, Attribute9, Attribute10, Attribute11, Attribute12, Attribute13, Attribute14, Attribute15, Purchasing Item Flag, Shippable Item Flag, Customer Order Flag, Internal Order Flag, Service Item Flag, Inventory Item Flag, Eng Item Flag, Inventory Asset Flag, Purchasing Enabled Flag, Customer Order Enabled Flag, Internal Order Enabled Flag, So Transactions Flag, Mtl Transactions Enabled Flag, Stock Enabled Flag, Bom Enabled Flag, Build In Wip Flag, Revision Qty Control Code, Item Catalog Group Id, Catalog Status Flag, Returnable Flag, Default Shipping Org, Collateral Flag, Taxable Flag, Qty Rcv Exception Code, Allow Item Desc Update Flag, Inspection Required Flag, Receipt Required Flag, Market Price, Hazard Class Id, Rfq Required Flag, Qty Rcv Tolerance, List Price Per Unit, Un Number Id, Price Tolerance Percent, Asset Category Id, Rounding Factor, Unit Of Issue, Enforce Ship To Location Code, Allow Substitute Receipts Flag, Allow Unordered Receipts Flag, Allow Express Delivery Flag, Days Early Receipt Allowed, Days Late Receipt Allowed, Receipt Days Exception Code, Receiving Routing Id, Invoice Close Tolerance, Receive Close Tolerance, Auto Lot Alpha Prefix, Start Auto Lot Number, Lot Control Code, Shelf Life Code, Shelf Life Days, Serial Number Control Code, Start Auto Serial Number, Auto Serial Alpha Prefix, Source Type, Source Organization Id, Source Subinventory, Expense Account, Encumbrance Account, Restrict Subinventories Code, Unit Weight, Weight Uom Code, Volume Uom Code, Unit Volume, Restrict Locators Code, Location Control Code, Shrinkage Rate, Acceptable Early Days, Planning Time Fence Code, Demand Time Fence Code, Lead Time Lot Size, Std Lot Size, Cum Manufacturing Lead Time, Overrun Percentage, Mrp Calculate Atp Flag, Acceptable Rate Increase, Acceptable Rate Decrease, Cumulative Total Lead Time, Planning Time Fence Days, Demand Time Fence Days, End Assembly Pegging Flag, Repetitive Planning Flag, Ex. Set, Bom Item Type, Pick Components Flag, Replenish To Order Flag, Base Item Id, Atp Components Flag, Atp Flag, Fixed Lead Time, Variable Lead Time, Wip Supply Locator Id, Wip Supply Type, Wip Supply Subinventory, Primary Uom Code, Primary Unit Of Measure, Allowed Units Lookup Code, Cost Of Sales Account, Sales Account, Default Include In Rollup Flag, Inventory Item Status Code, Inventory Planning Code, Planner, Planning Make Buy Code, Fixed Lot Multiplier, Rounding Control Type, Carrying Cost, Postprocessing Lead Time, Preprocessing Lead Time, Full Lead Time, Order Cost, Mrp Safety Stock Percent, Mrp Safety Stock Code, Min Minmax Quantity, Max Minmax Quantity, Minimum Order Quantity, Fixed Order Quantity, Fixed Days Supply, Maximum Order Quantity, Atp Rule Id, Picking Rule Id, Reservable Type, Positive Measurement Error, Negative Measurement Error, Engineering Ecn Code, Engineering Item Id, Engineering Date, Service Starting Delay, Vendor Warranty Flag, Serviceable Component Flag, Serviceable Product Flag, Base Warranty Service Id, Payment Terms Id, Preventive Maintenance Flag, Primary Specialist Id, Secondary Specialist Id, Serviceable Item Class Id, Time Billable Flag, Material Billable Flag, Expense Billable Flag, Prorate Service Flag, Coverage Schedule Id, Service Duration Period Code, Service Duration, Warranty Vendor Id, Max Warranty Amount, Response Time Period Code, Response Time Value, New Revision Code, Invoiceable Item Flag, Tax Code, Invoice Enabled Flag, Must Use Approved Vendor Flag, Request Id, Program Application Id, Program Id, Program Update Date, Outside Operation Flag, Outside Operation Uom Type, Safety Stock Bucket Days, Auto Reduce Mps, Costing Enabled Flag, Auto Created Config Flag, Cycle Count Enabled Flag, Item Type, Model Config Clause Name, Ship Model Complete Flag, Mrp Planning Code, Return Inspection Requirement, Ato Forecast Control, Release Time Fence Code, Release Time Fence Days, Container Item Flag, Vehicle Item Flag, Maximum Load Weight, Minimum Fill Percent, Container Type Code, Internal Volume, Wh Update Date, Product Family Item Id, Global Attribute Category, Global Attribute1, Global Attribute2, Global Attribute3, Global Attribute4, Global Attribute5, Global Attribute6, Global Attribute7, Global Attribute8, Global Attribute9, Global Attribute10, Purchasing Tax Code, Overcompletion Tolerance Type, Overcompletion Tolerance Value, Effectivity Control, Check Shortages Flag, Over Shipment Tolerance, Under Shipment Tolerance, Over Return Tolerance, Under Return Tolerance, Equipment Type, Recovered Part Disp Code, Defect Tracking On Flag, Usage Item Flag, Event Flag, Electronic Flag, Downloadable Flag, Vol Discount Exempt Flag, Coupon Exempt Flag, Comms Nl Trackable Flag, Asset Creation Code, Comms Activation Reqd Flag, Orderable On Web Flag, Back Orderable Flag, Web Status, Indivisible Flag, Dimension Uom Code, Unit Length, Unit Width, Unit Height, Bulk Picked Flag, Lot Status Enabled, Default Lot Status Id, Serial Status Enabled, Default Serial Status Id, Lot Split Enabled, Lot Merge Enabled, Inventory Carry Penalty, Operation Slack Penalty, Financing Allowed Flag, Eam Item Type, Eam Activity Type Code, Eam Activity Cause Code, Eam Act Notification Flag, Eam Act Shutdown Status, Dual Uom Control, Secondary Uom Code, Dual Uom Deviation High, Dual Uom Deviation Low, Contract Item Type Code, Subscription Depend Flag, Serv Req Enabled Code, Serv Billing Enabled Flag, Serv Importance Level, Planned Inv Point Flag, Lot Translate Enabled, Default So Source Type, Create Supply Flag, Substitution Window Code, Substitution Window Days, Ib Item Instance Class, Config Model Type, Lot Substitution Enabled, Minimum License Quantity, Eam Activity Source Code, Lifecycle Id, Current Phase Id, Object Version Number, Tracking Quantity Ind, Ont Pricing Qty Source, Secondary Default Ind, Option Specific Sourced, Approval Status, Vmi Minimum Units, Vmi Minimum Days, Vmi Maximum Units, Vmi Maximum Days, Vmi Fixed Order Quantity, So Authorization Flag, Consigned Flag, Asn Autoexpire Flag, Vmi Forecast Type, Forecast Horizon, Exclude From Budget Flag, Days Tgt Inv Supply, Days Tgt Inv Window, Days Max Inv Supply, Days Max Inv Window, Drp Planned Flag, Critical Component Flag, Continous Transfer, Convergence, Divergence, Config Orgs, Config Match, Attribute16, Attribute17, Attribute18, Attribute19, Attribute20, Attribute21, Attribute22, Attribute23, Attribute24, Attribute25, Attribute26, Attribute27, Attribute28, Attribute29, Attribute30, Cas Number, Child Lot Flag, Child Lot Prefix, Child Lot Starting Number, Child Lot Validation Flag, Copy Lot Attribute Flag, Default Grade, Expiration Action Code, Expiration Action Interval, Grade Control Flag, Hazardous Material Flag, Hold Days, Lot Divisible Flag, Maturity Days, Parent Child Generation Flag, Process Costing Enabled Flag, Process Execution Enabled Flag, Process Quality Enabled Flag, Process Supply Locator Id, Process Supply Subinventory, Process Yield Locator Id, Process Yield Subinventory, Recipe Enabled Flag, Retest Interval, Charge Periodicity Code, Repair Leadtime, Repair Yield, Preposition Point, Repair Program, Subcontracting Component, Outsourced Assembly, Ego Master Items Dff Ctx, Gdsn Outbound Enabled Flag, Trade Item Descriptor, Style Item Id, Style Item Flag, Last Submitted Nir Id, Default Material Status Id, Global Attribute11, Global Attribute12, Global Attribute13, Global Attribute14, Global Attribute15, Global Attribute16, Global Attribute17, Global Attribute18, Global Attribute19, Global Attribute20, Serial Tagging Flag, Ib Item Tracking Level, Mcc Classification Type, Mcc Control Code, Mcc Tracking Code, Global Attribute21, Global Attribute22, Global Attribute23, Global Attribute24, Global Attribute25, Global Attribute26, Global Attribute27, Global Attribute28, Global Attribute29, Global Attribute30, Global Attribute31, Global Attribute32, Global Attribute33, Global Attribute34, Global Attribute35, Global Attribute36, Global Attribute37, Global Attribute38, Global Attribute39, Global Attribute40, Organization Code, Master Organization Id, Primary Cost Method, Cost Organization Id, Default Material Cost Id, Calendar Exception Set Id, Calendar Code, General Ledger Update Code, Default Atp Rule Id, Default Picking Rule Id, Default Locator Order Value, Default Subinv Order Value, Negative Inv Receipt Code, Stock Locator Control Code, Material Account, Material Overhead Account, Matl Ovhd Absorption Acct, Resource Account, Purchase Price Var Account, Ap Accrual Account, Overhead Account, Outside Processing Account, Intransit Inv Account, Interorg Receivables Account, Interorg Price Var Account, Interorg Payables Account, Interorg Transfer Cr Account, Matl Interorg Transfer Code, Interorg Trnsfr Charge Percent, Serial Number Type, Lot Number Uniqueness, Lot Number Generation, Lot Number Zero Padding, Lot Number Length, Starting Revision, Default Demand Class, Encumbrance Reversal Flag, Maintain Fifo Qty Stack Type, Invoice Price Var Account, Average Cost Var Account, Serial Number Generation, Mat Ovhd Cost Type Id, Project Reference Enabled, Pm Cost Collection Enabled, Project Control Level, Avg Rates Cost Type Id, Project Cost Account, Org Max Weight, Org Max Weight Uom Code, Org Max Volume, Org Max Volume Uom Code, Txn Approval Timeout Period, Mo Source Required, Mo Pick Confirm Required, Mo Approval Timeout Action, Borrpay Matl Var Account, Borrpay Moh Var Account, Borrpay Res Var Account, Borrpay Osp Var Account, Borrpay Ovh Var Account, Process Enabled Flag, Process Orgn Code, Wsm Enabled Flag, Default Cost Group Id, Lpn Prefix, Lpn Suffix, Lpn Starting Number, Wms Enabled Flag, Pregen Putaway Tasks Flag, Regeneration Interval, Timezone Id, Max Picks Batch, Default Wms Picking Rule Id, Default Put Away Rule Id, Default Task Assign Rule Id, Default Label Comp Rule Id, Default Carton Rule Id, Default Cyc Count Header Id, Crossdock Flag, Cartonization Flag, Cost Cutoff Date, Enable Costing By Category, Cost Group Accounting, Allocate Serial Flag, Default Pick Task Type Id, Default Cc Task Type Id, Default Putaway Task Type Id, Default Repl Task Type Id, Eam Enabled Flag, Maint Organization Id, Default Moxfer Task Type Id, Default Moissue Task Type Id, Prioritize Wip Jobs, Default Crossdock Subinventory, Skip Task Waiting Minutes, Qa Skipping Insp Flag, Default Crossdock Locator Id, Default Matl Ovhd Cost Id, Distributed Organization Flag, Carrier Manifesting Flag, Distribution Account Id, Direct Shipping Allowed, Default Pick Op Plan Id, Max Clusters Allowed, Cartonize Sales Orders, Cartonize Manufacturing, Defer Logical Transactions, Wip Overpick Enabled, Ovpk Transfer Orders Enabled, Total Lpn Length, Ucc 128 Suffix Flag, Wcs Enabled, Auto Del Alloc Flag, Rfid Verif Pcnt Threshold, Allow Different Status, Child Lot Alpha Prefix, Child Lot Number Length, Child Lot Zero Padding Flag, Create Lot Uom Conversion, Genealogy Formula Security, Rules Override Lot Reservation, Yard Management Enabled Flag, Trading Partner Org Flag, Deferred Cogs Account, Default Crossdock Criteria Id, Enforce Locator Alis Unq Flag, Epc Generation Enabled Flag, Company Prefix, Company Prefix Index, Commercial Govt Entity Number, Labor Management Enabled Flag, Default Status Id, Lcm Enabled Flag, Lcm Var Account, Opsm Enabled Flag, Allocate Lot Flag, Cat Wt Account, Yard Org Id, Yms Costing Enabled, Yms Default Subinv, Yms Default Locator, Daily Cal Start Time, Daily Cal End Time, Trading Partner Org Type, Dispatch Inbound Task, Enable Ekanban, Pick Verify So Enabled, Pick Verify Mo Enabled, Pick Verify Category Set Id, Pick Verify Wt Tolerance Pos, Pick Verify Wt Tolerance Neg, Cc Workflow Enabled Flag, Cc Approval Timeout Period, Cc Approval Timeout Action

Copy

select msib.*, mp.*
from mtl_system_items_b msib, mtl_parameters mp
where 1=1
and mp.organization_id = msib.organization_id

Parameter Name

SQL text

Validation

Organization

mp.organization_code=:organization_code

LOV

Last Update within Days

msib.last_update_date>sysdate-:days

Number

Download

Related Blitz Reports

AR Transactions and Lines Item listing GW Material Account Distribution OPM WIP Value Demo Hub Inventory mad MAD1 GMF MUV Detail GMD MUV Detail

Blitz Report In Action

Blitz Report™

Blitz Report™ provides multiple benefits:

Perfectly formatted Excel reports
Create new or ad-hoc reports in minutes
User configurable reports
Includes seeded reports for all core areas
Toolkits for tuning, management and support
Data governance and audit tracking
Central report repository & version control
Imports BI-Publisher and Discoverer reports
EBS forms interface for user adoption

Find out more

Features

Download

FAQ