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

Line 251: ----bug 8526601 added lot number and org id to make the inv_convert call lot specific

247: IF v_mmtt_rec.transaction_uom <> l_temp_uom_code THEN --Added bug 3984746
248: IF v_mmtt_rec.primary_quantity < 0 THEN
249: l_sign := -1;
250: END IF; --End of bug fix3984746
251: ----bug 8526601 added lot number and org id to make the inv_convert call lot specific
252: /*IF (v_mmtt_rec.transaction_quantity = l_wlc_trx_qty) THEN
253: v_mmtt_rec.primary_quantity := l_wlc_prim_qty;
254: ELSE
255: v_mmtt_rec.primary_quantity :=

Line 256: inv_convert.inv_um_convert(v_mmtt_rec.inventory_item_id,v_mmtt_rec.lot_number,v_mmtt_rec.organization_id,5, abs(v_mmtt_rec.transaction_quantity), v_mmtt_rec.transaction_uom

252: /*IF (v_mmtt_rec.transaction_quantity = l_wlc_trx_qty) THEN
253: v_mmtt_rec.primary_quantity := l_wlc_prim_qty;
254: ELSE
255: v_mmtt_rec.primary_quantity :=
256: inv_convert.inv_um_convert(v_mmtt_rec.inventory_item_id,v_mmtt_rec.lot_number,v_mmtt_rec.organization_id,5, abs(v_mmtt_rec.transaction_quantity), v_mmtt_rec.transaction_uom
257: , l_temp_uom_code, NULL, NULL);
258: END IF;
259:
260: IF (v_mmtt_rec.primary_quantity = -99999) THEN --Changed from '<=' bug 3984746

Line 666: --bug 8526601 added lot number and org id to make the inv_convert call lot specific

662: FROM mtl_system_items
663: WHERE inventory_item_id = curlpnrec.content_item_id
664: AND organization_id = curlpnrec.organization_id;
665:
666: --bug 8526601 added lot number and org id to make the inv_convert call lot specific
667: --l_primary_qty := inv_convert.inv_um_convert(curlpnrec.content_item_id,curlpnrec.lot_number,curlpnrec.organization_id,5, curlpnrec.quantity, curlpnrec.uom, l_primary_uom, NULL, NULL);
668:
669: /*IF (l_primary_qty <= -99999) THEN
670: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');

Line 667: --l_primary_qty := inv_convert.inv_um_convert(curlpnrec.content_item_id,curlpnrec.lot_number,curlpnrec.organization_id,5, curlpnrec.quantity, curlpnrec.uom, l_primary_uom, NULL, NULL);

663: WHERE inventory_item_id = curlpnrec.content_item_id
664: AND organization_id = curlpnrec.organization_id;
665:
666: --bug 8526601 added lot number and org id to make the inv_convert call lot specific
667: --l_primary_qty := inv_convert.inv_um_convert(curlpnrec.content_item_id,curlpnrec.lot_number,curlpnrec.organization_id,5, curlpnrec.quantity, curlpnrec.uom, l_primary_uom, NULL, NULL);
668:
669: /*IF (l_primary_qty <= -99999) THEN
670: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
671: fnd_message.set_token('uom1', curlpnrec.uom);

Line 748: ----bug 8526601 added lot number and org id as IN parameters to make the inv_convert call lot specific

744: RETURN 0;
745: END;
746: /* Bug#5486052. Added the below function. This function takes itemID, quantity and 2 UOM codes as input parameters.
747: * It returns the quantity, which was expressed in the 1st UOM, converted to the 2nd UOM.*/
748: ----bug 8526601 added lot number and org id as IN parameters to make the inv_convert call lot specific
749: FUNCTION get_converted_qty(p_inventory_item_id NUMBER,p_lot_number VARCHAR2,p_organization_id NUMBER, p_qty NUMBER, p_uom1 VARCHAR2, p_uom2 VARCHAR2)
750: RETURN NUMBER IS
751: l_converted_qty NUMBER;
752: BEGIN

Line 753: ----bug 8526601 added lot number and org id to make the inv_convert call lot specific

749: FUNCTION get_converted_qty(p_inventory_item_id NUMBER,p_lot_number VARCHAR2,p_organization_id NUMBER, p_qty NUMBER, p_uom1 VARCHAR2, p_uom2 VARCHAR2)
750: RETURN NUMBER IS
751: l_converted_qty NUMBER;
752: BEGIN
753: ----bug 8526601 added lot number and org id to make the inv_convert call lot specific
754: l_converted_qty := inv_convert.inv_um_convert( p_inventory_item_id
755: ,p_lot_number
756: ,p_organization_id
757: , 6

Line 754: l_converted_qty := inv_convert.inv_um_convert( p_inventory_item_id

750: RETURN NUMBER IS
751: l_converted_qty NUMBER;
752: BEGIN
753: ----bug 8526601 added lot number and org id to make the inv_convert call lot specific
754: l_converted_qty := inv_convert.inv_um_convert( p_inventory_item_id
755: ,p_lot_number
756: ,p_organization_id
757: , 6
758: , p_qty

Line 1019: ----bug 8526601 added lot number and org id to make the inv_convert call lot specific

1015: itemqtychanged := TRUE;
1016: /*Bug#5486052. If the UOM of the current record is not same as that of the last record,
1017: then convert the qty of the current record into the UOM of the last record.*/
1018: IF ( lastuom <> curlpnrec.uom ) THEN
1019: ----bug 8526601 added lot number and org id to make the inv_convert call lot specific
1020: l_converted_qty := get_converted_qty( curlpnrec.content_item_id
1021: ,curlpnrec.lot_number
1022: ,curlpnrec.organization_id
1023: , curlpnrec.quantity

Line 1391: ----bug 8526601 added lot number and org id to make the inv_convert call lot specific

1387: EXCEPTION WHEN OTHERS THEN
1388: NULL;
1389: END;
1390: If ( curlpnrec.uom <> l_primary_uom ) THEN
1391: ----bug 8526601 added lot number and org id to make the inv_convert call lot specific
1392: l_conv_fact := get_converted_qty( curlpnrec.content_item_id
1393: ,curlpnrec.lot_number
1394: ,curlpnrec.organization_id
1395: , 1

Line 2813: ----bug 8526601 added lot number and org id to make the inv_convert call lot specific

2809: CLOSE del_serial_cursor;
2810:
2811: -- Convert split quantity from primary UOM into the UOM of the WDD line if different
2812: IF (p_uom_code <> dd_rec.requested_quantity_uom) THEN
2813: ----bug 8526601 added lot number and org id to make the inv_convert call lot specific
2814: l_split_quantity :=
2815: inv_convert.inv_um_convert(p_item_rec.inventory_item_id,p_lot_number,p_organization_id, 5, l_split_quantity, p_uom_code, dd_rec.requested_quantity_uom, NULL
2816: , NULL);
2817:

Line 2815: inv_convert.inv_um_convert(p_item_rec.inventory_item_id,p_lot_number,p_organization_id, 5, l_split_quantity, p_uom_code, dd_rec.requested_quantity_uom, NULL

2811: -- Convert split quantity from primary UOM into the UOM of the WDD line if different
2812: IF (p_uom_code <> dd_rec.requested_quantity_uom) THEN
2813: ----bug 8526601 added lot number and org id to make the inv_convert call lot specific
2814: l_split_quantity :=
2815: inv_convert.inv_um_convert(p_item_rec.inventory_item_id,p_lot_number,p_organization_id, 5, l_split_quantity, p_uom_code, dd_rec.requested_quantity_uom, NULL
2816: , NULL);
2817:
2818: IF (l_remaining_quantity < 0) THEN
2819: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');

Line 2834: ----bug 8526601 added lot number and org id to make the inv_convert call lot specific

2830:
2831: IF (l_split_quantity > 0) THEN
2832: IF (l_remaining_qty_uom <> dd_rec.requested_quantity_uom) THEN
2833: -- convert remaining quantity into the UOM of the WDD line
2834: ----bug 8526601 added lot number and org id to make the inv_convert call lot specific
2835: l_remaining_quantity :=
2836: inv_convert.inv_um_convert(p_item_rec.inventory_item_id,p_lot_number,p_organization_id, 5, l_remaining_quantity, l_remaining_qty_uom
2837: , dd_rec.requested_quantity_uom, NULL, NULL);
2838:

Line 2836: inv_convert.inv_um_convert(p_item_rec.inventory_item_id,p_lot_number,p_organization_id, 5, l_remaining_quantity, l_remaining_qty_uom

2832: IF (l_remaining_qty_uom <> dd_rec.requested_quantity_uom) THEN
2833: -- convert remaining quantity into the UOM of the WDD line
2834: ----bug 8526601 added lot number and org id to make the inv_convert call lot specific
2835: l_remaining_quantity :=
2836: inv_convert.inv_um_convert(p_item_rec.inventory_item_id,p_lot_number,p_organization_id, 5, l_remaining_quantity, l_remaining_qty_uom
2837: , dd_rec.requested_quantity_uom, NULL, NULL);
2838:
2839: IF (l_remaining_quantity < 0) THEN
2840: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');

Line 5447: l_secondary_trx_quantity := inv_convert.inv_um_convert(

5443: IF inv_cache.set_item_rec(p_organization_id => p_organization_id, p_item_id => p_inventory_item_id) THEN
5444: IF inv_cache.item_rec.tracking_quantity_ind = 'PS' THEN
5445: IF l_secondary_trx_quantity IS NULL THEN
5446: IF inv_cache.item_rec.secondary_default_ind = 'F' THEN
5447: l_secondary_trx_quantity := inv_convert.inv_um_convert(
5448: item_id => p_inventory_item_id
5449: , lot_number => p_lot_number
5450: , organization_id => p_organization_id
5451: , precision => NULL