INV Item quantities summary

➜ Back to Library

Description
Categories: BI Publisher, Logistics Application: Inventory Source: Item quantities summary (XML) Short Name: INVIRISQ_XML DB package: INV_INVIRISQ_XMLP_PKG more less

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

Parameter Name

SQL text

Validation

Precision

LOV Oracle

Organization

Number

Negative quantities only

LOV Oracle

Items From

Download

Related Blitz Reports
INV Subinventory quantities INV Inventory Aging INV Locator quantities GMD Item/Location Required Analysis INV Expired lots WIP Discrete Job Pick List WIP Discrete Job Shortage Inventory Reconciliation WIP Repetitive Schedule Shortage