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_TRANSFER_ORDER_PVT dependencies on INV_CONVERT

Line 154: l_primary_quantity := inv_convert.inv_um_convert(item_id => p_item_id, PRECISION => NULL, from_quantity => p_from_quantity, from_unit => p_from_unit, to_unit => l_primary_uom, from_name => NULL, to_name => NULL);

150: FROM mtl_system_items
151: WHERE organization_id = p_organization_id
152: AND inventory_item_id = p_item_id;
153:
154: l_primary_quantity := inv_convert.inv_um_convert(item_id => p_item_id, PRECISION => NULL, from_quantity => p_from_quantity, from_unit => p_from_unit, to_unit => l_primary_uom, from_name => NULL, to_name => NULL);
155: RETURN l_primary_quantity;
156: END get_primary_quantity;
157:
158: PROCEDURE delete_troldt(x_return_status OUT NOCOPY VARCHAR2, x_msg_data OUT NOCOPY VARCHAR2, x_msg_count OUT NOCOPY NUMBER, p_troldt_tbl IN inv_mo_line_detail_util.g_mmtt_tbl_type, p_move_order_type IN NUMBER) IS

Line 358: l_sec_quantity_cancel := inv_convert.inv_um_convert

354: l_mtlt_trx_qty := l_mtlt_trx_qty - l_mtlt_cancel_qty;
355: -- nsinghi bug#5724815 Determine the secondary qty to be deducted from mtlt
356: -- START
357: IF NVL(l_tracking_quantity_ind, 'P') = 'PS' AND l_mtlt_sec_trx_qty IS NOT NULL THEN
358: l_sec_quantity_cancel := inv_convert.inv_um_convert
359: ( item_id => p_item_id,
360: lot_number => l_lot_number,
361: organization_id => p_org_id,
362: PRECISION => NULL,

Line 387: l_mtlt_primary_qty := inv_convert.inv_um_convert(item_id => p_item_id, PRECISION => NULL, from_quantity => l_mtlt_trx_qty, from_unit => p_trx_uom, to_unit => p_primary_uom, from_name => NULL, to_name => NULL);

383: END IF;
384: END IF;
385: -- END
386:
387: l_mtlt_primary_qty := inv_convert.inv_um_convert(item_id => p_item_id, PRECISION => NULL, from_quantity => l_mtlt_trx_qty, from_unit => p_trx_uom, to_unit => p_primary_uom, from_name => NULL, to_name => NULL);
388:
389: UPDATE mtl_transaction_lots_temp
390: SET transaction_quantity = l_mtlt_trx_qty
391: , secondary_quantity = l_mtlt_sec_trx_qty -- INVCONV

Line 600: l_sec_quantity_cancel := inv_convert.inv_um_convert

596: l_trolin_rec.quantity_detailed := l_trolin_rec.quantity_detailed - l_quantity_cancel;
597: -- nsinghi bug#5724815 Update the secondary_quantity_detailed also. Fetch l_quantity_cancel in sec uom and deduct from secondary_quantity_detailed.
598: -- START
599: IF l_old_trolin_rec.secondary_uom IS NOT NULL THEN
600: l_sec_quantity_cancel := inv_convert.inv_um_convert
601: ( item_id => l_old_trolin_rec.inventory_item_id,
602: PRECISION => NULL,
603: from_quantity => l_quantity_cancel,
604: from_unit => l_trolin_rec.uom_code,

Line 797: inv_convert.inv_um_convert(item_id => l_troldt_tbl(l_counter).inventory_item_id, PRECISION => NULL, from_quantity => l_transaction_qty, from_unit => l_transaction_uom, to_unit => l_primary_uom, from_name => NULL, to_name => NULL);

793: l_transaction_qty := l_troldt_tbl(l_counter).transaction_quantity;
794: l_transaction_uom := l_troldt_tbl(l_counter).transaction_uom;
795: l_primary_uom := l_troldt_tbl(l_counter).item_primary_uom_code;
796: l_primary_qty :=
797: inv_convert.inv_um_convert(item_id => l_troldt_tbl(l_counter).inventory_item_id, PRECISION => NULL, from_quantity => l_transaction_qty, from_unit => l_transaction_uom, to_unit => l_primary_uom, from_name => NULL, to_name => NULL);
798: l_troldt_tbl(l_counter).primary_quantity := l_primary_qty;
799: -- nsinghi bug#5724815 Update the secondary qty too in MMTT record.
800: -- START
801: IF l_troldt_tbl(l_counter).secondary_uom_code IS NOT NULL THEN

Line 802: l_secondary_uom_qty := inv_convert.inv_um_convert

798: l_troldt_tbl(l_counter).primary_quantity := l_primary_qty;
799: -- nsinghi bug#5724815 Update the secondary qty too in MMTT record.
800: -- START
801: IF l_troldt_tbl(l_counter).secondary_uom_code IS NOT NULL THEN
802: l_secondary_uom_qty := inv_convert.inv_um_convert
803: ( item_id => l_troldt_tbl(l_counter).inventory_item_id,
804: PRECISION => NULL,
805: from_quantity => l_transaction_qty,
806: from_unit => l_transaction_uom,

Line 1363: l_trolin_rec.secondary_quantity := inv_convert.inv_um_convert

1359: l_trolin_rec.primary_quantity := get_primary_quantity(p_item_id => l_trolin_rec.inventory_item_id, p_organization_id => l_trolin_rec.organization_id, p_from_quantity => l_trolin_rec.quantity, p_from_unit => l_trolin_rec.uom_code);
1360: -- nsinghi bug#5724815 need to populate the secondary qty too for dual items.
1361: -- START
1362: IF l_old_trolin_rec.secondary_uom IS NOT NULL THEN
1363: l_trolin_rec.secondary_quantity := inv_convert.inv_um_convert
1364: ( item_id => l_trolin_rec.inventory_item_id,
1365: PRECISION => NULL,
1366: from_quantity => l_trolin_rec.quantity,
1367: from_unit => l_trolin_rec.uom_code,

Line 2701: + ABS( inv_convert.inv_um_convert

2697: l_trolin_rec.quantity_delivered := NVL(l_trolin_rec.quantity_delivered, 0)
2698: + ABS(l_mmtt_rec.transaction_quantity);
2699: ELSE
2700: l_trolin_rec.quantity_delivered := NVL(l_trolin_rec.quantity_delivered, 0)
2701: + ABS( inv_convert.inv_um_convert
2702: ( item_id => l_mmtt_rec.inventory_item_id
2703: , precision => NULL
2704: , from_quantity => l_mmtt_rec.transaction_quantity
2705: , from_unit => l_mmtt_rec.transaction_uom

Line 2792: l_primary_shipping_quantity := inv_convert.inv_um_convert(

2788: l_sec_shipping_quantity := 0;
2789: l_primary_shipping_quantity := 0;
2790: ELSE
2791: IF l_mmtt_rec.transaction_uom <> l_mmtt_rec.item_primary_uom_code THEN
2792: l_primary_shipping_quantity := inv_convert.inv_um_convert(
2793: item_id => l_mmtt_rec.inventory_item_id
2794: , PRECISION => NULL
2795: , from_quantity => l_shipping_quantity
2796: , from_unit => l_mmtt_rec.transaction_uom

Line 2845: l_curr_mmtt_txn_qty := inv_convert.inv_um_convert(

2841: EXIT WHEN mmtt_pending_qty_csr%NOTFOUND;
2842: l_primary_pending_quantity := l_primary_pending_quantity + l_curr_mmtt_pri_qty ;
2843: l_sec_pending_quantity := l_sec_pending_quantity + l_curr_mmtt_sec_qty ;
2844: IF ( l_mmtt_rec.transaction_uom <> l_curr_mmtt_txn_uom ) THEN
2845: l_curr_mmtt_txn_qty := inv_convert.inv_um_convert(
2846: item_id => l_mmtt_rec.inventory_item_id
2847: , precision => NULL
2848: , from_quantity => l_curr_mmtt_txn_qty
2849: , from_unit => l_curr_mmtt_txn_uom

Line 2904: g_mo_picked_quantity_tbl(l_trolin_rec.line_id).picked_quantity := inv_convert.inv_um_convert(

2900: END IF;
2901:
2902: --Bug5950172. Fix starts
2903: IF (g_mo_picked_quantity_tbl(l_trolin_rec.line_id).picked_uom <> l_mmtt_rec.transaction_uom ) THEN
2904: g_mo_picked_quantity_tbl(l_trolin_rec.line_id).picked_quantity := inv_convert.inv_um_convert(
2905: item_id => l_mmtt_rec.inventory_item_id
2906: , precision => NULL
2907: , from_quantity => g_mo_picked_quantity_tbl(l_trolin_rec.line_id).picked_quantity
2908: , from_unit => g_mo_picked_quantity_tbl(l_trolin_rec.line_id).picked_uom

Line 2964: l_primary_pending_quantity := inv_convert.inv_um_convert(

2960: END IF;
2961:
2962: IF (l_mmtt_rec.transaction_uom <> l_mmtt_rec.item_primary_uom_code)
2963: AND l_pending_quantity <> 0 THEN
2964: l_primary_pending_quantity := inv_convert.inv_um_convert(
2965: item_id => l_mmtt_rec.inventory_item_id
2966: , PRECISION => NULL
2967: , from_quantity => l_pending_quantity
2968: , from_unit => l_mmtt_rec.transaction_uom

Line 3057: l_unalloc_quantity := inv_convert.inv_um_convert(

3053: l_unalloc_quantity := l_trolin_rec.quantity - l_trolin_rec.quantity_delivered;
3054:
3055: IF l_unalloc_quantity > 0 THEN
3056: IF l_trolin_rec.uom_code <> l_mmtt_rec.item_primary_uom_code THEN
3057: l_unalloc_quantity := inv_convert.inv_um_convert(
3058: item_id => l_mmtt_rec.inventory_item_id
3059: , PRECISION => NULL
3060: , from_quantity => l_unalloc_quantity
3061: , from_unit => l_mmtt_rec.transaction_uom