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_SECONDARY_INVENTORIES

Line 199: from mtl_secondary_inventories MSIN

195: FUNCTION C_ONHAND_WHEREFORMULA RETURN VARCHAR2 IS
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

Line 242: MTL_SECONDARY_INVENTORIES MSI

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
246: AND MSI.SECONDARY_INVENTORY_NAME = MIQV.SUBINVENTORY_CODE;

Line 269: MTL_SECONDARY_INVENTORIES MSI

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
273: AND MSI.SECONDARY_INVENTORY_NAME = MIQV.SUBINVENTORY_CODE;