INV Item quantities summary
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Item quantities summary
Application: Inventory
Source: Item quantities summary (XML)
Short Name: INVIRISQ_XML
DB package: INV_INVIRISQ_XMLP_PKG
Description: Item quantities summary
Application: Inventory
Source: Item quantities summary (XML)
Short Name: INVIRISQ_XML
DB package: INV_INVIRISQ_XMLP_PKG
Run
INV Item quantities summary and other Oracle EBS reports with Blitz Report™ on our demo environment
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 | |
---|---|---|---|
Items From |
|
Char | |
To |
|
Char | |
Negative quantities only |
|
LOV Oracle |