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 156: l_primary_quantity := inv_convert.inv_um_convert(item_id => p_item_id, lot_number => p_lot_number, organization_id => p_organization_id,

152: FROM mtl_system_items
153: WHERE organization_id = p_organization_id
154: AND inventory_item_id = p_item_id;
155:
156: l_primary_quantity := inv_convert.inv_um_convert(item_id => p_item_id, lot_number => p_lot_number, organization_id => p_organization_id,
157: PRECISION => NULL, from_quantity => p_from_quantity, from_unit => p_from_unit,
158: to_unit => l_primary_uom, from_name => NULL, to_name => NULL);
159: RETURN l_primary_quantity;
160: END get_primary_quantity;

Line 361: l_sec_quantity_cancel := inv_convert.inv_um_convert

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

Line 390: 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);

386: END IF;
387: END IF;
388: -- END
389:
390: 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);
391:
392: UPDATE mtl_transaction_lots_temp
393: SET transaction_quantity = l_mtlt_trx_qty
394: , secondary_quantity = l_mtlt_sec_trx_qty -- INVCONV

Line 603: l_sec_quantity_cancel := inv_convert.inv_um_convert

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

Line 800: 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);

796: l_transaction_qty := l_troldt_tbl(l_counter).transaction_quantity;
797: l_transaction_uom := l_troldt_tbl(l_counter).transaction_uom;
798: l_primary_uom := l_troldt_tbl(l_counter).item_primary_uom_code;
799: l_primary_qty :=
800: 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);
801: l_troldt_tbl(l_counter).primary_quantity := l_primary_qty;
802: -- nsinghi bug#5724815 Update the secondary qty too in MMTT record.
803: -- START
804: IF l_troldt_tbl(l_counter).secondary_uom_code IS NOT NULL THEN

Line 805: l_secondary_uom_qty := inv_convert.inv_um_convert

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

Line 1374: l_trolin_rec.secondary_quantity := inv_convert.inv_um_convert

1370: -- START
1371: /*Bug#8240056 secondary qty passed can not be overwriten so changin the below condition
1372: to have the recalculation only when the new secondaty qty is null */
1373: IF l_old_trolin_rec.secondary_uom IS NOT NULL AND l_trolin_rec.secondary_quantity IS NULL THEN
1374: l_trolin_rec.secondary_quantity := inv_convert.inv_um_convert
1375: ( item_id => l_trolin_rec.inventory_item_id,
1376: lot_number => l_trolin_rec.lot_number,
1377: organization_id => l_trolin_rec.organization_id,
1378: PRECISION => NULL,

Line 2766: + ABS( inv_convert.inv_um_convert

2762:
2763: ELSE
2764: IF l_fulfillment_base = 'S' THEN
2765: l_trolin_rec.quantity_delivered := NVL(l_trolin_rec.quantity_delivered, 0)
2766: + ABS( inv_convert.inv_um_convert
2767: ( item_id => l_mmtt_rec.inventory_item_id
2768: , precision => NULL
2769: , from_quantity => l_mmtt_rec.secondary_transaction_quantity
2770: , from_unit => l_mmtt_rec.secondary_uom_code

Line 2777: l_mmtt_qty_in_trolin_uom := ABS( inv_convert.inv_um_convert

2773: , to_name => NULL
2774: )
2775: );
2776:
2777: l_mmtt_qty_in_trolin_uom := ABS( inv_convert.inv_um_convert
2778: ( item_id => l_mmtt_rec.inventory_item_id
2779: , precision => NULL
2780: , from_quantity => l_mmtt_rec.secondary_transaction_quantity
2781: , from_unit => l_mmtt_rec.secondary_uom_code

Line 2788: + ABS( inv_convert.inv_um_convert

2784: , to_name => NULL
2785: ));
2786: ELSE
2787: l_trolin_rec.quantity_delivered := NVL(l_trolin_rec.quantity_delivered, 0)
2788: + ABS( inv_convert.inv_um_convert
2789: ( item_id => l_mmtt_rec.inventory_item_id
2790: , precision => NULL
2791: , from_quantity => l_mmtt_rec.PRIMARY_QUANTITY
2792: , from_unit => l_mmtt_rec.item_primary_uom_code

Line 2798: l_mmtt_qty_in_trolin_uom := ABS( inv_convert.inv_um_convert

2794: , from_name => NULL
2795: , to_name => NULL
2796: )
2797: );
2798: l_mmtt_qty_in_trolin_uom := ABS( inv_convert.inv_um_convert
2799: ( item_id => l_mmtt_rec.inventory_item_id
2800: , precision => NULL
2801: , from_quantity => l_mmtt_rec.PRIMARY_QUANTITY
2802: , from_unit => l_mmtt_rec.item_primary_uom_code

Line 2910: l_primary_shipping_quantity := inv_convert.inv_um_convert(

2906: ELSE
2907: IF l_trolin_rec.uom_code = l_mmtt_rec.item_primary_uom_code THEN
2908: l_primary_shipping_quantity := l_shipping_quantity;
2909: ELSE
2910: l_primary_shipping_quantity := inv_convert.inv_um_convert(
2911: item_id => l_mmtt_rec.inventory_item_id
2912: , PRECISION => NULL
2913: , from_quantity => l_shipping_quantity
2914: , from_unit => l_trolin_rec.uom_code

Line 2969: l_curr_mmtt_txn_qty := inv_convert.inv_um_convert(

2965: l_primary_pending_quantity := l_primary_pending_quantity + l_curr_mmtt_pri_qty ;
2966: l_sec_pending_quantity := l_sec_pending_quantity + l_curr_mmtt_sec_qty ;
2967: IF ( l_mmtt_rec.transaction_uom <> l_curr_mmtt_txn_uom ) THEN --This is to calculate the total pending qty for the mmtt in question and all the other MMTT for the MO Line ID
2968: IF( l_fulfillment_base = 'P') THEN
2969: l_curr_mmtt_txn_qty := inv_convert.inv_um_convert(
2970: item_id => l_mmtt_rec.inventory_item_id
2971: , precision => NULL
2972: , from_quantity => l_curr_mmtt_txn_qty
2973: , from_unit => l_curr_mmtt_txn_uom

Line 2995: l_curr_mmtt_txn_qty := inv_convert.inv_um_convert

2991: l_curr_mmtt_txn_qty := l_curr_mmtt_sec_qty;
2992: ELSIF(l_curr_mmtt_txn_uom = l_mmtt_rec.item_primary_uom_code) THEN
2993: l_curr_mmtt_txn_qty := l_curr_mmtt_pri_qty;
2994: ELSE
2995: l_curr_mmtt_txn_qty := inv_convert.inv_um_convert
2996: ( item_id => l_mmtt_rec.inventory_item_id
2997: , precision => NULL
2998: , from_quantity => l_curr_mmtt_sec_qty
2999: , from_unit => l_curr_mmtt_sec_uom

Line 3065: g_mo_picked_quantity_tbl(MOD(l_trolin_rec.line_id,2147483648)).picked_quantity := inv_convert.inv_um_convert(

3061: END IF;
3062:
3063: --Bug5950172. Fix starts
3064: IF (g_mo_picked_quantity_tbl(MOD(l_trolin_rec.line_id,2147483648)).picked_uom <> l_mmtt_rec.transaction_uom ) THEN
3065: g_mo_picked_quantity_tbl(MOD(l_trolin_rec.line_id,2147483648)).picked_quantity := inv_convert.inv_um_convert(
3066: item_id => l_mmtt_rec.inventory_item_id
3067: , precision => NULL
3068: , from_quantity => g_mo_picked_quantity_tbl(MOD(l_trolin_rec.line_id,2147483648)).picked_quantity
3069: , from_unit => g_mo_picked_quantity_tbl(MOD(l_trolin_rec.line_id,2147483648)).picked_uom

Line 3161: l_primary_pending_quantity := inv_convert.inv_um_convert(

3157: END IF;
3158:
3159: IF(NVL(l_fulfillment_base, 'P') = 'P') THEN
3160: IF ((l_mmtt_rec.transaction_uom <> l_mmtt_rec.item_primary_uom_code) AND l_pending_quantity <> 0) THEN
3161: l_primary_pending_quantity := inv_convert.inv_um_convert(
3162: item_id => l_mmtt_rec.inventory_item_id
3163: , PRECISION => NULL
3164: , from_quantity => l_pending_quantity
3165: , from_unit => l_mmtt_rec.transaction_uom

Line 3268: l_unalloc_quantity := inv_convert.inv_um_convert(

3264: l_unalloc_quantity := l_trolin_rec.quantity - l_trolin_rec.quantity_delivered;
3265:
3266: IF l_unalloc_quantity > 0 THEN
3267: IF l_trolin_rec.uom_code <> l_mmtt_rec.item_primary_uom_code THEN
3268: l_unalloc_quantity := inv_convert.inv_um_convert(
3269: item_id => l_mmtt_rec.inventory_item_id
3270: , PRECISION => NULL
3271: , from_quantity => l_unalloc_quantity
3272: , from_unit => l_mmtt_rec.transaction_uom