APPS.OE_RESERVE_CONC dependencies on INV_CONVERT

Line 80: p_x_rsv_rec.derived_reserved_qty2 := inv_convert.inv_um_convert(

76: IF Nvl(p_x_rsv_rec.ordered_qty2,0) > 0 THEN
77: IF l_debug_level > 0 THEN
78: OE_DEBUG_PUB.Add('Converting secondary from primary.');
79: END IF;
80: p_x_rsv_rec.derived_reserved_qty2 := inv_convert.inv_um_convert(
81: item_id => p_x_rsv_rec.inventory_item_id
82: , lot_number => NULL
83: , organization_id => p_x_rsv_rec.ship_from_org_id
84: , PRECISION => 5

Line 675: INV_CONVERT.INV_UM_CONVERT( item_id => p_x_rsv_tbl(I).inventory_item_id,

671: IF l_debug_level > 0 THEN
672: oe_debug_pub.add( 'Before UOM convertion :' || l_total_supply || '/' || l_primary_uom, 1 ) ;
673: END IF;
674: l_total_conv_supply :=
675: INV_CONVERT.INV_UM_CONVERT( item_id => p_x_rsv_tbl(I).inventory_item_id,
676: precision => 5,
677: from_quantity => l_total_supply,
678: from_unit => l_primary_uom,
679: to_unit => p_x_rsv_tbl(I).ordered_qty_uom,

Line 719: l_temp := INV_CONVERT.INV_UM_CONVERT( item_id => p_x_rsv_tbl(I).inventory_item_id,

715: IF OE_GLOBALS.Equal(l_primary_uom ,p_x_rsv_tbl(I).ordered_qty_uom) THEN
716: g_consumed_for_lot := g_consumed_for_lot + p_x_rsv_tbl(I).derived_reserved_qty;
717: l_total_supply := l_total_supply - p_x_rsv_tbl(I).derived_reserved_qty;
718: ELSE
719: l_temp := INV_CONVERT.INV_UM_CONVERT( item_id => p_x_rsv_tbl(I).inventory_item_id,
720: precision => 5,
721: from_quantity => p_x_rsv_tbl(I).derived_reserved_qty,
722: from_unit => p_x_rsv_tbl(I).ordered_qty_uom,
723: to_unit => l_primary_uom,

Line 803: l_temp := INV_CONVERT.INV_UM_CONVERT( item_id => p_x_rsv_tbl(I).inventory_item_id,

799: IF OE_GLOBALS.Equal(l_primary_uom ,p_x_rsv_tbl(I).ordered_qty_uom) THEN
800: g_consumed_for_lot := g_consumed_for_lot + p_x_rsv_tbl(I).derived_reserved_qty;
801: l_total_supply := l_total_supply - p_x_rsv_tbl(I).derived_reserved_qty;
802: ELSE
803: l_temp := INV_CONVERT.INV_UM_CONVERT( item_id => p_x_rsv_tbl(I).inventory_item_id,
804: precision => 5,
805: from_quantity => p_x_rsv_tbl(I).derived_reserved_qty,
806: from_unit => p_x_rsv_tbl(I).ordered_qty_uom,
807: to_unit => l_primary_uom,

Line 1079: INV_CONVERT.INV_UM_CONVERT( item_id => p_inventory_item_id,

1075: THEN
1076: l_total_demand := l_total_demand + p_rsv_tbl(I).ordered_qty;
1077: ELSE
1078: l_converted_qty :=
1079: INV_CONVERT.INV_UM_CONVERT( item_id => p_inventory_item_id,
1080: precision => 5,
1081: from_quantity => p_rsv_tbl(I).ordered_qty,
1082: from_unit => p_rsv_tbl(I).ordered_qty_uom,
1083: to_unit => l_primary_uom,

Line 1196: INV_CONVERT.INV_UM_CONVERT( item_id => p_x_rsv_tbl(I).inventory_item_id,

1192: IF l_debug_level > 0 THEN
1193: oe_debug_pub.add( 'Before UOM convertion :' || l_total_supply || '/' || l_primary_uom, 1 ) ;
1194: END IF;
1195: l_total_conv_supply :=
1196: INV_CONVERT.INV_UM_CONVERT( item_id => p_x_rsv_tbl(I).inventory_item_id,
1197: precision => 5,
1198: from_quantity => l_total_supply,
1199: from_unit => l_primary_uom,
1200: to_unit => p_x_rsv_tbl(I).ordered_qty_uom,

Line 1288: l_temp:= INV_CONVERT.INV_UM_CONVERT( item_id => p_x_rsv_tbl(I).inventory_item_id,

1284: l_total_supply := l_total_supply - p_x_rsv_tbl(I).derived_reserved_qty;
1285:
1286: END IF;
1287: ELSE
1288: l_temp:= INV_CONVERT.INV_UM_CONVERT( item_id => p_x_rsv_tbl(I).inventory_item_id,
1289: precision => 5,
1290: from_quantity => p_x_rsv_tbl(I).derived_reserved_qty,
1291: from_unit => p_x_rsv_tbl(I).ordered_qty_uom,
1292: to_unit => l_primary_uom,

Line 2536: ||' OR l. ordered_quantity > (select sum(INV_CONVERT.INV_UM_CONVERT( '

2532: ||' WHERE l.line_id = mrs.demand_source_line_id)';
2533: ELSIF p_reservation_mode ='PARTIAL' THEN
2534: l_stmt := l_stmt ||' AND (NOT Exists (SELECT 1 FROM mtl_reservations mrs '
2535: ||' WHERE l.line_id = mrs.demand_source_line_id)'
2536: ||' OR l. ordered_quantity > (select sum(INV_CONVERT.INV_UM_CONVERT( '
2537: ||' l.inventory_item_id, 5, reservation_quantity, reservation_uom_code,'
2538: ||' l.order_quantity_uom, NULL, NULL)) from mtl_reservations '
2539: ||' where demand_source_line_id = l.line_id))';
2540: END IF;