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_ITEM_INQ dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 62: FROM mtl_onhand_quantities_detail moq,

58: inv_item_inq.get_status_code(mln.status_id),
59: msik.serial_number_control_code,
60: moq.cost_group_id
61:
62: FROM mtl_onhand_quantities_detail moq,
63: mtl_system_items_vl msik, -- Modified for Bug # 5472330
64: mtl_item_locations_kfv milk,
65: mtl_secondary_inventories msub,
66: mtl_lot_numbers mln

Line 188: FROM mtl_onhand_quantities_detail moq,

184: msik.primary_uom_code primary_uom_code,
185: sum(nvl(moq.primary_transaction_quantity, 0)) sum_txn_qty,
186: msik.lot_control_code lot_control_code,
187: msik.serial_number_control_code serial_number_control_code
188: FROM mtl_onhand_quantities_detail moq,
189: mtl_system_items_vl msik, -- Modified for Bug # 5472330
190: mtl_item_locations_kfv milk,
191: mtl_secondary_inventories msub,
192: mtl_lot_numbers mlot,

Line 2141: FROM mtl_onhand_quantities_detail moq,

2137: NVL(msik.tracking_quantity_ind, 'P'),
2138: sum(nvl(moq.secondary_transaction_quantity, 0)),
2139: msik.secondary_uom_code
2140: -- INVCONV end
2141: FROM mtl_onhand_quantities_detail moq,
2142: mtl_system_items_vl msik, -- Modified for Bug # 5472330
2143: mtl_item_locations mil,
2144: mtl_secondary_inventories msub,
2145: mtl_lot_numbers mln

Line 2338: FROM mtl_onhand_quantities_detail moq,

2334: -- INVCONV start
2335: NVL(msik.tracking_quantity_ind, 'P') tracking_quantity_ind,
2336: msik.secondary_uom_code secondary_uom_code
2337: -- INVCONV end
2338: FROM mtl_onhand_quantities_detail moq,
2339: mtl_system_items_vl msik, -- Modified for Bug # 5472330
2340: mtl_item_locations milk,
2341: mtl_secondary_inventories msub,
2342: mtl_lot_numbers mlot,

Line 2984: FROM mtl_onhand_quantities_detail moq,

2980: msik.primary_uom_code primary_uom_code,
2981: sum(nvl(moq.primary_transaction_quantity, 0)) sum_txn_qty,
2982: msik.lot_control_code lot_control_code,
2983: msik.serial_number_control_code serial_number_control_code
2984: FROM mtl_onhand_quantities_detail moq,
2985: mtl_system_items_vl msik, /* Bug 5581528 */
2986: mtl_item_locations milk,
2987: mtl_secondary_inventories msub,
2988: mtl_material_statuses_vl mms1,