Inventory Listing

➜ Back to Library
Description
select mp.*, msib.*
from mtl_system_items_b msib, mtl_parameters mp
where 1=1
and mp.organization_id=msib.organization_id
Parameter NameSQL textValidation
Organization Code
mp.organization_code = :p_org_code
LOV
Last Update within Days
msib.last_update_date>sysdate-:days
Number
Download
Related Blitz Reports
XXFJ CST Inventory Value - Multi-Organization (Item Costs) Inventory mad CAC Inventory Pending Cost Adjustment - No Currencies CAC WIP Jobs With Complete Status Which Are Ready for Close CAC Inventory Lot and Locator OPM Value (Period-End) MAD1 GMF MUV Detail GMD MUV Detail TB GL Account Analysis (Drilldown)v2 inventory item tracker
Blitz Report™