eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_INVTRSHS_XMLP_PKG dependencies on MTL_ITEM_QUANTITIES_VIEW

Line 200: ,mtl_item_quantities_view MIQV

196: BEGIN
197: IF P_ONHAND_ONLY_YN = 1 THEN
198: RETURN ('and 0 < (select NVL(SUM(DECODE(MSIN.availability_type, 1, 1, 0) * MIQV.quantity), 0)
199: from mtl_secondary_inventories MSIN
200: ,mtl_item_quantities_view MIQV
201: where MSSV.organization_id = MIQV.organization_id
202: and MSSV.inventory_item_id = MIQV.inventory_item_id
203: and MIQV.organization_id = MSIN.organization_id
204: and MIQV.subinventory_code = MSIN.secondary_inventory_name)');

Line 241: MTL_ITEM_QUANTITIES_VIEW MIQV,

237: ,0) * MIQV.QUANTITY)
238: ,0)
239: INTO SUM_QTY
240: FROM
241: MTL_ITEM_QUANTITIES_VIEW MIQV,
242: MTL_SECONDARY_INVENTORIES MSI
243: WHERE MIQV.INVENTORY_ITEM_ID = C_INVENTORY_ITEM_ID
244: AND MIQV.ORGANIZATION_ID = P_ORG_ID
245: AND MSI.ORGANIZATION_ID = P_ORG_ID

Line 268: MTL_ITEM_QUANTITIES_VIEW MIQV,

264: ,0) * MIQV.QUANTITY)
265: ,0)
266: INTO SUM_QTY
267: FROM
268: MTL_ITEM_QUANTITIES_VIEW MIQV,
269: MTL_SECONDARY_INVENTORIES MSI
270: WHERE MIQV.INVENTORY_ITEM_ID = C_INVENTORY_ITEM_ID
271: AND MIQV.ORGANIZATION_ID = P_ORG_ID
272: AND MSI.ORGANIZATION_ID = P_ORG_ID