4563:
4564: );
4565: else --}{
4566: -- Bug 4898703 - START {
4567: x_remaining_qty_po_uom := x_remaining_quantity * po_uom_s.po_uom_convert(temp_cascaded_table(1).unit_of_measure,
4568: x_shipmentdistributionrec.unit_meas_lookup_code,
4569: temp_cascaded_table(1).item_id
4570: );
4571: -- using arbit qty for PO->ASN, PO->PRIMARY UOM conversion as this is just a check
4569: temp_cascaded_table(1).item_id
4570: );
4571: -- using arbit qty for PO->ASN, PO->PRIMARY UOM conversion as this is just a check
4572:
4573: po_asn_uom_qty := 1000 * po_uom_s.po_uom_convert( x_shipmentdistributionrec.unit_meas_lookup_code,
4574: temp_cascaded_table(1).unit_of_measure,
4575: temp_cascaded_table(1).item_id
4576: );
4577: po_primary_uom_qty := 1000 * po_uom_s.po_uom_convert(x_shipmentdistributionrec.unit_meas_lookup_code,
4573: po_asn_uom_qty := 1000 * po_uom_s.po_uom_convert( x_shipmentdistributionrec.unit_meas_lookup_code,
4574: temp_cascaded_table(1).unit_of_measure,
4575: temp_cascaded_table(1).item_id
4576: );
4577: po_primary_uom_qty := 1000 * po_uom_s.po_uom_convert(x_shipmentdistributionrec.unit_meas_lookup_code,
4578: temp_cascaded_table(1).primary_unit_of_measure,
4579: temp_cascaded_table(1).item_id
4580: );
4581: -- Bug 4898703 - END }
4667: temp_cascaded_table(1).unit_of_measure);
4668:
4669: else --}{
4670: -- Bug 4898703
4671: x_remaining_quantity := x_remaining_qty_po_uom * po_uom_s.po_uom_convert(x_shipmentdistributionrec.unit_meas_lookup_code,
4672: temp_cascaded_table(1).unit_of_measure,
4673: temp_cascaded_table(1).item_id );
4674: end if; -- 5203841 }
4675: insert_into_table := TRUE;
4747:
4748: else --}{
4749: -- Bug 4898703
4750: temp_cascaded_table(current_n).vendor_cum_shipped_qty := temp_cascaded_table(current_n).vendor_cum_shipped_qty
4751: - (x_bkp_qty * po_uom_s.po_uom_convert(temp_cascaded_table(current_n).unit_of_measure,
4752: temp_cascaded_table(current_n).primary_unit_of_measure,
4753: temp_cascaded_table(current_n).item_id
4754: ));
4755: end if; -- 5203841 }
4799: ); -- in asn uom
4800: --END IF; --}
4801: else --}{
4802: -- Bug 4898703 - START {
4803: temp_cascaded_table(current_n).quantity := x_converted_trx_qty * po_uom_s.po_uom_convert(x_shipmentdistributionrec.unit_meas_lookup_code,
4804: temp_cascaded_table(current_n).unit_of_measure,
4805: temp_cascaded_table(current_n).item_id
4806: ); -- in asn uom
4807: --END IF; --}
4830:
4831:
4832:
4833: else -- }{
4834: temp_cascaded_table(current_n).primary_quantity := x_converted_trx_qty * po_uom_s.po_uom_convert(x_shipmentdistributionrec.unit_meas_lookup_code,
4835: temp_cascaded_table(current_n).primary_unit_of_measure,
4836: temp_cascaded_table(current_n).item_id
4837: );
4838: temp_cascaded_table(current_n).primary_quantity := round(temp_cascaded_table(current_n).primary_quantity,6);
11349: END IF;
11350: END IF; --}
11351: /* Get the available qty in PRIMARY UOM */
11352: /*
11353: PO_UOM_S.UOM_CONVERT (x_converted_trx_qty,
11354: l_uom,
11355: x_item_id,
11356: x_primary_uom,
11357: l_primary_available_qty );
12889: asn_debug.put_line('l_transaction_uom' || l_transaction_uom);
12890: asn_debug.put_line('l_item_id' || l_item_id);
12891: END IF;
12892:
12893: po_uom_s.uom_convert(l_interface_quantity, l_primary_uom, l_item_id,
12894: l_transaction_uom, l_interface_qty_in_trx_uom);
12895:
12896: END IF;
12897:
13057: END IF;
13058: END IF; --}
13059: /* Get the available qty in PRIMARY UOM */
13060: /*
13061: PO_UOM_S.UOM_CONVERT (x_converted_trx_qty,
13062: l_uom,
13063: x_item_id,
13064: x_primary_uom,
13065: l_primary_available_qty );
14525: RETURN NUMBER IS
14526: correct_qty NUMBER;
14527: BEGIN
14528: IF source_uom <> dest_uom THEN
14529: po_uom_s.uom_convert(source_qty,
14530: source_uom,
14531: item_id,
14532: dest_uom,
14533: correct_qty