INV Locator listing
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
Description: Locator listing
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 |