INV Locator listing

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Locator listing
Application: Inventory
Source: Locator listing (XML)
Short Name: INVSRLOC_XML
DB package: INV_INVSRLOC_XMLP_PKG
Run INV Locator listing and other Oracle EBS reports with Blitz Report™ on our demo environment
select
       a.inventory_location_id   locator_flexid,
       a.description,
       a.disable_date,
       a.picking_order,
       a.location_maximum_units,
       a.subinventory_code,
       b.unit_of_measure   location_weight_uom_code,
       a.max_weight,
       c.unit_of_measure  volume_uom_code,
       a.max_cubic_area,
       null                 c_locator_flexdat,
	fnd_flex_xml_publisher_apis.process_kff_combination_1('f_locator_flex', 'INV', 'MTLL', 101, A.ORGANIZATION_ID, A.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'VALUE') F_LOCATOR_FLEX
from
       mtl_item_locations a,
       mtl_units_of_measure b,
       mtl_units_of_measure c
where
         a.organization_id = :P_org_id
 and   a.enabled_flag = 'Y'
 and    a.volume_uom_code = c.uom_code (+)
 and   a.location_weight_uom_code  = b.uom_code(+)
order by 12,1,6,4,9,7,5,10,8
Download
 
Related Blitz Reports
WIP Required Components CAC Item List Price vs. Item Cost INV Print Kanban Cards CAC WIP Resource Efficiency with Method and Lot Variances CAC WIP Resource Efficiency INV Locator quantities JA India - OSP Pending Despatch ECC Project Manufacturing, Procurement Activities, SQL2 ECC Project Manufacturing, Procurement Activities, SQL1 CAC PO Price vs. Costing Method Comparison
Blitz Report™

Blitz Report™ provides multiple benefits: