APPS.WMS_WAVE_PLANNING_PVT dependencies on WMS_WP_WWB_TASKS_V

Line 17143: --populate wms_wp_tasks_gtmp using view wms_wp_wwb_tasks_v and transaction_temp_id in l_transaction_temp_id

17139: l_task_type_id_table.count = 0) THEN
17140: RETURN;
17141: END IF;
17142:
17143: --populate wms_wp_tasks_gtmp using view wms_wp_wwb_tasks_v and transaction_temp_id in l_transaction_temp_id
17144: FORALL ttemp_id IN l_transaction_temp_id_table.FIRST .. l_transaction_temp_id_table.LAST
17145: insert into wms_wp_tasks_gtmp
17146: select task_id,
17147: to_lpn,

Line 17218: from wms_wp_wwb_tasks_v

17214: pick_slip_number,
17215: picked_lpn,
17216: transaction_uom,
17217: transaction_quantity
17218: from wms_wp_wwb_tasks_v
17219: where wave_header_id = p_wave_id
17220: AND transaction_temp_id = l_transaction_temp_id_table(ttemp_id);
17221:
17222: /* Bug 5485730 - The employee details should be null if the status is being updated

Line 18191: --12371804 query from base tables instead of from wms_wp_wwb_tasks_v

18187:
18188:
18189:
18190:
18191: --12371804 query from base tables instead of from wms_wp_wwb_tasks_v
18192: insert into wms_wp_tasks_gtmp(
18193: TASK_ID,
18194: TO_LPN,
18195: TO_LPN_ID,

Line 19297: wms_wp_wwb_tasks_v wwtv,

19293: 0)
19294: into l_pick_fill_rate
19295: from wms_wp_wave_lines wwl,
19296: wsh_delivery_details wdd,
19297: wms_wp_wwb_tasks_v wwtv,
19298: wms_wp_wave_headers_vl wwh
19299: where wwl.wave_line_id = p_wave_line_id
19300: and wwl.delivery_detail_id = wdd.delivery_detail_id
19301: and wwl.organization_id = wdd.organization_id