[Home] [Help]
472: (select 1
473: from mtl_reservations mr
474: WHERE MR.DEMAND_SOURCE_LINE_ID = wdd.source_line_id
475: and MR.DEMAND_SOURCE_HEADER_ID =
476: inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id)
477: and MR.demand_source_type_id =
478: decode(wdd.source_document_type_id, 10, 8, 2)
479: and MR.SUBINVENTORY_CODE IS NOT NULL) --locator is not needed, Exclude detailed RSV
480: AND NOT EXISTS
989: FROM wms_repl_demand_gtmp wrdg
990: WHERE wrdg.organization_id = wdd.organization_id
991: AND wrdg.inventory_item_id = wdd.inventory_item_id
992: AND wrdg.demand_line_detail_id = wdd.delivery_detail_id
993: AND wrdg.demand_header_id = inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id)
994: AND wrdg.demand_line_id = wdd.source_line_id
995: )
996: AND inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id) IN
997: (
992: AND wrdg.demand_line_detail_id = wdd.delivery_detail_id
993: AND wrdg.demand_header_id = inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id)
994: AND wrdg.demand_line_id = wdd.source_line_id
995: )
996: AND inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id) IN
997: (
998: SELECT DISTINCT demand_header_id FROM wms_repl_demand_gtmp wrdg1
999: WHERE WRDG1.organization_id = l_org_id
1000: AND WRDG1.inventory_item_id = l_item_id
1881: sort_attribute1 ,sort_attribute2,sort_attribute3,sort_attribute4,sort_attribute5
1882:
1883: FROM (
1884: SELECT wdd.inventory_item_id as item_id,
1885: inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id) AS header_id,
1886: wdd.source_line_id AS line_id,
1887: wdd.delivery_detail_id delivery_detail_id,
1888: decode(wdd.source_document_type_id, 10, 8, 2) as demand_type_id, -- for SO=2 and Internal Order=8
1889: wdd.requested_quantity requested_quantity, -- this is always stored in primary UOM
2119: (select 1
2120: from mtl_reservations mr
2121: WHERE MR.DEMAND_SOURCE_LINE_ID = wdd.source_line_id
2122: and MR.DEMAND_SOURCE_HEADER_ID =
2123: inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id)
2124: AND MR.SUBINVENTORY_CODE IS NOT NULL) --locator is not needed -- Exclude detailed RSV
2125:
2126: --Exclude those demands that have suub
2127: -- specified, we can not use sub = Forward_pick_sub either
5667: l_rsv_rec.inventory_item_id := l_inventory_item_id;
5668: l_rsv_rec.demand_source_name := NULL;
5669: l_rsv_rec.demand_source_type_id := l_demand_type_id;
5670: l_rsv_rec.demand_source_header_id := l_demand_so_header_id;
5671: -- here l_demand_so_header_id is inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id)
5672: l_rsv_rec.demand_source_line_id := l_demand_line_id;
5673: l_rsv_rec.orig_demand_source_type_id := l_demand_type_id;
5674: l_rsv_rec.orig_demand_source_header_id := l_demand_so_header_id;
5675: l_rsv_rec.orig_demand_source_line_id := l_demand_line_id;
6236: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
6237:
6238: CURSOR c_dynamic_repl_demand IS
6239: SELECT wdd.inventory_item_id as item_id,
6240: inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id) AS header_id,
6241: wdd.source_line_id AS line_id,
6242: wdd.delivery_detail_id,
6243: decode(wdd.source_document_type_id, 10, 8, 2) as demand_type_id, -- for SO=2 and Internal Order=8
6244: wdd.requested_quantity, -- this is always stored in primary UOM
6451: (select 1
6452: from mtl_reservations mr
6453: WHERE MR.DEMAND_SOURCE_LINE_ID = wdd.source_line_id
6454: and MR.DEMAND_SOURCE_HEADER_ID =
6455: inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id)
6456: and MR.demand_source_type_id =
6457: decode(wdd.source_document_type_id, 10, 8, 2)
6458: and MR.SUBINVENTORY_CODE IS NOT NULL) --locator is not needed -- Exclude detailed RSV
6459: AND NOT EXISTS