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 2065: FROM mtl_onhand_quantities_detail moq,

2061: NVL(msik.tracking_quantity_ind, 'P'),
2062: sum(nvl(moq.secondary_transaction_quantity, 0)),
2063: msik.secondary_uom_code
2064: -- INVCONV end
2065: FROM mtl_onhand_quantities_detail moq,
2066: mtl_system_items_vl msik, -- Modified for Bug # 5472330
2067: mtl_item_locations mil,
2068: mtl_secondary_inventories msub,
2069: mtl_lot_numbers mln

Line 2242: FROM mtl_onhand_quantities_detail moq,

2238: -- INVCONV start
2239: NVL(msik.tracking_quantity_ind, 'P') tracking_quantity_ind,
2240: msik.secondary_uom_code secondary_uom_code
2241: -- INVCONV end
2242: FROM mtl_onhand_quantities_detail moq,
2243: mtl_system_items_vl msik, -- Modified for Bug # 5472330
2244: mtl_item_locations milk,
2245: mtl_secondary_inventories msub,
2246: mtl_lot_numbers mlot,

Line 2872: FROM mtl_onhand_quantities_detail moq,

2868: msik.primary_uom_code primary_uom_code,
2869: sum(nvl(moq.primary_transaction_quantity, 0)) sum_txn_qty,
2870: msik.lot_control_code lot_control_code,
2871: msik.serial_number_control_code serial_number_control_code
2872: FROM mtl_onhand_quantities_detail moq,
2873: mtl_system_items_vl msik, /* Bug 5581528 */
2874: mtl_item_locations milk,
2875: mtl_secondary_inventories msub,
2876: mtl_material_statuses_vl mms1,