eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_WAVE_PLANNING_PVT dependencies on WMS_WP_RULES_SIMULATION

Line 2322: wms_wp_rules_simulation wwr

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,
2322: wms_wp_rules_simulation wwr
2323: where wwh.wave_header_id = p_wave_header_id
2324: and wwp.planning_criteria_id = p_planning_criteria_id
2325: and wwh.planning_criteria_id = wwp.planning_criteria_id
2326: and wwh.wave_header_id = wwl.wave_header_id

Line 2407: wms_wp_rules_simulation wwr

2403: NULL,
2404: NULL
2405: FROM wsh_delivery_details wdd,
2406: wms_wp_wave_lines wwl, --11775489 added org_id join...FIXED
2407: wms_wp_rules_simulation wwr
2408: WHERE wdd.released_status in ('R', 'B')
2409: AND wwr.delivery_detail_id = wdd.delivery_detail_id
2410: and wwr.wave_header_id=wwl.wave_header_id
2411: and wdd.delivery_detail_id = wwl.delivery_detail_id

Line 3992: FROM mtl_txn_request_lines mtrl, wms_wp_rules_simulation wwr

3988: pick_methodology_id, container_item_id, carton_grouping_id, FND_API.G_MISS_CHAR, FND_API.G_MISS_CHAR,
3989: FND_API.G_MISS_CHAR, inspection_status, wms_process_flag, pick_slip_number, pick_slip_date,
3990: ship_set_id, ship_model_id, model_quantity, required_quantity, secondary_quantity,
3991: secondary_uom_code, secondary_quantity_detailed, secondary_quantity_delivered, grade_code, secondary_required_quantity
3992: FROM mtl_txn_request_lines mtrl, wms_wp_rules_simulation wwr
3993: WHERE mtrl.TXN_SOURCE_LINE_DETAIL_ID = wwr.delivery_detail_id
3994: AND p_mode = 'RBP'
3995: and wwr.wave_header_id=p_wave_id
3996: AND mtrl.inventory_item_id = v_inventory_item_id

Line 4018: FROM mtl_txn_request_lines mtrl, wms_wp_rules_simulation wwr, wsh_delivery_details wdd

4014: mtrl.pick_methodology_id, mtrl.container_item_id, mtrl.carton_grouping_id, FND_API.G_MISS_CHAR, FND_API.G_MISS_CHAR,
4015: FND_API.G_MISS_CHAR, mtrl.inspection_status, mtrl.wms_process_flag, mtrl.pick_slip_number, mtrl.pick_slip_date,
4016: mtrl.ship_set_id, mtrl.ship_model_id, mtrl.model_quantity, mtrl.required_quantity, mtrl.secondary_quantity,
4017: mtrl.secondary_uom_code, mtrl.secondary_quantity_detailed, mtrl.secondary_quantity_delivered, mtrl.grade_code, mtrl.secondary_required_quantity
4018: FROM mtl_txn_request_lines mtrl, wms_wp_rules_simulation wwr, wsh_delivery_details wdd
4019: WHERE mtrl.TXN_SOURCE_LINE_DETAIL_ID = wwr.delivery_detail_id
4020: AND wwr.delivery_detail_id = wdd.delivery_detail_id
4021: AND p_mode = 'RBP-SS'
4022: and wwr.wave_header_id=p_wave_id

Line 4121: UPDATE wms_wp_rules_simulation

4117: l_reservable_type:= INV_CACHE.item_rec.reservable_type;
4118:
4119: IF l_reservable_type = 2 THEN
4120: print_debug('In wave simulation mode. Update the allocation table with complete quantity fulfilled', l_debug);
4121: UPDATE wms_wp_rules_simulation
4122: SET ALLOCATED_QUANTITY = l_mo_line.quantity,
4123: ALLOCATED_QUANTITY2 = l_mo_line.secondary_quantity
4124: WHERE DELIVERY_DETAIL_ID = l_mo_line.txn_source_line_detail_id
4125: and wave_header_id=p_wave_id;

Line 4412: FROM wms_wp_rules_simulation wwl, wsh_delivery_details wdd

4408: GROUP BY WDD.ORGANIZATION_ID, WDD.INVENTORY_ITEM_ID;
4409:
4410: CURSOR c2 IS
4411: SELECT Wdd.ORGANIZATION_ID, DECODE(Wdd.SHIP_SET_ID,NULL,DECODE(Wdd.SHIP_MODEL_COMPLETE_FLAG,'Y',NULL,Wdd.INVENTORY_ITEM_ID),NULL), COUNT(*)
4412: FROM wms_wp_rules_simulation wwl, wsh_delivery_details wdd
4413: WHERE wdd.organization_id = p_organization_id
4414: AND wwl.delivery_detail_id = wdd.delivery_detail_id
4415: and wwl.wave_header_id=p_wave_id
4416: GROUP BY Wdd.ORGANIZATION_ID, DECODE(Wdd.SHIP_SET_ID,NULL,DECODE(Wdd.SHIP_MODEL_COMPLETE_FLAG,'Y',NULL,Wdd.INVENTORY_ITEM_ID),NULL);

Line 4642: from wms_wp_rules_simulation wwr,

4638: CURSOR c1 IS
4639: select mtrl.TXN_SOURCE_LINE_DETAIL_ID delivery_detail_id,
4640: sum(transaction_quantity) l_quantity,
4641: sum(secondary_transaction_quantity) l_quantity2
4642: from wms_wp_rules_simulation wwr,
4643: mtl_material_transactions_temp mmtt,
4644: mtl_txn_request_lines mtrl
4645: where wwr.delivery_detail_id = mtrl.TXN_SOURCE_LINE_DETAIL_ID
4646: and wwr.wave_header_id=p_wave_header_id

Line 4692: update wms_wp_rules_simulation

4688:
4689: for i in x_wp_rules_tbl.FIRST .. x_wp_rules_tbl.LAST LOOP
4690:
4691: begin
4692: update wms_wp_rules_simulation
4693: set allocated_quantity = x_wp_rules_tbl(i).allocated_qty,
4694: allocated_quantity2 = x_wp_rules_tbl(i).allocated_qty2
4695: where delivery_detail_id = x_wp_rules_tbl(i).delivery_detail_id
4696: and wave_header_id=p_wave_header_id;

Line 4812: FROM wms_wp_rules_simulation where wave_header_id=p_wave_id);

4808: IF g_update_wdd = 'Y' THEN
4809: UPDATE wsh_delivery_details
4810: SET move_order_line_id=NULL
4811: WHERE delivery_detail_id IN (SELECT delivery_Detail_id
4812: FROM wms_wp_rules_simulation where wave_header_id=p_wave_id);
4813:
4814: print_debug(SQL%ROWCOUNT || ' Rows updated from WDD ',l_debug);
4815: g_update_wdd := 'N';
4816: COMMIT;

Line 4911: --delete from wms_wp_rules_simulation;

4907: , x_return_status => x_return_status
4908: );
4909:
4910:
4911: --delete from wms_wp_rules_simulation;
4912: COMMIT;
4913:
4914: EXCEPTION
4915: WHEN OTHERS THEN

Line 5008: FROM wms_wp_rules_simulation where wave_header_id=p_wave_id);

5004: print_debug('Update WDD', l_debug);
5005: UPDATE wsh_delivery_details
5006: SET move_order_line_id=NULL
5007: WHERE delivery_detail_id IN (SELECT delivery_Detail_id
5008: FROM wms_wp_rules_simulation where wave_header_id=p_wave_id);
5009:
5010: g_update_wdd := 'N';
5011: EXCEPTION
5012: WHEN OTHERS THEN

Line 5382: insert into wms_wp_rules_simulation

5378:
5379: -- Bulk Populate the Global Temp Table
5380:
5381:
5382: insert into wms_wp_rules_simulation
5383: (wave_header_id,delivery_Detail_id, requested_quantity, requested_quantity2)
5384: select wwl.wave_header_id,wwl.delivery_Detail_id, wdd.requested_quantity, wdd.requested_quantity2
5385: from wms_wp_wave_lines wwl, wsh_delivery_details wdd --11775489 get from wdd... FIXED
5386: where wave_header_id = p_wave_header_id

Line 5625: update wms_wp_rules_simulation

5621: l_debug);
5622:
5623: if (l_atr + l_reserved_qty) >= c_rec.requested_quantity then
5624:
5625: update wms_wp_rules_simulation
5626: set allocated_quantity = c_rec.requested_quantity
5627: where delivery_detail_id = c_rec.delivery_Detail_id
5628: and wave_header_id=p_wave_header_id;
5629: print_debug('Prioritize Inventory --> Quantity picked from Inventory is '||c_rec.requested_quantity,

Line 5639: update wms_wp_rules_simulation

5635: elsif (l_atr + l_reserved_qty) < c_rec.requested_quantity then
5636:
5637:
5638:
5639: update wms_wp_rules_simulation
5640: set allocated_quantity =
5641: (l_atr + l_reserved_qty)
5642: where delivery_detail_id = c_rec.delivery_Detail_id
5643: and wave_header_id=p_wave_header_id;

Line 5859: from wms_wp_rules_simulation

5855: l_crossdock_qty := 0; ---In Case of Inventory only
5856: if l_allocation_method <> 'I' then
5857: select crossdocked_quantity
5858: into l_crossdock_qty
5859: from wms_wp_rules_simulation
5860: where delivery_Detail_id = c_rec.delivery_Detail_id
5861: and wave_header_id=p_wave_header_id;
5862:
5863: print_debug('Crossdocked Quantity for delivery_Detail_id :' ||

Line 5874: update wms_wp_rules_simulation

5870: print_debug('Prioritize Inventory', l_debug);
5871:
5872: if (l_atr + l_reserved_qty) >= c_rec.requested_quantity then
5873:
5874: update wms_wp_rules_simulation
5875: set crossdocked_quantity = 0
5876: where delivery_detail_id = c_rec.delivery_Detail_id
5877: and wave_header_id=p_wave_header_id;
5878: print_debug('Prioritize Inventory --> Quantity picked from Crossdocking is 0 ',

Line 5886: update wms_wp_rules_simulation

5882: else
5883:
5884: if l_crossdock_qty > 0 then
5885:
5886: update wms_wp_rules_simulation
5887: set crossdocked_quantity = c_rec.requested_quantity -
5888: (l_atr + l_reserved_qty)
5889: where delivery_detail_id = c_rec.delivery_Detail_id
5890: and wave_header_id=p_wave_header_id;

Line 5922: from wms_wp_rules_simulation

5918: l_debug);
5919:
5920: select crossdocked_quantity
5921: into l_crossdock_qty
5922: from wms_wp_rules_simulation
5923: where delivery_Detail_id = c_rec.delivery_Detail_id
5924: and wave_header_id=p_wave_header_id;
5925:
5926: print_debug('Crossdocked Quantity for delivery_Detail_id :' ||

Line 5939: from wms_wp_rules_simulation

5935: l_debug);
5936:
5937: select crossdocked_quantity, allocated_quantity
5938: into l_crossdock_qty, l_allocated_qty
5939: from wms_wp_rules_simulation
5940: where delivery_Detail_id = c_rec.delivery_Detail_id
5941: and wave_header_id=p_wave_header_id;
5942:
5943: print_debug('Crossdocked Quantity for delivery_Detail_id :' ||

Line 6567: from wms_wp_rules_simulation

6563: -- Update the crossdock qty in Lines Table
6564:
6565: select delivery_detail_id, crossdocked_quantity bulk collect
6566: into x_wp_crossdock_tbl
6567: from wms_wp_rules_simulation
6568: where wave_header_id=p_wave_header_id;
6569:
6570: -- forall i in indices of x_wp_crossdock_tbl
6571: if x_wp_crossdock_tbl.count > 0 then

Line 6657: delete from wms_wp_rules_simulation where wave_header_id=p_wave_header_id;

6653:
6654: print_debug('Return Status after Plan Wave is ' || x_return_status,
6655: l_debug);
6656:
6657: delete from wms_wp_rules_simulation where wave_header_id=p_wave_header_id;
6658: commit;
6659:
6660: exception
6661:

Line 6668: delete from wms_wp_rules_simulation where wave_header_id=p_wave_header_id;

6664:
6665: when others THEN
6666: print_debug('Error in Plan Wave API: ' || SQLCODE || ' : ' || SQLERRM,
6667: l_debug);
6668: delete from wms_wp_rules_simulation where wave_header_id=p_wave_header_id;
6669: commit;
6670: x_return_status := FND_API.G_RET_STS_ERROR;
6671:
6672: end Plan_Wave;