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 3116: , inv_convert.inv_um_convert(wpmg.inventory_item_id,null,least(mol.quantity,wpmg.quantity), mol.uom_code,p_primary_uom,null,null)

3112: SELECT wpmg.move_order_line_id
3113: , wpmg.txn_source_id
3114: , wpmg.project_id
3115: , wpmg.task_id
3116: , inv_convert.inv_um_convert(wpmg.inventory_item_id,null,least(mol.quantity,wpmg.quantity), mol.uom_code,p_primary_uom,null,null)
3117: , least(mol.quantity,wpmg.quantity)
3118: , mol.uom_code
3119: --, decode(wpmg.uom, p_transaction_uom, 0, 1) uom_match
3120: , least(mol.secondary_quantity,wpmg.secondary_quantity)

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

3148: SELECT wpmg.move_order_line_id
3149: , wpmg.txn_source_id
3150: , wpmg.project_id
3151: , wpmg.task_id
3152: , inv_convert.inv_um_convert(wpmg.inventory_item_id,null,least(mol.quantity,wpmg.quantity), mol.uom_code,p_primary_uom,null,null)
3153: , least(mol.quantity,wpmg.quantity)
3154: , mol.uom_code
3155: --, decode(wpmg.uom, p_transaction_uom, 0, 1) uom_match
3156: , least(mol.secondary_quantity,wpmg.secondary_quantity)

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

3190: SELECT wpmg.move_order_line_id
3191: , wpmg.txn_source_id
3192: , wpmg.project_id
3193: , wpmg.task_id
3194: , inv_convert.inv_um_convert(wpmg.inventory_item_id,null,least(mol.quantity,wpmg.quantity), mol.uom_code,p_primary_uom,null,null)
3195: , least(mol.quantity,wpmg.quantity)
3196: , mol.uom_code
3197: --, decode(wpmg.uom, p_transaction_uom, 0, 1) uom_match
3198: , least(mol.secondary_quantity,wpmg.secondary_quantity)

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

3632: -- the quantity may be partial of the quantity on the move order line
3633: -- which is the mol.qty less the extra qty between the available qty and p_primary_qty
3634: l_mol_list(l_mol_count).primary_quantity := l_mol_prim_qty - (l_available_qty-p_primary_qty);
3635: l_mol_list(l_mol_count).transaction_quantity :=
3636: 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);
3637: l_mol_list(l_mol_count).SECONDARY_TRANSACTION_QUANTITY :=
3638: 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
3639: CLOSE inb_cur;
3640: EXIT;

Line 3638: 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

3634: l_mol_list(l_mol_count).primary_quantity := l_mol_prim_qty - (l_available_qty-p_primary_qty);
3635: l_mol_list(l_mol_count).transaction_quantity :=
3636: 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);
3637: l_mol_list(l_mol_count).SECONDARY_TRANSACTION_QUANTITY :=
3638: 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
3639: CLOSE inb_cur;
3640: EXIT;
3641: END IF;
3642: IF l_debug = 1 THEN

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

4292: END IF; -- End Create new MMTT or update MMTT
4293:
4294: -- Update WMS_PACKING_MATERIAL_GTEMP
4295: IF l_debug = 1 THEN
4296: trace('Updating wpmg to decrease qty '||inv_convert.inv_um_convert(
4297: p_inventory_item_id,null,l_mol_list(i).transaction_quantity,l_mol_list(i).transaction_uom,'Ea',null,null));
4298: END IF;
4299: BEGIN
4300: UPDATE wms_packing_material_gtemp

Line 4302: quantity = quantity - inv_convert.inv_um_convert(

4298: END IF;
4299: BEGIN
4300: UPDATE wms_packing_material_gtemp
4301: SET selected_flag = 'Y',
4302: quantity = quantity - inv_convert.inv_um_convert(
4303: inventory_item_id,null,l_mol_list(i).transaction_quantity,l_mol_list(i).transaction_uom,uom,null,null),
4304: secondary_quantity = CASE WHEN l_mol_list(i).secondary_transaction_quantity IS NOT NULL
4305: THEN secondary_quantity - l_mol_list(i).secondary_transaction_quantity
4306: ELSE secondary_quantity

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

4646: EXCEPTION WHEN OTHERS THEN l_sum_qty := 0;
4647: END;
4648:
4649: -- Get the converted qty based on UOM.
4650: l_process_qty := inv_convert.inv_um_convert(p_inventory_item_id,null,p_transaction_qty,p_transaction_uom,p_primary_uom,null,null);
4651:
4652: IF l_debug = 1 THEN
4653: trace('l_sum_qty: ' || l_sum_qty);
4654: trace('l_process_qty: ' || l_process_qty);

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

4717: -- Update wms_packing_material_gtemp
4718: BEGIN
4719: UPDATE wms_packing_material_gtemp
4720: SET selected_flag = 'Y'
4721: ,quantity = quantity - inv_convert.inv_um_convert(
4722: inventory_item_id,null,p_transaction_qty,p_transaction_uom,uom,null,null)
4723: WHERE inventory_item_id = p_inventory_item_id
4724: AND nvl(lot_number, '#$%') = nvl(p_lot_number, nvl(lot_number, '#$%'))
4725: AND nvl(revision, '#') = nvl(p_revision,nvl(revision, '#'))

Line 4954: ,transaction_quantity = inv_convert.inv_um_convert(

4950: ELSIF l_mtlt_qty > abs(p_quantity) THEN
4951: -- Update MTLT
4952: UPDATE mtl_transaction_lots_temp
4953: SET primary_quantity = primary_quantity - abs(p_quantity)
4954: ,transaction_quantity = inv_convert.inv_um_convert(
4955: l_item_id,null,primary_quantity - abs(p_quantity),p_uom,l_txn_uom,null,null)
4956: WHERE rowid = l_mtlt_row_id;
4957: l_row_count := SQL%ROWCOUNT;
4958: IF l_debug = 1 THEN

Line 4991: ,transaction_quantity = inv_convert.inv_um_convert(

4987: END IF;
4988: ELSIF l_mmtt_qty > abs(p_quantity) THEN
4989: UPDATE mtl_material_transactions_temp
4990: SET primary_quantity = primary_quantity - abs(p_quantity)
4991: ,transaction_quantity = inv_convert.inv_um_convert(
4992: l_item_id,null,primary_quantity - abs(p_quantity),p_uom,l_txn_uom,null,null)
4993: --INVCONV kkillams
4994: ,secondary_transaction_quantity = CASE WHEN secondary_uom_code IS NOT NULL THEN
4995: inv_convert.inv_um_convert(l_item_id,

Line 4995: inv_convert.inv_um_convert(l_item_id,

4991: ,transaction_quantity = inv_convert.inv_um_convert(
4992: l_item_id,null,primary_quantity - abs(p_quantity),p_uom,l_txn_uom,null,null)
4993: --INVCONV kkillams
4994: ,secondary_transaction_quantity = CASE WHEN secondary_uom_code IS NOT NULL THEN
4995: inv_convert.inv_um_convert(l_item_id,
4996: null,
4997: primary_quantity - abs(p_quantity),
4998: p_uom,
4999: l_sec_uom,null,null)