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.WMS_PACKING_WORKBENCH_PVT dependencies on INV_CONVERT

Line 3043: , inv_convert.inv_um_convert(wpmg.inventory_item_id,null,least(mol.quantity,wpmg.quantity), mol.uom_code,p_primary_uom,null,null)

3039: SELECT wpmg.move_order_line_id
3040: , wpmg.txn_source_id
3041: , wpmg.project_id
3042: , wpmg.task_id
3043: , inv_convert.inv_um_convert(wpmg.inventory_item_id,null,least(mol.quantity,wpmg.quantity), mol.uom_code,p_primary_uom,null,null)
3044: , least(mol.quantity,wpmg.quantity)
3045: , mol.uom_code
3046: --, decode(wpmg.uom, p_transaction_uom, 0, 1) uom_match
3047: , least(mol.secondary_quantity,wpmg.secondary_quantity)

Line 3470: inv_convert.inv_um_convert(p_inventory_item_id,null,l_mol_list(l_mol_count).primary_quantity,p_primary_uom,l_mol_uom,null,null);

3466: -- the quantity may be partial of the quantity on the move order line
3467: -- which is the mol.qty less the extra qty between the available qty and p_primary_qty
3468: l_mol_list(l_mol_count).primary_quantity := l_mol_prim_qty - (l_available_qty-p_primary_qty);
3469: l_mol_list(l_mol_count).transaction_quantity :=
3470: inv_convert.inv_um_convert(p_inventory_item_id,null,l_mol_list(l_mol_count).primary_quantity,p_primary_uom,l_mol_uom,null,null);
3471: l_mol_list(l_mol_count).SECONDARY_TRANSACTION_QUANTITY :=
3472: inv_convert.inv_um_convert(p_inventory_item_id,null,l_mol_list(l_mol_count).primary_quantity,p_primary_uom,l_mol_sec_uom,null,null);--INCONV kkillams
3473: CLOSE inb_cur;
3474: EXIT;

Line 3472: inv_convert.inv_um_convert(p_inventory_item_id,null,l_mol_list(l_mol_count).primary_quantity,p_primary_uom,l_mol_sec_uom,null,null);--INCONV kkillams

3468: l_mol_list(l_mol_count).primary_quantity := l_mol_prim_qty - (l_available_qty-p_primary_qty);
3469: l_mol_list(l_mol_count).transaction_quantity :=
3470: inv_convert.inv_um_convert(p_inventory_item_id,null,l_mol_list(l_mol_count).primary_quantity,p_primary_uom,l_mol_uom,null,null);
3471: l_mol_list(l_mol_count).SECONDARY_TRANSACTION_QUANTITY :=
3472: inv_convert.inv_um_convert(p_inventory_item_id,null,l_mol_list(l_mol_count).primary_quantity,p_primary_uom,l_mol_sec_uom,null,null);--INCONV kkillams
3473: CLOSE inb_cur;
3474: EXIT;
3475: END IF;
3476: IF l_debug = 1 THEN

Line 4130: trace('Updating wpmg to decrease qty '||inv_convert.inv_um_convert(

4126: END IF; -- End Create new MMTT or update MMTT
4127:
4128: -- Update WMS_PACKING_MATERIAL_GTEMP
4129: IF l_debug = 1 THEN
4130: trace('Updating wpmg to decrease qty '||inv_convert.inv_um_convert(
4131: p_inventory_item_id,null,l_mol_list(i).transaction_quantity,l_mol_list(i).transaction_uom,'Ea',null,null));
4132: END IF;
4133: BEGIN
4134: UPDATE wms_packing_material_gtemp

Line 4136: quantity = quantity - inv_convert.inv_um_convert(

4132: END IF;
4133: BEGIN
4134: UPDATE wms_packing_material_gtemp
4135: SET selected_flag = 'Y',
4136: quantity = quantity - inv_convert.inv_um_convert(
4137: inventory_item_id,null,l_mol_list(i).transaction_quantity,l_mol_list(i).transaction_uom,uom,null,null),
4138: secondary_quantity = CASE WHEN l_mol_list(i).secondary_transaction_quantity IS NOT NULL
4139: THEN secondary_quantity - l_mol_list(i).secondary_transaction_quantity
4140: ELSE secondary_quantity

Line 4484: l_process_qty := inv_convert.inv_um_convert(p_inventory_item_id,null,p_transaction_qty,p_transaction_uom,p_primary_uom,null,null);

4480: EXCEPTION WHEN OTHERS THEN l_sum_qty := 0;
4481: END;
4482:
4483: -- Get the converted qty based on UOM.
4484: l_process_qty := inv_convert.inv_um_convert(p_inventory_item_id,null,p_transaction_qty,p_transaction_uom,p_primary_uom,null,null);
4485:
4486: IF l_debug = 1 THEN
4487: trace('l_sum_qty: ' || l_sum_qty);
4488: trace('l_process_qty: ' || l_process_qty);

Line 4555: ,quantity = quantity - inv_convert.inv_um_convert(

4551: -- Update wms_packing_material_gtemp
4552: BEGIN
4553: UPDATE wms_packing_material_gtemp
4554: SET selected_flag = 'Y'
4555: ,quantity = quantity - inv_convert.inv_um_convert(
4556: inventory_item_id,null,p_transaction_qty,p_transaction_uom,uom,null,null)
4557: WHERE inventory_item_id = p_inventory_item_id
4558: AND nvl(lot_number, '#$%') = nvl(p_lot_number, nvl(lot_number, '#$%'))
4559: AND nvl(revision, '#') = nvl(p_revision,nvl(revision, '#'))

Line 4788: ,transaction_quantity = inv_convert.inv_um_convert(

4784: ELSIF l_mtlt_qty > abs(p_quantity) THEN
4785: -- Update MTLT
4786: UPDATE mtl_transaction_lots_temp
4787: SET primary_quantity = primary_quantity - abs(p_quantity)
4788: ,transaction_quantity = inv_convert.inv_um_convert(
4789: l_item_id,null,primary_quantity - abs(p_quantity),p_uom,l_txn_uom,null,null)
4790: WHERE rowid = l_mtlt_row_id;
4791: l_row_count := SQL%ROWCOUNT;
4792: IF l_debug = 1 THEN

Line 4825: ,transaction_quantity = inv_convert.inv_um_convert(

4821: END IF;
4822: ELSIF l_mmtt_qty > abs(p_quantity) THEN
4823: UPDATE mtl_material_transactions_temp
4824: SET primary_quantity = primary_quantity - abs(p_quantity)
4825: ,transaction_quantity = inv_convert.inv_um_convert(
4826: l_item_id,null,primary_quantity - abs(p_quantity),p_uom,l_txn_uom,null,null)
4827: --INVCONV kkillams
4828: ,secondary_transaction_quantity = CASE WHEN secondary_uom_code IS NOT NULL THEN
4829: inv_convert.inv_um_convert(l_item_id,

Line 4829: inv_convert.inv_um_convert(l_item_id,

4825: ,transaction_quantity = inv_convert.inv_um_convert(
4826: l_item_id,null,primary_quantity - abs(p_quantity),p_uom,l_txn_uom,null,null)
4827: --INVCONV kkillams
4828: ,secondary_transaction_quantity = CASE WHEN secondary_uom_code IS NOT NULL THEN
4829: inv_convert.inv_um_convert(l_item_id,
4830: null,
4831: primary_quantity - abs(p_quantity),
4832: p_uom,
4833: l_sec_uom,null,null)