[Home] [Help]
473: (select 1
474: from mtl_reservations mr
475: WHERE MR.DEMAND_SOURCE_LINE_ID = wdd.source_line_id
476: and MR.DEMAND_SOURCE_HEADER_ID =
477: inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id)
478: and MR.demand_source_type_id =
479: decode(wdd.source_document_type_id, 10, 8, 2)
480: and MR.SUBINVENTORY_CODE IS NOT NULL --locator is not needed,
481: )-- Exclude detailed RSV
1006: FROM wms_repl_demand_gtmp wrdg
1007: WHERE wrdg.organization_id = wdd.organization_id
1008: AND wrdg.inventory_item_id = wdd.inventory_item_id
1009: AND wrdg.demand_line_detail_id = wdd.delivery_detail_id
1010: AND wrdg.demand_header_id = inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id)
1011: AND wrdg.demand_line_id = wdd.source_line_id
1012: )
1013: AND inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id) IN
1014: (
1009: AND wrdg.demand_line_detail_id = wdd.delivery_detail_id
1010: AND wrdg.demand_header_id = inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id)
1011: AND wrdg.demand_line_id = wdd.source_line_id
1012: )
1013: AND inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id) IN
1014: (
1015: SELECT DISTINCT demand_header_id FROM wms_repl_demand_gtmp wrdg1
1016: WHERE WRDG1.organization_id = l_org_id
1017: AND WRDG1.inventory_item_id = l_item_id
1942: sort_attribute1 ,sort_attribute2,sort_attribute3,sort_attribute4,sort_attribute5
1943:
1944: FROM (
1945: SELECT wdd.inventory_item_id as item_id,
1946: inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id) AS header_id,
1947: wdd.source_line_id AS line_id,
1948: wdd.delivery_detail_id delivery_detail_id,
1949: decode(wdd.source_document_type_id, 10, 8, 2) as demand_type_id, -- for SO=2 and Internal Order=8
1950: wdd.requested_quantity requested_quantity, -- this is always stored in primary UOM
2179: (select 1
2180: from mtl_reservations mr
2181: WHERE MR.DEMAND_SOURCE_LINE_ID = wdd.source_line_id
2182: and MR.DEMAND_SOURCE_HEADER_ID =
2183: inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id)
2184: AND MR.SUBINVENTORY_CODE IS NOT NULL) --locator is not needed -- Exclude detailed RSV
2185:
2186: --Exclude those demands that have suub
2187: -- specified, we can not use sub = Forward_pick_sub either
5837: l_rsv_rec.inventory_item_id := l_inventory_item_id;
5838: l_rsv_rec.demand_source_name := NULL;
5839: l_rsv_rec.demand_source_type_id := l_demand_type_id;
5840: l_rsv_rec.demand_source_header_id := l_demand_so_header_id;
5841: -- here l_demand_so_header_id is inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id)
5842: l_rsv_rec.demand_source_line_id := l_demand_line_id;
5843: l_rsv_rec.orig_demand_source_type_id := l_demand_type_id;
5844: l_rsv_rec.orig_demand_source_header_id := l_demand_so_header_id;
5845: l_rsv_rec.orig_demand_source_line_id := l_demand_line_id;
6407: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
6408:
6409: CURSOR c_dynamic_repl_demand IS
6410: SELECT wdd.inventory_item_id as item_id,
6411: inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id) AS header_id,
6412: wdd.source_line_id AS line_id,
6413: wdd.delivery_detail_id,
6414: decode(wdd.source_document_type_id, 10, 8, 2) as demand_type_id, -- for SO=2 and Internal Order=8
6415: wdd.requested_quantity, -- this is always stored in primary UOM
6622: (select 1
6623: from mtl_reservations mr
6624: WHERE MR.DEMAND_SOURCE_LINE_ID = wdd.source_line_id
6625: and MR.DEMAND_SOURCE_HEADER_ID =
6626: inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id)
6627: and MR.demand_source_type_id =
6628: decode(wdd.source_document_type_id, 10, 8, 2)
6629: and MR.SUBINVENTORY_CODE IS NOT NULL --locator is not needed
6630: and (nvl(mr.staged_flag,'N') = 'N' and nvl(mr.detailed_quantity,0) = 0)) --13398141 ; Exclude detailed RSV