DBA Data[Home] [Help]

APPS.WMS_DIRECT_SHIP_PVT dependencies on INV_SALESORDER

Line 5241: l_mso_id := inv_salesorder.get_salesorder_for_oeheader(l_header_id);

5237: END IF;
5238:
5239: IF (l_sub_reservable = 1
5240: AND l_item_reservable = 1) THEN
5241: l_mso_id := inv_salesorder.get_salesorder_for_oeheader(l_header_id);
5242: l_reservation_record.demand_source_header_id := l_mso_id;
5243: l_reservation_record.demand_source_line_id := l_line_id;
5244: l_reservation_record.demand_source_line_detail := NULL;
5245:

Line 6808: , p_demand_source_header_id => inv_salesorder.get_salesorder_for_oeheader(p_header_id)

6804: , p_is_revision_control => l_is_revision_control
6805: , p_is_lot_control => l_is_lot_control
6806: , p_is_serial_control => l_is_serial_control
6807: , p_demand_source_type_id => l_demand_source_type_id
6808: , p_demand_source_header_id => inv_salesorder.get_salesorder_for_oeheader(p_header_id)
6809: , p_demand_source_line_id => p_line_id
6810: , p_revision => p_revision
6811: , p_lot_number => NULL
6812: , p_subinventory_code => NULL

Line 8946: inv_salesorder.get_oeheader_for_salesorder(

8942: END IF;
8943: END IF;
8944:
8945: -- get oe_order_header_id from sales order header id
8946: inv_salesorder.get_oeheader_for_salesorder(
8947: p_salesorder_id => l_mtl_reservation_tab(resv_index).demand_source_header_id
8948: , x_oe_header_id => l_oe_order_header_id
8949: , x_return_status => l_return_status
8950: );

Line 9426: l_demand_source_header_id := inv_salesorder.get_salesorder_for_oeheader(p_order_header_id);

9422: l_overship_case := 'Y' ;
9423: END IF;
9424:
9425: -- query reservations for header_id, line_id
9426: l_demand_source_header_id := inv_salesorder.get_salesorder_for_oeheader(p_order_header_id);
9427: l_qry_reservation_record.demand_source_header_id := l_demand_source_header_id;
9428: l_qry_reservation_record.demand_source_line_id := p_order_line_id;
9429: l_qry_reservation_record.supply_source_type_id := inv_reservation_global.g_source_type_inv;
9430:

Line 10524: l_qry_reservation_record.demand_source_header_id := inv_salesorder.get_salesorder_for_oeheader(l_wds_cur.order_header_id);

10520:
10521: -- for each line in WDS from p_lpn_id
10522: FOR l_wds_cur IN wds_cur LOOP
10523: l_qry_reservation_record.demand_source_line_id := l_wds_cur.order_line_id;
10524: l_qry_reservation_record.demand_source_header_id := inv_salesorder.get_salesorder_for_oeheader(l_wds_cur.order_header_id);
10525: l_qry_reservation_record.supply_source_type_id := inv_reservation_global.g_source_type_inv;
10526:
10527: IF (l_debug = 1) THEN
10528: DEBUG('Before call to query reservation', 'Load_LPN');

Line 10844: inv_salesorder.get_oeheader_for_salesorder(

10840: IF l_mtl_resv_tab_count > 0 THEN
10841: FOR l_index_r IN 1 .. l_mtl_resv_tab_count LOOP
10842: l_order_line_id := l_mtl_reservation_tab(l_index_r).demand_source_line_id;
10843: -- get oe_order_header_id from sales order header id
10844: inv_salesorder.get_oeheader_for_salesorder(
10845: p_salesorder_id => l_mtl_reservation_tab(l_index_r).demand_source_header_id
10846: , x_oe_header_id => l_order_header_id
10847: , x_return_status => l_return_status
10848: );

Line 11195: l_demand_source_header_id := inv_salesorder.get_salesorder_for_oeheader(l_loaded_lines_rec.order_header_id);

11191:
11192: IF (l_loaded_lines_rec.revision = l_lpn_cont_rec.revision
11193: OR l_loaded_lines_rec.revision IS NULL) THEN
11194: -- get demand source header id
11195: l_demand_source_header_id := inv_salesorder.get_salesorder_for_oeheader(l_loaded_lines_rec.order_header_id);
11196: l_order_line_id := l_loaded_lines_rec.order_line_id;
11197:
11198: -- get total reserved quantity for line
11199: BEGIN