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

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

595: IF l_debug_level > 0 THEN
596: oe_debug_pub.add( 'Before UOM convertion :' || l_total_supply || '/' || l_primary_uom, 1 ) ;
597: END IF;
598: l_total_conv_supply :=
599: INV_CONVERT.INV_UM_CONVERT( item_id => p_x_rsv_tbl(I).inventory_item_id,
600: precision => 5,
601: from_quantity => l_total_supply,
602: from_unit => l_primary_uom,
603: to_unit => p_x_rsv_tbl(I).ordered_qty_uom,

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

604: from_name => NULL,
605: to_name => NULL
606: );
607: l_total_conv_supply2 :=
608: INV_CONVERT.INV_UM_CONVERT( item_id => p_x_rsv_tbl(I).inventory_item_id,
609: precision => 5,
610: from_quantity => l_total_supply2,
611: from_unit => l_primary_uom,
612: to_unit => p_x_rsv_tbl(I).ordered_qty_uom,

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

644: IF OE_GLOBALS.Equal(l_primary_uom ,p_x_rsv_tbl(I).ordered_qty_uom) THEN
645: g_consumed_for_lot := g_consumed_for_lot + p_x_rsv_tbl(I).derived_reserved_qty;
646: l_total_supply := l_total_supply - p_x_rsv_tbl(I).derived_reserved_qty;
647: ELSE
648: l_temp := INV_CONVERT.INV_UM_CONVERT( item_id => p_x_rsv_tbl(I).inventory_item_id,
649: precision => 5,
650: from_quantity => p_x_rsv_tbl(I).derived_reserved_qty,
651: from_unit => p_x_rsv_tbl(I).ordered_qty_uom,
652: to_unit => l_primary_uom,

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

666: IF OE_GLOBALS.Equal(l_primary_uom ,p_x_rsv_tbl(I).ordered_qty_uom) THEN
667: g_consumed_for_lot2 := g_consumed_for_lot2 + nvl(p_x_rsv_tbl(I).derived_reserved_qty2,0); -- INVCONV
668: l_total_supply2 := l_total_supply2 - nvl(p_x_rsv_tbl(I).derived_reserved_qty2,0); -- INVCONV
669: ELSE
670: l_temp := INV_CONVERT.INV_UM_CONVERT( item_id => p_x_rsv_tbl(I).inventory_item_id,
671: precision => 5,
672: from_quantity => p_x_rsv_tbl(I).derived_reserved_qty2,
673: from_unit => p_x_rsv_tbl(I).ordered_qty_uom,
674: to_unit => l_primary_uom,

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

740: IF OE_GLOBALS.Equal(l_primary_uom ,p_x_rsv_tbl(I).ordered_qty_uom) THEN
741: g_consumed_for_lot := g_consumed_for_lot + p_x_rsv_tbl(I).derived_reserved_qty;
742: l_total_supply := l_total_supply - p_x_rsv_tbl(I).derived_reserved_qty;
743: ELSE
744: l_temp := INV_CONVERT.INV_UM_CONVERT( item_id => p_x_rsv_tbl(I).inventory_item_id,
745: precision => 5,
746: from_quantity => p_x_rsv_tbl(I).derived_reserved_qty,
747: from_unit => p_x_rsv_tbl(I).ordered_qty_uom,
748: to_unit => l_primary_uom,

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

763: IF OE_GLOBALS.Equal(l_primary_uom ,p_x_rsv_tbl(I).ordered_qty_uom) THEN
764: g_consumed_for_lot2 := g_consumed_for_lot2 + nvl(p_x_rsv_tbl(I).derived_reserved_qty2,0); -- INVCONV
765: l_total_supply2 := l_total_supply2 - nvl(p_x_rsv_tbl(I).derived_reserved_qty2,0); -- INVCONV
766: ELSE
767: l_temp := INV_CONVERT.INV_UM_CONVERT( item_id => p_x_rsv_tbl(I).inventory_item_id,
768: precision => 5,
769: from_quantity => p_x_rsv_tbl(I).derived_reserved_qty2,
770: from_unit => p_x_rsv_tbl(I).ordered_qty_uom,
771: to_unit => l_primary_uom,

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

1030: THEN
1031: l_total_demand := l_total_demand + p_rsv_tbl(I).ordered_qty;
1032: ELSE
1033: l_converted_qty :=
1034: INV_CONVERT.INV_UM_CONVERT( item_id => p_inventory_item_id,
1035: precision => 5,
1036: from_quantity => p_rsv_tbl(I).ordered_qty,
1037: from_unit => p_rsv_tbl(I).ordered_qty_uom,
1038: to_unit => l_primary_uom,

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

1147: IF l_debug_level > 0 THEN
1148: oe_debug_pub.add( 'Before UOM convertion :' || l_total_supply || '/' || l_primary_uom, 1 ) ;
1149: END IF;
1150: l_total_conv_supply :=
1151: INV_CONVERT.INV_UM_CONVERT( item_id => p_x_rsv_tbl(I).inventory_item_id,
1152: precision => 5,
1153: from_quantity => l_total_supply,
1154: from_unit => l_primary_uom,
1155: to_unit => p_x_rsv_tbl(I).ordered_qty_uom,

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

1156: from_name => NULL,
1157: to_name => NULL
1158: );
1159: l_total_conv_supply2 :=
1160: INV_CONVERT.INV_UM_CONVERT( item_id => p_x_rsv_tbl(I).inventory_item_id,
1161: precision => 5,
1162: from_quantity => l_total_supply2,
1163: from_unit => l_primary_uom,
1164: to_unit => p_x_rsv_tbl(I).ordered_qty_uom,

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

1231: l_total_supply := l_total_supply - p_x_rsv_tbl(I).derived_reserved_qty;
1232:
1233: END IF;
1234: ELSE
1235: l_temp:= INV_CONVERT.INV_UM_CONVERT( item_id => p_x_rsv_tbl(I).inventory_item_id,
1236: precision => 5,
1237: from_quantity => p_x_rsv_tbl(I).derived_reserved_qty,
1238: from_unit => p_x_rsv_tbl(I).ordered_qty_uom,
1239: to_unit => l_primary_uom,

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

1256: IF NVL(p_reservation_mode,'*') ='PERCENT' THEN
1257: l_total_supply2 := l_total_supply2 - p_x_rsv_tbl(I).derived_reserved_qty2; -- INVCONV from code review comments from AK
1258: END IF;
1259: ELSE
1260: l_temp := INV_CONVERT.INV_UM_CONVERT( item_id => p_x_rsv_tbl(I).inventory_item_id,
1261: precision => 5,
1262: from_quantity => p_x_rsv_tbl(I).derived_reserved_qty2,
1263: from_unit => p_x_rsv_tbl(I).ordered_qty_uom,
1264: to_unit => l_primary_uom,

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

2470: ||' WHERE l.line_id = mrs.demand_source_line_id)';
2471: ELSIF p_reservation_mode ='PARTIAL' THEN
2472: l_stmt := l_stmt ||' AND (NOT Exists (SELECT 1 FROM mtl_reservations mrs '
2473: ||' WHERE l.line_id = mrs.demand_source_line_id)'
2474: ||' OR l. ordered_quantity > (select sum(INV_CONVERT.INV_UM_CONVERT( '
2475: ||' l.inventory_item_id, 5, reservation_quantity, reservation_uom_code,'
2476: ||' l.order_quantity_uom, NULL, NULL)) from mtl_reservations '
2477: ||' where demand_source_line_id = l.line_id))';
2478: END IF;