[Home] [Help]
3770: --- 2231732 encumbrance enhancement
3771: If l_po_info.encumbered_flag = 'Y' then
3772: l_encumbrance_account := l_po_info.budget_account_id;
3773: ---- Bug #2813401 : Converting the shipped qty to ordered qty UOM
3774: l_encumbrance_amount := (wsh_wv_utils.convert_uom( l_mtl_txn_if_rec.trx_uom(l_index),
3775: l_mtl_txn_if_rec.src_requested_quantity_uom(l_index),
3776: l_mtl_txn_if_rec.trx_quantity(l_index),
3777: l_mtl_txn_if_rec.inventory_item_id(l_index))* l_po_info.unit_price);
3778: end if;
5921: AND dd.source_header_id = p_oe_interface_rec.source_header_id
5922: AND dd.source_line_set_id = p_oe_interface_rec.source_line_set_id
5923: AND dd.released_status <> 'D';
5924:
5925: SELECT SUM(WSH_WV_UTILS.CONVERT_UOM(ol.order_quantity_uom, p_oe_interface_rec.requested_quantity_uom, ol.ordered_quantity, ol.inventory_item_id)) order_line_quantity,
5926: -- muom
5927: SUM(ol.ordered_quantity2) order_line_quantity2
5928: INTO l_tot_ord_qty, l_tot_ord_qty2
5929: FROM oe_order_lines_all ol
8609: -- muom
8610: -- Derive shipped_quantity (to pass to OM) only when Fufillment Base is Secondary
8611: sum( decode(dd.requested_quantity_uom2, null, null,
8612: decode(WSH_UTIL_CORE.Get_Line_Fulfillment_Base(dd.source_code, dd.source_line_id),
8613: 'S', WSH_WV_UTILS.CONVERT_UOM(from_uom => dd.requested_quantity_uom2,
8614: to_uom => ol.order_quantity_uom,
8615: quantity => nvl(dd.shipped_quantity2,0),
8616: item_id => dd.inventory_item_id)))) shipped_quantity
8617: FROM wsh_delivery_Details dd,
8653: SELECT dd.source_header_id ,
8654: dd.source_header_number ,
8655: dd.source_line_set_id,
8656: dd.source_line_id ,
8657: WSH_WV_UTILS.CONVERT_UOM(ol.order_quantity_uom,
8658: dd.requested_quantity_uom,
8659: ol.ordered_quantity,
8660: dd.inventory_item_id) order_line_quantity,
8661: -- muom
8689: -- muom
8690: -- Derive shipped_quantity (to pass to OM) only when Fufillment Base is Secondary
8691: sum( decode(dd.requested_quantity_uom2, null, null,
8692: decode(WSH_UTIL_CORE.Get_Line_Fulfillment_Base(dd.source_code, dd.source_line_id),
8693: 'S',WSH_WV_UTILS.CONVERT_UOM(
8694: from_uom => ol.ordered_quantity_uom2,
8695: to_uom => ol.order_quantity_uom,
8696: quantity => nvl(dd.shipped_quantity2, 0 ),
8697: item_id => dd.inventory_item_id)))) total_om_shipped_quantity
8724: dd.ship_set_id,
8725: dd.arrival_set_id,
8726: dd.inventory_item_id,
8727: dd.ship_model_complete_flag,
8728: WSH_WV_UTILS.CONVERT_UOM(ol.order_quantity_uom,
8729: dd.requested_quantity_uom,
8730: ol.ordered_quantity,
8731: dd.inventory_item_id) ,
8732: dd.requested_quantity_uom,
8756: dd.ship_set_id,
8757: dd.arrival_set_id,
8758: dd.inventory_item_id,
8759: dd.ship_model_complete_flag,
8760: WSH_WV_UTILS.CONVERT_UOM(ol.order_quantity_uom,
8761: dd.requested_quantity_uom,
8762: ol.ordered_quantity,
8763: dd.inventory_item_id) ,
8764: dd.requested_quantity_uom,
10581: SELECT dd.source_header_id ,
10582: dd.source_header_number,
10583: NULL source_line_set_id,
10584: dd.source_line_id,
10585: WSH_WV_UTILS.CONVERT_UOM(ol.order_quantity_uom,
10586: dd.requested_quantity_uom,
10587: ol.ordered_quantity,
10588: dd.inventory_item_id) order_line_quantity,
10589: -- muom
10937: --}
10938: END;
10939:
10940: --for full quantity shipped ,popualate bulk mode variable
10941: IF ( WSH_WV_UTILS.CONVERT_UOM( line_rec.order_quantity_uom, line_rec.requested_quantity_uom, line_rec.ordered_quantity, line_rec.inventory_item_id) = line_rec.total_shipped_quantity ) THEN
10942: --{
10943: IF l_debug_on THEN
10944: WSH_DEBUG_SV.logmsg(l_module_name, 'Total quantity shipped interface to OM');
10945: WSH_DEBUG_SV.log(l_module_name,'line_rec.total_ordered_quantity',line_rec.ordered_quantity);