[Home] [Help]
7528: wdd.inventory_item_id,
7529: wwh.pull_replenishment_flag pull_replenishment_flag,
7530: wwl.wave_line_id,
7531: (wdd.requested_quantity - wwl.crossdock_quantity) requested_quantity
7532: from WMS_WP_WAVE_HEADERS_B wwh, wms_wp_wave_lines wwl,wsh_delivery_details wdd --11775489 get from wdd... FIXED check performance impact
7533: where wwh.wave_header_id = p_wave_header_id
7534: and wwh.wave_header_id = wwl.wave_header_id
7535: AND Nvl(wwl.remove_from_Wave_flag, 'N') <> 'Y'
7536: AND wdd.inventory_item_id = l_item_id
11301: --12371804 get currency code once instead of fetching each time inside of loop
11302: --this is because a wave can only have orders from one org
11303: select currency_code
11304: into G_SOB_CURRENCY
11305: from oe_gl_sets_of_books_v ogsob, org_organization_definitions ood, wms_wp_wave_headers_b wwh
11306: where wwh.wave_header_id = p_wave_header_id
11307: and wwh.organization_id = ood.organization_id
11308: and ood.set_of_books_id = ogsob.set_of_books_id;
11309: for l_value in c_net_value loop
17839: IF l_mo_line_table.COUNT > 0 THEN
17840: FORALL i IN l_mo_line_table.FIRST .. l_mo_line_table.LAST
17841: DELETE FROM wms_wp_wave_lines wwwl
17842: WHERE wwwl.delivery_detail_id = l_mo_line_table(i)
17843: AND exists (select 1 from wms_wp_wave_headers_b wwwh where wwwh.wave_firmed_flag = 'N' and wwwl.wave_header_id = wwwh.wave_header_id)
17844: AND nvl(wwwl.remove_from_wave_flag , 'N')='N';
17845:
17846:
17847: print_debug('Inside the call to update_wave_lines_tbl at place 2',l_debug);
18151: WSH_DELIVERY_DETAILS WDD,
18152: HZ_PARTIES HP,
18153: hz_cust_accounts CUST_ACCT,
18154: OE_ORDER_LINES_ALL OOL,
18155: wms_wp_wave_headers_b WWH,
18156: WMS_WP_WAVE_LINES WWL,
18157: WSH_NEW_DELIVERIES WND,
18158: MTL_SYSTEM_ITEMS_KFV MSIV,
18159: WSH_CARRIERS WC,