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

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
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
Parameter Name SQL text Validation
Precision
 
LOV Oracle
Organization
 
Number
Negative quantities only
 
LOV Oracle
To
 
Items From
 
By continuing to use the site, you agree to the use of cookies. Accept