INV Subinventory quantities

Description

Imported from BI Publisher
Description: Subinventory quantities report
Application: Inventory
Source: Subinventory quantities report (XML)
Short Name: INVIRSIQ_XML
DB package: INV_INVIRSIQ_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Copy

SELECT
si.secondary_inventory_name     subinv, 
si.description                         subinv_desc,
&P_ITEM_FLEXDATA item_flexdat,
msi.description            item_description,
moqd.revision                item_revision, 
moqd.locator_id             locator_id,
&P_LOC_FLEXDATA    locator_flexdat,
msi.inventory_item_id        item_id,
msi.primary_uom_code      uom_code, 
nvl(moqd.primary_transaction_quantity,0)    item_qty, 
	decode(msi.inventory_item_id,null,null,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, 
	decode(mil.inventory_location_id,null,null,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_locator_value', 'INV', 'MTLL', 101, mil.ORGANIZATION_ID, mil.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'VALUE')) C_locator_value, 
	INV_INVIRSIQ_XMLP_PKG.cf_roundedqtyformula(:C_sum_item_qty) CF_rounded_qty
FROM 
   MTL_SYSTEM_ITEMS_VL	 msi,
   MTL_ONHAND_QUANTITIES_detail moqd,
   MTL_SECONDARY_INVENTORIES si,
   MTL_ITEM_LOCATIONS mil
WHERE 
&P_ITEM_WHERE 
and si.secondary_inventory_name = moqd.subinventory_code(+)
and si.organization_id = moqd.organization_id (+)
and moqd.organization_id = msi.organization_id(+)
and moqd.inventory_item_id = msi.inventory_item_id (+)
and moqd.locator_id = mil.inventory_location_id(+) 
and moqd.organization_id = mil.organization_id(+)
&C_SUBINV_WHERE
and si.quantity_tracked = 1
and si.organization_id = :P_ORGANIZATION_ID 
ORDER BY 
si.secondary_inventory_name, 
&P_ITEM_ORDER_BY