[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
871: AND
872: NVL(oola.shipped_quantity, 0) > 0
873: AND
874: jsr.allocated_primary_uom_quantity <
875: INV_CONVERT.inv_um_convert( jsr.shikyu_component_id
876: , 5
877: , oola.shipped_quantity
878: , oola.order_quantity_uom
879: , JMF_SHIKYU_UTIL.Get_Primary_Uom_Code
1378: THEN
1379:
1380: l_avail_replen_po_rec.primary_uom := l_primary_uom;
1381: l_avail_replen_po_rec.primary_uom_qty
1382: := INV_CONVERT.inv_um_convert
1383: ( item_id => p_component_id
1384: , precision => 5
1385: , from_quantity => l_avail_replen_po_rec.qty
1386: , from_unit => l_avail_replen_po_rec.uom
1569:
1570: IF l_component_uom <> l_primary_uom
1571: THEN
1572:
1573: l_new_replen_qty := INV_CONVERT.inv_um_convert
1574: ( item_id => p_component_id
1575: , precision => 5
1576: , from_quantity => p_qty
1577: , from_unit => l_primary_uom
1828:
1829: IF(l_replen_po_rec.uom <> l_component_uom)
1830: THEN
1831:
1832: l_new_replen_qty := INV_CONVERT.inv_um_convert
1833: ( item_id => p_component_id
1834: , precision => 5
1835: , from_quantity => l_replen_po_qty
1836: , from_unit => l_replen_po_rec.uom
1848: -- against
1849: IF(l_component_uom <> l_primary_uom)
1850: THEN
1851:
1852: l_new_replen_primary_qty := INV_CONVERT.inv_um_convert
1853: ( item_id => p_component_id
1854: , precision => 5
1855: , from_quantity => l_new_replen_qty
1856: , from_unit => l_component_uom
3095:
3096: IF l_replen_uom <> x_deleted_allocations_tbl(l_tbl_index).qty_uom
3097: THEN
3098:
3099: l_deleted_primary_uom_qty := INV_CONVERT.inv_um_convert
3100: ( item_id => x_deleted_allocations_tbl(l_tbl_index).component_id
3101: , precision => 5
3102: , from_quantity => x_deleted_allocations_tbl(l_tbl_index).qty
3103: , from_unit => x_deleted_allocations_tbl(l_tbl_index).qty_uom
3310: IF l_closed_so_line_rec.uom <> l_closed_so_line_rec.primary_uom
3311: THEN
3312:
3313: l_closed_so_line_rec.primary_uom_qty
3314: := INV_CONVERT.inv_um_convert
3315: ( item_id => l_closed_so_line_rec.component_id
3316: , precision => 5
3317: , from_quantity => l_closed_so_line_rec.qty --shipped_quantity
3318: , from_unit => l_closed_so_line_rec.uom
3321: , to_name => null
3322: );
3323:
3324: l_ordered_primary_qty
3325: := INV_CONVERT.inv_um_convert
3326: ( item_id => l_closed_so_line_rec.component_id
3327: , precision => 5
3328: , from_quantity => l_ordered_qty
3329: , from_unit => l_closed_so_line_rec.uom
3632: IF l_primary_uom = l_ordered_uom
3633: THEN
3634: l_allocable_qty := l_allocable_primary_qty;
3635: ELSE
3636: l_allocable_qty := INV_CONVERT.inv_um_convert
3637: ( item_id => l_component_id
3638: , precision => 5
3639: , from_quantity => l_allocable_primary_qty
3640: , from_unit => l_primary_uom
3662: IF l_primary_uom = l_ordered_uom
3663: THEN
3664: l_shipped_primary_qty := l_shipped_qty;
3665: ELSE
3666: l_shipped_primary_qty := INV_CONVERT.inv_um_convert
3667: ( item_id => l_component_id
3668: , precision => 5
3669: , from_quantity => l_shipped_qty
3670: , from_unit => l_ordered_uom
3778: IF l_primary_uom = l_ordered_uom
3779: THEN
3780: l_allocable_qty := l_allocable_primary_qty;
3781: ELSE
3782: l_allocable_qty := INV_CONVERT.inv_um_convert
3783: ( item_id => l_component_id
3784: , precision => 5
3785: , from_quantity => l_allocable_primary_qty
3786: , from_unit => l_primary_uom
4286: IF l_uom <> l_primary_uom
4287: THEN
4288:
4289: l_primary_uom_qty
4290: := INV_CONVERT.inv_um_convert
4291: ( item_id => C_SHIKYU_REPLENISHMENT_rec.shikyu_component_id
4292: , precision => 5
4293: , from_quantity => C_SHIKYU_REPLENISHMENT_rec.oel_ordered_quantity
4294: , from_unit => l_uom
4505: IF l_uom <> l_primary_uom
4506: THEN
4507:
4508: l_primary_uom_qty
4509: := INV_CONVERT.inv_um_convert
4510: ( item_id => C_SHIKYU_REPLENISHMENT_rec.shikyu_component_id
4511: , precision => 5
4512: , from_quantity => C_SHIKYU_REPLENISHMENT_rec.oel_ordered_quantity
4513: , from_unit => l_uom
4641: IF l_uom <> l_primary_uom
4642: THEN
4643:
4644: l_primary_uom_qty
4645: := INV_CONVERT.inv_um_convert
4646: ( item_id => C_SHIKYU_REPLENISHMENT_rec.shikyu_component_id
4647: , precision => 5
4648: , from_quantity => C_child_so_lines_rec.ordered_quantity
4649: , from_unit => l_uom
5108:
5109: IF p_primary_uom_qty IS NULL
5110: THEN
5111:
5112: l_primary_uom_qty := INV_CONVERT.inv_um_convert
5113: ( item_id => p_component_id
5114: , precision => 5
5115: , from_quantity => l_ordered_qty
5116: , from_unit => l_ordered_uom
5572: || ') <> p_alloc_uom (' || p_alloc_uom || ')'
5573: );
5574: END IF;
5575:
5576: l_reduce_replen_uom_qty := INV_CONVERT.inv_um_convert
5577: ( item_id => p_component_id
5578: , precision => 5
5579: , from_quantity => l_remain_qty_to_reduce
5580: , from_unit => p_alloc_uom