INV Locator listing

Description

Imported from BI Publisher
Description: Locator listing
Application: Inventory
Source: Locator listing (XML)
Short Name: INVSRLOC_XML
DB package: INV_INVSRLOC_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Copy

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