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

Line 289: l_lot_rsv_qty_order_uom := inv_convert.inv_um_convert(

285: END IF;
286:
287: IF l_lot_conv_factor_flag > 0 THEN
288: IF (l_fulfill_base = 'S') THEN -- MUOM fulfillment Project
289: l_lot_rsv_qty_order_uom := inv_convert.inv_um_convert(
290: item_id => p_rsv_rec.inventory_item_id
291: , lot_number => p_rsv_rec.lot_number
292: , organization_id => p_rsv_rec.organization_id
293: , precision => null

Line 305: l_lot_secondary_rsv_qty := inv_convert.inv_um_convert(

301: IF (l_debug = 1) THEN
302: debug_print('Allocated qty with lots in order uom (honoring lot conversion) when fulfilment base is S :' || l_lot_rsv_qty_order_uom);
303: END IF;
304:
305: l_lot_secondary_rsv_qty := inv_convert.inv_um_convert(
306: item_id => p_rsv_rec.inventory_item_id
307: , organization_id => p_rsv_rec.organization_id
308: , precision => null
309: , from_quantity => l_lot_rsv_qty_order_uom

Line 322: l_lot_rsv_qty_order_uom := inv_convert.inv_um_convert(

318: IF (l_debug = 1) THEN
319: debug_print('l_lot_secondary_rsv_qty when fulfilment Base is S :' || l_lot_secondary_rsv_qty);
320: END IF;
321: ELSE
322: l_lot_rsv_qty_order_uom := inv_convert.inv_um_convert(
323: item_id => p_rsv_rec.inventory_item_id
324: , lot_number => p_rsv_rec.lot_number
325: , organization_id => p_rsv_rec.organization_id
326: , precision => null

Line 338: l_lot_primary_rsv_qty := inv_convert.inv_um_convert(

334: IF (l_debug = 1) THEN
335: debug_print('allocated qty with lots in order uom (honoring lot conversion) :' || l_lot_rsv_qty_order_uom);
336: END IF;
337:
338: l_lot_primary_rsv_qty := inv_convert.inv_um_convert(
339: item_id => p_rsv_rec.inventory_item_id
340: , organization_id => p_rsv_rec.organization_id
341: , precision => null
342: , from_quantity => l_lot_rsv_qty_order_uom

Line 883: inv_convert.inv_um_convert

879: -- uom of the ite,
880:
881: -- Convert order quantity into primary uom code
882: l_ordered_quantity_primary_uom :=
883: inv_convert.inv_um_convert
884: (
885: l_line_rec_inventory_item_id,
886: NULL,
887: l_line_rec_ordered_quantity,

Line 1005: l_tmp_quantity := inv_convert.inv_um_convert(

1001: -- get primary uom code for the item and org
1002: --
1003: -- compute the primary quantity
1004: -- INVCONV - upgrade call to inv_um_convert
1005: l_tmp_quantity := inv_convert.inv_um_convert(
1006: item_id => px_rsv_rec.inventory_item_id
1007: , lot_number => px_rsv_rec.lot_number
1008: , organization_id => px_rsv_rec.organization_id
1009: , PRECISION => NULL -- use default precision

Line 1051: -- Bug 2116332 - only call inv_convert if UOMs are different

1047: -- present, we will compute the reservation quantity based
1048: -- on the primary reservation quantity
1049: -- Bug 1914778 - changed ELSIF so that reservation_quantity
1050: -- is calculated again only if it is null
1051: -- Bug 2116332 - only call inv_convert if UOMs are different
1052: IF px_rsv_rec.primary_uom_code = px_rsv_rec.reservation_uom_code THEN
1053: l_tmp_quantity := px_rsv_rec.primary_reservation_quantity;
1054: -- MUOM Fulfillment project
1055: ELSIF l_fulfill_base = 'S' and px_rsv_rec.demand_source_type_id in (2,8)

Line 1061: l_tmp_quantity := inv_convert.inv_um_convert(

1057: and px_rsv_rec.secondary_reservation_quantity is not null THEN
1058: l_tmp_quantity := px_rsv_rec.secondary_reservation_quantity;
1059: ELSIF l_fulfill_base = 'S' and px_rsv_rec.demand_source_type_id in (2,8)
1060: and px_rsv_rec.secondary_reservation_quantity is not null THEN
1061: l_tmp_quantity := inv_convert.inv_um_convert(
1062: item_id => px_rsv_rec.inventory_item_id
1063: , lot_number => px_rsv_rec.lot_number
1064: , organization_id => px_rsv_rec.organization_id
1065: , PRECISION => NULL -- use default precision

Line 1081: l_tmp_quantity := inv_convert.inv_um_convert(

1077: RAISE fnd_api.g_exc_error;
1078: END IF;
1079: ELSE
1080: -- INVCONV upgrade inv_um_convert call
1081: l_tmp_quantity := inv_convert.inv_um_convert(
1082: item_id => px_rsv_rec.inventory_item_id
1083: , lot_number => px_rsv_rec.lot_number
1084: , organization_id => px_rsv_rec.organization_id
1085: , PRECISION => NULL -- use default precision

Line 1109: l_tmp_secondary_quantity := inv_convert.inv_um_convert(

1105: -- INVCONV BEGIN
1106: -- If dual control and secondary quantity is missing, calculate it
1107: IF px_rsv_rec.secondary_uom_code IS NOT NULL AND
1108: px_rsv_rec.secondary_reservation_quantity IS NULL THEN
1109: l_tmp_secondary_quantity := inv_convert.inv_um_convert(
1110: item_id => px_rsv_rec.inventory_item_id
1111: , lot_number => px_rsv_rec.lot_number
1112: , organization_id => px_rsv_rec.organization_id
1113: , PRECISION => NULL -- use default precision

Line 1137: l_tmp_secondary_quantity := inv_convert.inv_um_convert(

1133: IF ( NVL(px_rsv_rec.detailed_quantity,0) = 0 OR
1134: px_rsv_rec.detailed_quantity = fnd_api.g_miss_num ) THEN --Bug#7482123.
1135: px_rsv_rec.secondary_detailed_quantity := 0;
1136: ELSE -- convert from detailed_quantity to secondary_detailed_quantity
1137: l_tmp_secondary_quantity := inv_convert.inv_um_convert(
1138: item_id => px_rsv_rec.inventory_item_id
1139: , lot_number => px_rsv_rec.lot_number
1140: , organization_id => px_rsv_rec.organization_id
1141: , PRECISION => NULL -- use default precision

Line 14029: l_to_rsv_rec.primary_reservation_quantity := inv_convert.inv_um_convert(

14025: );
14026:
14027: IF l_fulfill_base = 'S' AND l_to_rsv_rec.supply_source_type_id <> inv_reservation_global.g_source_type_inv
14028: AND l_orig_rsv_tbl(1).supply_source_type_id = inv_reservation_global.g_source_type_inv THEN
14029: l_to_rsv_rec.primary_reservation_quantity := inv_convert.inv_um_convert(
14030: item_id => l_to_rsv_rec.inventory_item_id
14031: , lot_number => NULL
14032: , organization_id => l_to_rsv_rec.organization_id
14033: , PRECISION => NULL -- use default precision

Line 14271: l_secondary_detailed_quantity := inv_convert.inv_um_convert(

14267: END IF;
14268:
14269: IF(NVL(l_detailed_quantity,0) <> 0) THEN
14270: IF(l_secondary_detailed_quantity <0) THEN -- MUOM Fulfillment Project
14271: l_secondary_detailed_quantity := inv_convert.inv_um_convert(
14272: item_id => l_orig_rsv_tbl(1).inventory_item_id
14273: , lot_number => l_orig_rsv_tbl(1).lot_number
14274: , organization_id => l_orig_rsv_tbl(1).organization_id
14275: , PRECISION => NULL -- use default precision

Line 14346: l_new_orig_rsv_qty := inv_convert.inv_um_convert(

14342: );
14343:
14344: IF l_primary_uom_code <> l_reservation_uom_code and l_fulfill_base <> 'S' THEN
14345: -- INVCONV - Upgrade call to inv_um_convert to pass lot and org
14346: l_new_orig_rsv_qty := inv_convert.inv_um_convert(
14347: item_id => l_orig_rsv_tbl(1).inventory_item_id
14348: , lot_number => l_orig_rsv_tbl(1).lot_number
14349: , organization_id => l_orig_rsv_tbl(1).organization_id
14350: , PRECISION => NULL -- use default precision

Line 14368: l_new_orig_rsv_qty := inv_convert.inv_um_convert(

14364: -- MUOM Fulfillment project
14365: ELSIF l_orig_rsv_tbl(1).reservation_uom_code = l_orig_rsv_tbl(1).secondary_uom_code AND l_fulfill_base = 'S' THEN
14366: l_new_orig_rsv_qty := l_orig_rsv_tbl(1).secondary_reservation_quantity - NVL(l_to_rsv_rec.secondary_reservation_quantity,0);
14367: ELSIF l_orig_rsv_tbl(1).reservation_uom_code <> l_primary_uom_code AND l_orig_rsv_tbl(1).reservation_uom_code <> l_orig_rsv_tbl(1).secondary_uom_code AND l_fulfill_base = 'S' THEN
14368: l_new_orig_rsv_qty := inv_convert.inv_um_convert(
14369: item_id => l_orig_rsv_tbl(1).inventory_item_id
14370: , lot_number => l_orig_rsv_tbl(1).lot_number
14371: , organization_id => l_orig_rsv_tbl(1).organization_id
14372: , precision => null

Line 14407: l_orig_second_rsv_qty := inv_convert.inv_um_convert(

14403: l_orig_second_rsv_qty := l_new_orig_rsv_qty;
14404: ELSE
14405: -- 13604458. Calculate secondary only when l_orig_second_rsv_qty is negative
14406: IF (l_orig_second_rsv_qty < 0 ) THEN
14407: l_orig_second_rsv_qty := inv_convert.inv_um_convert(
14408: item_id => l_orig_rsv_tbl(1).inventory_item_id
14409: , lot_number => l_orig_rsv_tbl(1).lot_number
14410: , organization_id => l_orig_rsv_tbl(1).organization_id
14411: , PRECISION => NULL -- use default precision

Line 17568: l_primary_quantity := inv_convert.inv_um_convert(item_id => p_inventory_item_id

17564: debug_print('l_primary_uom_code='||l_primary_uom_code);
17565: END IF;
17566: END IF;
17567: IF l_primary_uom_code IS NOT NULL AND l_primary_uom_code<>p_uom THEN
17568: l_primary_quantity := inv_convert.inv_um_convert(item_id => p_inventory_item_id
17569: , lot_number => p_lot_number
17570: , organization_id => p_organization_id
17571: , PRECISION => NULL -- use default precision
17572: , from_quantity => p_quantity

Line 17608: l_remaining_qty := inv_convert.inv_um_convert(

17604: l_progress := 'Convert l_remaining_qty to rsv uom '||l_remaining_qty;
17605: IF ( l_remaining_qty_uom <> l_src_rsv.primary_uom_code ) THEN
17606:
17607: -- INVCONV - upgrade call to inv_um_convert to pass lot and org
17608: l_remaining_qty := inv_convert.inv_um_convert(
17609: item_id => l_src_rsv.inventory_item_id
17610: , lot_number => l_src_rsv.lot_number
17611: , organization_id => l_src_rsv.organization_id
17612: , PRECISION => NULL -- use default precision

Line 17646: l_xfr_rsv.secondary_reservation_quantity := inv_convert.inv_um_convert(

17642: debug_print('Dual tracked item so populate secondary quantities for '||l_src_rsv.secondary_uom_code);
17643: END IF;
17644: IF l_xfr_rsv.primary_reservation_quantity < l_src_rsv.primary_reservation_quantity THEN
17645: -- Transferring less than the full qty so determine the equivalent secondary
17646: l_xfr_rsv.secondary_reservation_quantity := inv_convert.inv_um_convert(
17647: item_id => l_xfr_rsv.inventory_item_id
17648: , lot_number => l_xfr_rsv.lot_number
17649: , organization_id => l_xfr_rsv.organization_id
17650: , PRECISION => NULL -- use default precision