INV Item quantities summary
Description
- Categories
- BI Publisher
- Application
- Inventory
- Source
- Item quantities summary (XML)
- Short Name
- INVIRISQ_XML
- DB package
- INV_INVIRISQ_XMLP_PKG
Imported from BI Publisher
Item quantities summary
Item quantities summary
SQL 20 lines
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 |
Parameters 3
| Parameter | Type | List of values SQL |
|---|---|---|
| Items From | Char | |
| To | Char | |
| Negative quantities only | LOV Oracle |