INV Item quantities summary

Description

Categories: BI Publisher, Logistics

Application: Inventory
Source: Item quantities summary (XML)
Short Name: INVIRISQ_XML
DB package: INV_INVIRISQ_XMLP_PKG

Copy

SELECT
&P_ITEM_FLEXDATA  item_flexdat,
msi.inventory_item_id        item_id,
msi.primary_uom_code      uom_code, 
msi.description		item_description,
round(nvl(moqd.primary_transaction_quantity,0),:P_QTY_PRECISION)    item_qty, 
--	fnd_flex_xml_publisher_apis.process_kff_combination_1('c_item_value', 'INV', 'MSTK', 101, msi.ORGANIZATION_ID, msi.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_item_value
nvl(fnd_flex_xml_publisher_apis.process_kff_combination_1('c_item_value', 'INV', 'MSTK', 101, msi.ORGANIZATION_ID, msi.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE'),&P_ITEM_FLEXDATA)  C_item_value
FROM 
   MTL_SYSTEM_ITEMS_VL	 msi,
   MTL_ONHAND_QUANTITIES_DETAIL moqd
WHERE 
&P_ITEM_WHERE 
and  msi.inventory_item_id = moqd.inventory_item_id (+)
and msi.organization_id = moqd.organization_id (+)
and msi.organization_id = :P_ORGANIZATION_ID
and msi.stock_enabled_flag = 'Y'
ORDER BY 
&P_ITEM_ORDER_BY