DBA Data[Home] [Help]

APPS.WMS_WAVE_PLANNING_PVT dependencies on INV_SALESORDER

Line 2317: inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id) demand_source_header_id

2313: wdd.organization_id,
2314: wdd.inventory_item_id,
2315: (wdd.requested_quantity - nvl(wwr.allocated_quantity, 0)) requested_quantity,
2316: wdd.requested_quantity_uom,
2317: inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id) demand_source_header_id
2318: from wms_wp_wave_headers_vl wwh,
2319: wms_wp_wave_lines wwl, --11775489 get from wdd... FIXED
2320: wms_wp_planning_criteria_vl wwp,
2321: wsh_delivery_details wdd,

Line 2743: l_demand_source_header_id := INV_SALESORDER.GET_SALESORDER_FOR_OEHEADER(g_troline_table(i).source_header_id);

2739: l_requested_quantity2 := nvl(g_troline_table(i).requested_quantity2,
2740: 0);
2741:
2742:
2743: l_demand_source_header_id := INV_SALESORDER.GET_SALESORDER_FOR_OEHEADER(g_troline_table(i).source_header_id);
2744:
2745: IF (g_from_subinventory is not null) THEN
2746:
2747:

Line 5085: inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id) demand_source_header_id,

5081: wdd.ship_set_id,
5082: wdd.source_line_id,
5083: wdd.top_model_line_id,
5084: -- wdd.source_header_id,
5085: inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id) demand_source_header_id,
5086: -- wdd.source_header_type_id,
5087: decode(wdd.source_document_type_id, 10, 8, 2) demand_source_type_id,
5088: wwl.wave_line_id
5089: from wms_wp_wave_headers_vl wwh,

Line 6055: -- here l_demand_so_header_id is inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id)

6051: l_rsv_rec.demand_source_type_id := X_SUFFICIENT_QTY_LINES_TBL(j)
6052: .demand_source_type_id;
6053: l_rsv_rec.demand_source_header_id := X_SUFFICIENT_QTY_LINES_TBL(j)
6054: .demand_source_header_id;
6055: -- here l_demand_so_header_id is inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id)
6056: l_rsv_rec.demand_source_line_id := X_SUFFICIENT_QTY_LINES_TBL(j)
6057: .source_line_id;
6058: l_rsv_rec.orig_demand_source_type_id := X_SUFFICIENT_QTY_LINES_TBL(j)
6059: .demand_source_type_id;

Line 12382: inv_salesorder.get_salesorder_for_oeheader(l_source_header_id_tb(i)), --???????? Demand Source Header Id

12378: sysdate,
12379: fnd_global.login_id,
12380: l_delivery_Detail_id_tb(i),
12381: l_organization_id_tb(i),
12382: inv_salesorder.get_salesorder_for_oeheader(l_source_header_id_tb(i)), --???????? Demand Source Header Id
12383: l_requested_quantity_uom_tb(i));--11775489 this column added
12384:
12385: -- commit;
12386: