INV Item Default Transaction Locators

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
Master data report of Inventory Items and the default locators for shipping, receiving or move order receipt transactions
Run INV Item Default Transaction Locators and other Oracle EBS reports with Blitz Report™ on our demo environment
select
msiv.concatenated_segments item,
msiv.description item_description,
xxen_util.meaning(msiv.item_type,'ITEM_TYPE',3) user_item_type,
xxen_util.meaning(mild.default_type,'MTL_DEFAULT_LOCATORS',700) default_type,
mil.subinventory_code subinventory,
inv_project.get_locator(mil.inventory_location_id,mil.organization_id) locator,
mil.description locator_description,
mp.organization_code,
haouv.name organization,
xxen_util.user_name(mild.created_by) created_by,
xxen_util.client_time(mild.creation_date) creation_date,
xxen_util.user_name(mild.last_updated_by) last_updated_by,
xxen_util.client_time(mild.last_update_date) last_update_date
from
hr_all_organization_units_vl haouv,
mtl_parameters mp,
mtl_item_loc_defaults mild,
mtl_system_items_vl msiv,
mtl_item_locations mil
where
1=1 and
haouv.organization_id=mild.organization_id and
mp.organization_id=mild.organization_id and
mild.inventory_item_id=msiv.inventory_item_id and
mild.organization_id=msiv.organization_id and
mild.organization_id=mil.organization_id and
mild.locator_id=mil.inventory_location_id
order by
msiv.concatenated_segments,
mp.organization_code,
default_type
Parameter Name SQL text Validation
Item 
msiv.concatenated_segments like :item
 LOV
Subinventory 
mild.subinventory_code=:subinventory_code
 LOV
Organization Code 
mp.organization_code=:organization_code
 LOV
Download
Related Blitz Reports
COPY OF: PO Requisition Upload CAC Calculate Average Item Costs PO Requisition Upload COPY OF: PO Requisition Upload (1) INV Physical Inventory Tags INV Item Default Transaction Subinventories EAM Assets ECC Procurement, Purchase Orders WSH Shipping/Delivery Transactions
Blitz Report™

Blitz Report™ provides multiple benefits: