Reports2017-11-18T12:27:27+00:00

INV Locator listing

Description
Categories: BI Publisher, Logistics
Application: Inventory
Source: Locator listing (XML)
Short Name: INVSRLOC_XML
DB package: INV_INVSRLOC_XMLP_PKG
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
Parameter Name SQL text Validation
Organization
 
Number
By continuing to use the site, you agree to the use of cookies. Accept