[Home] [Help]
554: IF l_primary_uom <> l_replen_uom
555: THEN
556:
557: l_replen_allocated_qty
558: := INV_CONVERT.inv_um_convert
559: ( item_id => p_component_id
560: , precision => 5
561: , from_quantity => l_replen_allocated_primary_qty
562: , from_unit => l_primary_uom
868: AND
869: NVL(oola.shipped_quantity, 0) > 0
870: AND
871: jsr.allocated_primary_uom_quantity <
872: INV_CONVERT.inv_um_convert( jsr.shikyu_component_id
873: , 5
874: , oola.shipped_quantity
875: , oola.order_quantity_uom
876: , JMF_SHIKYU_UTIL.Get_Primary_Uom_Code
1372: THEN
1373:
1374: l_avail_replen_po_rec.primary_uom := l_primary_uom;
1375: l_avail_replen_po_rec.primary_uom_qty
1376: := INV_CONVERT.inv_um_convert
1377: ( item_id => p_component_id
1378: , precision => 5
1379: , from_quantity => l_avail_replen_po_rec.qty
1380: , from_unit => l_avail_replen_po_rec.uom
1563:
1564: IF l_component_uom <> l_primary_uom
1565: THEN
1566:
1567: l_new_replen_qty := INV_CONVERT.inv_um_convert
1568: ( item_id => p_component_id
1569: , precision => 5
1570: , from_quantity => p_qty
1571: , from_unit => l_primary_uom
1822:
1823: IF(l_replen_po_rec.uom <> l_component_uom)
1824: THEN
1825:
1826: l_new_replen_qty := INV_CONVERT.inv_um_convert
1827: ( item_id => p_component_id
1828: , precision => 5
1829: , from_quantity => l_replen_po_qty
1830: , from_unit => l_replen_po_rec.uom
1842: -- against
1843: IF(l_component_uom <> l_primary_uom)
1844: THEN
1845:
1846: l_new_replen_primary_qty := INV_CONVERT.inv_um_convert
1847: ( item_id => p_component_id
1848: , precision => 5
1849: , from_quantity => l_new_replen_qty
1850: , from_unit => l_component_uom
3076:
3077: IF l_replen_uom <> x_deleted_allocations_tbl(l_tbl_index).qty_uom
3078: THEN
3079:
3080: l_deleted_primary_uom_qty := INV_CONVERT.inv_um_convert
3081: ( item_id => x_deleted_allocations_tbl(l_tbl_index).component_id
3082: , precision => 5
3083: , from_quantity => x_deleted_allocations_tbl(l_tbl_index).qty
3084: , from_unit => x_deleted_allocations_tbl(l_tbl_index).qty_uom
3215: IF l_closed_so_line_rec.uom <> l_closed_so_line_rec.primary_uom
3216: THEN
3217:
3218: l_closed_so_line_rec.primary_uom_qty
3219: := INV_CONVERT.inv_um_convert
3220: ( item_id => l_closed_so_line_rec.component_id
3221: , precision => 5
3222: , from_quantity => l_closed_so_line_rec.qty
3223: , from_unit => l_closed_so_line_rec.uom
3226: , to_name => null
3227: );
3228:
3229: l_ordered_primary_qty
3230: := INV_CONVERT.inv_um_convert
3231: ( item_id => l_closed_so_line_rec.component_id
3232: , precision => 5
3233: , from_quantity => l_ordered_qty
3234: , from_unit => l_closed_so_line_rec.uom
3450: IF l_primary_uom = l_ordered_uom
3451: THEN
3452: l_shipped_primary_qty := l_shipped_qty;
3453: ELSE
3454: l_shipped_primary_qty := INV_CONVERT.inv_um_convert
3455: ( item_id => l_component_id
3456: , precision => 5
3457: , from_quantity => l_shipped_qty
3458: , from_unit => l_ordered_uom
3529: IF l_primary_uom = l_ordered_uom
3530: THEN
3531: l_allocable_qty := l_allocable_primary_qty;
3532: ELSE
3533: l_allocable_qty := INV_CONVERT.inv_um_convert
3534: ( item_id => l_component_id
3535: , precision => 5
3536: , from_quantity => l_allocable_primary_qty
3537: , from_unit => l_primary_uom
4066: IF l_uom <> l_primary_uom
4067: THEN
4068:
4069: l_primary_uom_qty
4070: := INV_CONVERT.inv_um_convert
4071: ( item_id => C_SHIKYU_REPLENISHMENT_rec.shikyu_component_id
4072: , precision => 5
4073: , from_quantity => C_SHIKYU_REPLENISHMENT_rec.oel_ordered_quantity
4074: , from_unit => l_uom
4182: IF l_uom <> l_primary_uom
4183: THEN
4184:
4185: l_primary_uom_qty
4186: := INV_CONVERT.inv_um_convert
4187: ( item_id => C_SHIKYU_REPLENISHMENT_rec.shikyu_component_id
4188: , precision => 5
4189: , from_quantity => C_child_so_lines_rec.ordered_quantity
4190: , from_unit => l_uom
4664:
4665: IF p_primary_uom_qty IS NULL
4666: THEN
4667:
4668: l_primary_uom_qty := INV_CONVERT.inv_um_convert
4669: ( item_id => p_component_id
4670: , precision => 5
4671: , from_quantity => l_ordered_qty
4672: , from_unit => l_ordered_uom
5128: || ') <> p_alloc_uom (' || p_alloc_uom || ')'
5129: );
5130: END IF;
5131:
5132: l_reduce_replen_uom_qty := INV_CONVERT.inv_um_convert
5133: ( item_id => p_component_id
5134: , precision => 5
5135: , from_quantity => l_remain_qty_to_reduce
5136: , from_unit => p_alloc_uom