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_WAVEPLAN_TASKS_PVT dependencies on WMS_PLAN_TASKS_PVT

Line 251: wms_plan_tasks_pvt.g_allocated_lpn_visible := g_allocated_lpn_visible;

247: g_to_organization_code_visible := visible_columns (32);
248: g_txn_source_type_visible := visible_columns (33);
249: g_user_task_type_visible := visible_columns (34);
250:
251: wms_plan_tasks_pvt.g_allocated_lpn_visible := g_allocated_lpn_visible;
252: wms_plan_tasks_pvt.g_assembly_visible := g_assembly_visible;
253: wms_plan_tasks_pvt.g_carrier_visible := g_carrier_visible;
254: wms_plan_tasks_pvt.g_cartonization_lpn_visible :=
255: g_cartonization_lpn_visible;

Line 252: wms_plan_tasks_pvt.g_assembly_visible := g_assembly_visible;

248: g_txn_source_type_visible := visible_columns (33);
249: g_user_task_type_visible := visible_columns (34);
250:
251: wms_plan_tasks_pvt.g_allocated_lpn_visible := g_allocated_lpn_visible;
252: wms_plan_tasks_pvt.g_assembly_visible := g_assembly_visible;
253: wms_plan_tasks_pvt.g_carrier_visible := g_carrier_visible;
254: wms_plan_tasks_pvt.g_cartonization_lpn_visible :=
255: g_cartonization_lpn_visible;
256: wms_plan_tasks_pvt.g_container_item_visible := g_container_item_visible;

Line 253: wms_plan_tasks_pvt.g_carrier_visible := g_carrier_visible;

249: g_user_task_type_visible := visible_columns (34);
250:
251: wms_plan_tasks_pvt.g_allocated_lpn_visible := g_allocated_lpn_visible;
252: wms_plan_tasks_pvt.g_assembly_visible := g_assembly_visible;
253: wms_plan_tasks_pvt.g_carrier_visible := g_carrier_visible;
254: wms_plan_tasks_pvt.g_cartonization_lpn_visible :=
255: g_cartonization_lpn_visible;
256: wms_plan_tasks_pvt.g_container_item_visible := g_container_item_visible;
257: wms_plan_tasks_pvt.g_content_lpn_visible := g_content_lpn_visible;

Line 254: wms_plan_tasks_pvt.g_cartonization_lpn_visible :=

250:
251: wms_plan_tasks_pvt.g_allocated_lpn_visible := g_allocated_lpn_visible;
252: wms_plan_tasks_pvt.g_assembly_visible := g_assembly_visible;
253: wms_plan_tasks_pvt.g_carrier_visible := g_carrier_visible;
254: wms_plan_tasks_pvt.g_cartonization_lpn_visible :=
255: g_cartonization_lpn_visible;
256: wms_plan_tasks_pvt.g_container_item_visible := g_container_item_visible;
257: wms_plan_tasks_pvt.g_content_lpn_visible := g_content_lpn_visible;
258: wms_plan_tasks_pvt.g_customer_visible := g_customer_visible;

Line 256: wms_plan_tasks_pvt.g_container_item_visible := g_container_item_visible;

252: wms_plan_tasks_pvt.g_assembly_visible := g_assembly_visible;
253: wms_plan_tasks_pvt.g_carrier_visible := g_carrier_visible;
254: wms_plan_tasks_pvt.g_cartonization_lpn_visible :=
255: g_cartonization_lpn_visible;
256: wms_plan_tasks_pvt.g_container_item_visible := g_container_item_visible;
257: wms_plan_tasks_pvt.g_content_lpn_visible := g_content_lpn_visible;
258: wms_plan_tasks_pvt.g_customer_visible := g_customer_visible;
259: wms_plan_tasks_pvt.g_delivery_visible := g_delivery_visible;
260: wms_plan_tasks_pvt.g_department_visible := g_department_visible;

Line 257: wms_plan_tasks_pvt.g_content_lpn_visible := g_content_lpn_visible;

253: wms_plan_tasks_pvt.g_carrier_visible := g_carrier_visible;
254: wms_plan_tasks_pvt.g_cartonization_lpn_visible :=
255: g_cartonization_lpn_visible;
256: wms_plan_tasks_pvt.g_container_item_visible := g_container_item_visible;
257: wms_plan_tasks_pvt.g_content_lpn_visible := g_content_lpn_visible;
258: wms_plan_tasks_pvt.g_customer_visible := g_customer_visible;
259: wms_plan_tasks_pvt.g_delivery_visible := g_delivery_visible;
260: wms_plan_tasks_pvt.g_department_visible := g_department_visible;
261: wms_plan_tasks_pvt.g_from_lpn_visible := g_from_lpn_visible;

Line 258: wms_plan_tasks_pvt.g_customer_visible := g_customer_visible;

254: wms_plan_tasks_pvt.g_cartonization_lpn_visible :=
255: g_cartonization_lpn_visible;
256: wms_plan_tasks_pvt.g_container_item_visible := g_container_item_visible;
257: wms_plan_tasks_pvt.g_content_lpn_visible := g_content_lpn_visible;
258: wms_plan_tasks_pvt.g_customer_visible := g_customer_visible;
259: wms_plan_tasks_pvt.g_delivery_visible := g_delivery_visible;
260: wms_plan_tasks_pvt.g_department_visible := g_department_visible;
261: wms_plan_tasks_pvt.g_from_lpn_visible := g_from_lpn_visible;
262: wms_plan_tasks_pvt.g_line_visible := g_line_visible;

Line 259: wms_plan_tasks_pvt.g_delivery_visible := g_delivery_visible;

255: g_cartonization_lpn_visible;
256: wms_plan_tasks_pvt.g_container_item_visible := g_container_item_visible;
257: wms_plan_tasks_pvt.g_content_lpn_visible := g_content_lpn_visible;
258: wms_plan_tasks_pvt.g_customer_visible := g_customer_visible;
259: wms_plan_tasks_pvt.g_delivery_visible := g_delivery_visible;
260: wms_plan_tasks_pvt.g_department_visible := g_department_visible;
261: wms_plan_tasks_pvt.g_from_lpn_visible := g_from_lpn_visible;
262: wms_plan_tasks_pvt.g_line_visible := g_line_visible;
263: wms_plan_tasks_pvt.g_line_number_visible := g_line_number_visible;

Line 260: wms_plan_tasks_pvt.g_department_visible := g_department_visible;

256: wms_plan_tasks_pvt.g_container_item_visible := g_container_item_visible;
257: wms_plan_tasks_pvt.g_content_lpn_visible := g_content_lpn_visible;
258: wms_plan_tasks_pvt.g_customer_visible := g_customer_visible;
259: wms_plan_tasks_pvt.g_delivery_visible := g_delivery_visible;
260: wms_plan_tasks_pvt.g_department_visible := g_department_visible;
261: wms_plan_tasks_pvt.g_from_lpn_visible := g_from_lpn_visible;
262: wms_plan_tasks_pvt.g_line_visible := g_line_visible;
263: wms_plan_tasks_pvt.g_line_number_visible := g_line_number_visible;
264: wms_plan_tasks_pvt.g_machine_resource_visible :=

Line 261: wms_plan_tasks_pvt.g_from_lpn_visible := g_from_lpn_visible;

257: wms_plan_tasks_pvt.g_content_lpn_visible := g_content_lpn_visible;
258: wms_plan_tasks_pvt.g_customer_visible := g_customer_visible;
259: wms_plan_tasks_pvt.g_delivery_visible := g_delivery_visible;
260: wms_plan_tasks_pvt.g_department_visible := g_department_visible;
261: wms_plan_tasks_pvt.g_from_lpn_visible := g_from_lpn_visible;
262: wms_plan_tasks_pvt.g_line_visible := g_line_visible;
263: wms_plan_tasks_pvt.g_line_number_visible := g_line_number_visible;
264: wms_plan_tasks_pvt.g_machine_resource_visible :=
265: g_machine_resource_visible;

Line 262: wms_plan_tasks_pvt.g_line_visible := g_line_visible;

258: wms_plan_tasks_pvt.g_customer_visible := g_customer_visible;
259: wms_plan_tasks_pvt.g_delivery_visible := g_delivery_visible;
260: wms_plan_tasks_pvt.g_department_visible := g_department_visible;
261: wms_plan_tasks_pvt.g_from_lpn_visible := g_from_lpn_visible;
262: wms_plan_tasks_pvt.g_line_visible := g_line_visible;
263: wms_plan_tasks_pvt.g_line_number_visible := g_line_number_visible;
264: wms_plan_tasks_pvt.g_machine_resource_visible :=
265: g_machine_resource_visible;
266: wms_plan_tasks_pvt.g_num_of_child_tasks_visible :=

Line 263: wms_plan_tasks_pvt.g_line_number_visible := g_line_number_visible;

259: wms_plan_tasks_pvt.g_delivery_visible := g_delivery_visible;
260: wms_plan_tasks_pvt.g_department_visible := g_department_visible;
261: wms_plan_tasks_pvt.g_from_lpn_visible := g_from_lpn_visible;
262: wms_plan_tasks_pvt.g_line_visible := g_line_visible;
263: wms_plan_tasks_pvt.g_line_number_visible := g_line_number_visible;
264: wms_plan_tasks_pvt.g_machine_resource_visible :=
265: g_machine_resource_visible;
266: wms_plan_tasks_pvt.g_num_of_child_tasks_visible :=
267: g_num_of_child_tasks_visible;

Line 264: wms_plan_tasks_pvt.g_machine_resource_visible :=

260: wms_plan_tasks_pvt.g_department_visible := g_department_visible;
261: wms_plan_tasks_pvt.g_from_lpn_visible := g_from_lpn_visible;
262: wms_plan_tasks_pvt.g_line_visible := g_line_visible;
263: wms_plan_tasks_pvt.g_line_number_visible := g_line_number_visible;
264: wms_plan_tasks_pvt.g_machine_resource_visible :=
265: g_machine_resource_visible;
266: wms_plan_tasks_pvt.g_num_of_child_tasks_visible :=
267: g_num_of_child_tasks_visible;
268: wms_plan_tasks_pvt.g_operation_plan_visible := g_operation_plan_visible;

Line 266: wms_plan_tasks_pvt.g_num_of_child_tasks_visible :=

262: wms_plan_tasks_pvt.g_line_visible := g_line_visible;
263: wms_plan_tasks_pvt.g_line_number_visible := g_line_number_visible;
264: wms_plan_tasks_pvt.g_machine_resource_visible :=
265: g_machine_resource_visible;
266: wms_plan_tasks_pvt.g_num_of_child_tasks_visible :=
267: g_num_of_child_tasks_visible;
268: wms_plan_tasks_pvt.g_operation_plan_visible := g_operation_plan_visible;
269: wms_plan_tasks_pvt.g_operation_sequence_visible := g_operation_sequence_visible;
270: wms_plan_tasks_pvt.g_op_plan_instance_id_visible :=

Line 268: wms_plan_tasks_pvt.g_operation_plan_visible := g_operation_plan_visible;

264: wms_plan_tasks_pvt.g_machine_resource_visible :=
265: g_machine_resource_visible;
266: wms_plan_tasks_pvt.g_num_of_child_tasks_visible :=
267: g_num_of_child_tasks_visible;
268: wms_plan_tasks_pvt.g_operation_plan_visible := g_operation_plan_visible;
269: wms_plan_tasks_pvt.g_operation_sequence_visible := g_operation_sequence_visible;
270: wms_plan_tasks_pvt.g_op_plan_instance_id_visible :=
271: g_op_plan_instance_id_visible;
272: wms_plan_tasks_pvt.g_person_visible := g_person_visible;

Line 269: wms_plan_tasks_pvt.g_operation_sequence_visible := g_operation_sequence_visible;

265: g_machine_resource_visible;
266: wms_plan_tasks_pvt.g_num_of_child_tasks_visible :=
267: g_num_of_child_tasks_visible;
268: wms_plan_tasks_pvt.g_operation_plan_visible := g_operation_plan_visible;
269: wms_plan_tasks_pvt.g_operation_sequence_visible := g_operation_sequence_visible;
270: wms_plan_tasks_pvt.g_op_plan_instance_id_visible :=
271: g_op_plan_instance_id_visible;
272: wms_plan_tasks_pvt.g_person_visible := g_person_visible;
273: wms_plan_tasks_pvt.g_person_resource_visible :=

Line 270: wms_plan_tasks_pvt.g_op_plan_instance_id_visible :=

266: wms_plan_tasks_pvt.g_num_of_child_tasks_visible :=
267: g_num_of_child_tasks_visible;
268: wms_plan_tasks_pvt.g_operation_plan_visible := g_operation_plan_visible;
269: wms_plan_tasks_pvt.g_operation_sequence_visible := g_operation_sequence_visible;
270: wms_plan_tasks_pvt.g_op_plan_instance_id_visible :=
271: g_op_plan_instance_id_visible;
272: wms_plan_tasks_pvt.g_person_visible := g_person_visible;
273: wms_plan_tasks_pvt.g_person_resource_visible :=
274: g_person_resource_visible;

Line 272: wms_plan_tasks_pvt.g_person_visible := g_person_visible;

268: wms_plan_tasks_pvt.g_operation_plan_visible := g_operation_plan_visible;
269: wms_plan_tasks_pvt.g_operation_sequence_visible := g_operation_sequence_visible;
270: wms_plan_tasks_pvt.g_op_plan_instance_id_visible :=
271: g_op_plan_instance_id_visible;
272: wms_plan_tasks_pvt.g_person_visible := g_person_visible;
273: wms_plan_tasks_pvt.g_person_resource_visible :=
274: g_person_resource_visible;
275: wms_plan_tasks_pvt.g_ship_method_visible := g_ship_method_visible;
276: wms_plan_tasks_pvt.g_ship_to_country_visible :=

Line 273: wms_plan_tasks_pvt.g_person_resource_visible :=

269: wms_plan_tasks_pvt.g_operation_sequence_visible := g_operation_sequence_visible;
270: wms_plan_tasks_pvt.g_op_plan_instance_id_visible :=
271: g_op_plan_instance_id_visible;
272: wms_plan_tasks_pvt.g_person_visible := g_person_visible;
273: wms_plan_tasks_pvt.g_person_resource_visible :=
274: g_person_resource_visible;
275: wms_plan_tasks_pvt.g_ship_method_visible := g_ship_method_visible;
276: wms_plan_tasks_pvt.g_ship_to_country_visible :=
277: g_ship_to_country_visible;

Line 275: wms_plan_tasks_pvt.g_ship_method_visible := g_ship_method_visible;

271: g_op_plan_instance_id_visible;
272: wms_plan_tasks_pvt.g_person_visible := g_person_visible;
273: wms_plan_tasks_pvt.g_person_resource_visible :=
274: g_person_resource_visible;
275: wms_plan_tasks_pvt.g_ship_method_visible := g_ship_method_visible;
276: wms_plan_tasks_pvt.g_ship_to_country_visible :=
277: g_ship_to_country_visible;
278: wms_plan_tasks_pvt.g_ship_to_postal_code_visible :=
279: g_ship_to_postal_code_visible;

Line 276: wms_plan_tasks_pvt.g_ship_to_country_visible :=

272: wms_plan_tasks_pvt.g_person_visible := g_person_visible;
273: wms_plan_tasks_pvt.g_person_resource_visible :=
274: g_person_resource_visible;
275: wms_plan_tasks_pvt.g_ship_method_visible := g_ship_method_visible;
276: wms_plan_tasks_pvt.g_ship_to_country_visible :=
277: g_ship_to_country_visible;
278: wms_plan_tasks_pvt.g_ship_to_postal_code_visible :=
279: g_ship_to_postal_code_visible;
280: wms_plan_tasks_pvt.g_ship_to_state_visible := g_ship_to_state_visible;

Line 278: wms_plan_tasks_pvt.g_ship_to_postal_code_visible :=

274: g_person_resource_visible;
275: wms_plan_tasks_pvt.g_ship_method_visible := g_ship_method_visible;
276: wms_plan_tasks_pvt.g_ship_to_country_visible :=
277: g_ship_to_country_visible;
278: wms_plan_tasks_pvt.g_ship_to_postal_code_visible :=
279: g_ship_to_postal_code_visible;
280: wms_plan_tasks_pvt.g_ship_to_state_visible := g_ship_to_state_visible;
281: wms_plan_tasks_pvt.g_source_header_visible := g_source_header_visible;
282: wms_plan_tasks_pvt.g_status_visible := g_status_visible;

Line 280: wms_plan_tasks_pvt.g_ship_to_state_visible := g_ship_to_state_visible;

276: wms_plan_tasks_pvt.g_ship_to_country_visible :=
277: g_ship_to_country_visible;
278: wms_plan_tasks_pvt.g_ship_to_postal_code_visible :=
279: g_ship_to_postal_code_visible;
280: wms_plan_tasks_pvt.g_ship_to_state_visible := g_ship_to_state_visible;
281: wms_plan_tasks_pvt.g_source_header_visible := g_source_header_visible;
282: wms_plan_tasks_pvt.g_status_visible := g_status_visible;
283: wms_plan_tasks_pvt.g_task_type_visible := g_task_type_visible;
284: wms_plan_tasks_pvt.g_to_locator_visible := g_to_locator_visible;

Line 281: wms_plan_tasks_pvt.g_source_header_visible := g_source_header_visible;

277: g_ship_to_country_visible;
278: wms_plan_tasks_pvt.g_ship_to_postal_code_visible :=
279: g_ship_to_postal_code_visible;
280: wms_plan_tasks_pvt.g_ship_to_state_visible := g_ship_to_state_visible;
281: wms_plan_tasks_pvt.g_source_header_visible := g_source_header_visible;
282: wms_plan_tasks_pvt.g_status_visible := g_status_visible;
283: wms_plan_tasks_pvt.g_task_type_visible := g_task_type_visible;
284: wms_plan_tasks_pvt.g_to_locator_visible := g_to_locator_visible;
285: wms_plan_tasks_pvt.g_to_lpn_visible := g_to_lpn_visible;

Line 282: wms_plan_tasks_pvt.g_status_visible := g_status_visible;

278: wms_plan_tasks_pvt.g_ship_to_postal_code_visible :=
279: g_ship_to_postal_code_visible;
280: wms_plan_tasks_pvt.g_ship_to_state_visible := g_ship_to_state_visible;
281: wms_plan_tasks_pvt.g_source_header_visible := g_source_header_visible;
282: wms_plan_tasks_pvt.g_status_visible := g_status_visible;
283: wms_plan_tasks_pvt.g_task_type_visible := g_task_type_visible;
284: wms_plan_tasks_pvt.g_to_locator_visible := g_to_locator_visible;
285: wms_plan_tasks_pvt.g_to_lpn_visible := g_to_lpn_visible;
286: wms_plan_tasks_pvt.g_to_organization_code_visible :=

Line 283: wms_plan_tasks_pvt.g_task_type_visible := g_task_type_visible;

279: g_ship_to_postal_code_visible;
280: wms_plan_tasks_pvt.g_ship_to_state_visible := g_ship_to_state_visible;
281: wms_plan_tasks_pvt.g_source_header_visible := g_source_header_visible;
282: wms_plan_tasks_pvt.g_status_visible := g_status_visible;
283: wms_plan_tasks_pvt.g_task_type_visible := g_task_type_visible;
284: wms_plan_tasks_pvt.g_to_locator_visible := g_to_locator_visible;
285: wms_plan_tasks_pvt.g_to_lpn_visible := g_to_lpn_visible;
286: wms_plan_tasks_pvt.g_to_organization_code_visible :=
287: g_to_organization_code_visible;

Line 284: wms_plan_tasks_pvt.g_to_locator_visible := g_to_locator_visible;

280: wms_plan_tasks_pvt.g_ship_to_state_visible := g_ship_to_state_visible;
281: wms_plan_tasks_pvt.g_source_header_visible := g_source_header_visible;
282: wms_plan_tasks_pvt.g_status_visible := g_status_visible;
283: wms_plan_tasks_pvt.g_task_type_visible := g_task_type_visible;
284: wms_plan_tasks_pvt.g_to_locator_visible := g_to_locator_visible;
285: wms_plan_tasks_pvt.g_to_lpn_visible := g_to_lpn_visible;
286: wms_plan_tasks_pvt.g_to_organization_code_visible :=
287: g_to_organization_code_visible;
288: wms_plan_tasks_pvt.g_txn_source_type_visible :=

Line 285: wms_plan_tasks_pvt.g_to_lpn_visible := g_to_lpn_visible;

281: wms_plan_tasks_pvt.g_source_header_visible := g_source_header_visible;
282: wms_plan_tasks_pvt.g_status_visible := g_status_visible;
283: wms_plan_tasks_pvt.g_task_type_visible := g_task_type_visible;
284: wms_plan_tasks_pvt.g_to_locator_visible := g_to_locator_visible;
285: wms_plan_tasks_pvt.g_to_lpn_visible := g_to_lpn_visible;
286: wms_plan_tasks_pvt.g_to_organization_code_visible :=
287: g_to_organization_code_visible;
288: wms_plan_tasks_pvt.g_txn_source_type_visible :=
289: g_txn_source_type_visible;

Line 286: wms_plan_tasks_pvt.g_to_organization_code_visible :=

282: wms_plan_tasks_pvt.g_status_visible := g_status_visible;
283: wms_plan_tasks_pvt.g_task_type_visible := g_task_type_visible;
284: wms_plan_tasks_pvt.g_to_locator_visible := g_to_locator_visible;
285: wms_plan_tasks_pvt.g_to_lpn_visible := g_to_lpn_visible;
286: wms_plan_tasks_pvt.g_to_organization_code_visible :=
287: g_to_organization_code_visible;
288: wms_plan_tasks_pvt.g_txn_source_type_visible :=
289: g_txn_source_type_visible;
290: wms_plan_tasks_pvt.g_user_task_type_visible := g_user_task_type_visible;

Line 288: wms_plan_tasks_pvt.g_txn_source_type_visible :=

284: wms_plan_tasks_pvt.g_to_locator_visible := g_to_locator_visible;
285: wms_plan_tasks_pvt.g_to_lpn_visible := g_to_lpn_visible;
286: wms_plan_tasks_pvt.g_to_organization_code_visible :=
287: g_to_organization_code_visible;
288: wms_plan_tasks_pvt.g_txn_source_type_visible :=
289: g_txn_source_type_visible;
290: wms_plan_tasks_pvt.g_user_task_type_visible := g_user_task_type_visible;
291: END;
292:

Line 290: wms_plan_tasks_pvt.g_user_task_type_visible := g_user_task_type_visible;

286: wms_plan_tasks_pvt.g_to_organization_code_visible :=
287: g_to_organization_code_visible;
288: wms_plan_tasks_pvt.g_txn_source_type_visible :=
289: g_txn_source_type_visible;
290: wms_plan_tasks_pvt.g_user_task_type_visible := g_user_task_type_visible;
291: END;
292:
293: PROCEDURE set_status_codes
294: IS

Line 940: IF NOT (wms_plan_tasks_pvt.g_include_inbound OR wms_plan_tasks_pvt.g_include_crossdock) THEN /* Bug 4047985 */

936: l_insert_generic := l_insert_generic || ', secondary_transaction_uom ';
937: l_insert_generic := l_insert_generic || ', secondary_transaction_quantity ';
938:
939: IF p_is_completed THEN --bug 4510849
940: IF NOT (wms_plan_tasks_pvt.g_include_inbound OR wms_plan_tasks_pvt.g_include_crossdock) THEN /* Bug 4047985 */
941: l_insert_generic := l_insert_generic || ', transaction_set_id ';
942: END IF; /* End of Bug 4047985 */
943: END IF;
944:

Line 1292: IF wms_plan_tasks_pvt.g_query_planned_tasks = TRUE

1288: --operation_plan
1289: END IF;
1290:
1291: --IF g_op_plan_instance_id_visible = 'T' THEN
1292: IF wms_plan_tasks_pvt.g_query_planned_tasks = TRUE
1293: THEN
1294: IF g_operation_sequence_visible = 'T' THEN
1295: l_select_generic := l_select_generic || 'wooi.operation_sequence, '; --operation_sequence
1296: END IF;

Line 1363: --ELSIF wms_plan_tasks_pvt.g_include_inbound

1359: --wdt_last_update_date
1360: l_select_generic := l_select_generic || 'wdt.last_updated_by, ';
1361: --wdt_last_updated_by
1362: -- Bug #3754781 -1 line, +1 line
1363: --ELSIF wms_plan_tasks_pvt.g_include_inbound
1364: ELSIF wms_plan_tasks_pvt.g_inbound_cycle
1365: THEN
1366: l_select_generic :=
1367: l_select_generic

Line 1364: ELSIF wms_plan_tasks_pvt.g_inbound_cycle

1360: l_select_generic := l_select_generic || 'wdt.last_updated_by, ';
1361: --wdt_last_updated_by
1362: -- Bug #3754781 -1 line, +1 line
1363: --ELSIF wms_plan_tasks_pvt.g_include_inbound
1364: ELSIF wms_plan_tasks_pvt.g_inbound_cycle
1365: THEN
1366: l_select_generic :=
1367: l_select_generic
1368: || 'to_number(null), ' /*task_id*/

Line 1649: IF wms_plan_tasks_pvt.g_query_planned_tasks = TRUE THEN

1645: --operation_plan
1646: END IF;
1647:
1648: IF g_operation_sequence_visible = 'T' THEN
1649: IF wms_plan_tasks_pvt.g_query_planned_tasks = TRUE THEN
1650: l_select_generic := l_select_generic || 'to_number(null), ';--operation_sequence
1651: ELSE
1652: l_select_generic := l_select_generic || 'to_number(null), ';--operation_sequence
1653: END IF;

Line 1710: IF NOT (wms_plan_tasks_pvt.g_include_inbound OR wms_plan_tasks_pvt.g_include_crossdock) THEN

1706: --wdt_last_updated_by
1707: l_select_generic := l_select_generic || '''N'', '; --is_modified
1708:
1709: -- bug #5163661
1710: IF NOT (wms_plan_tasks_pvt.g_include_inbound OR wms_plan_tasks_pvt.g_include_crossdock) THEN
1711: -- Bug #4141928
1712: l_select_generic := l_select_generic || 'mmt.secondary_uom_code, ';
1713: --sec_transaction_uom
1714: l_select_generic :=

Line 2007: IF NOT (wms_plan_tasks_pvt.g_include_inbound OR wms_plan_tasks_pvt.g_include_crossdock) THEN

2003: --wdt_last_updated_by
2004: l_select_generic := l_select_generic || '''N'', '; --is_modified
2005:
2006: -- bug #5163661
2007: IF NOT (wms_plan_tasks_pvt.g_include_inbound OR wms_plan_tasks_pvt.g_include_crossdock) THEN
2008: -- Bug #4141928
2009: l_select_generic := l_select_generic || 'wdth.secondary_transaction_uom_code, ';
2010: --sec_transaction_uom
2011: l_select_generic := l_select_generic || 'to_number(null), ';

Line 2196: IF NOT (wms_plan_tasks_pvt.g_include_inbound OR wms_plan_tasks_pvt.g_include_crossdock) THEN

2192: l_select_generic := l_select_generic || 'to_date(null), '; --wdt_last_update_date
2193: l_select_generic := l_select_generic || 'to_number(null), '; --wdt_last_updated_by
2194: -- END IF; --FEB4
2195: l_select_generic := l_select_generic || '''N'', '; --is_modified -- bug #5163661
2196: IF NOT (wms_plan_tasks_pvt.g_include_inbound OR wms_plan_tasks_pvt.g_include_crossdock) THEN
2197: -- Bug #4141928
2198: l_select_generic := l_select_generic || 'wdth.secondary_transaction_uom_code, '; --sec_transaction_uom
2199: l_select_generic := l_select_generic || 'wdth.SECONDARY_TRANSACTION_QUANTITY '; --sec_transaction_quantity
2200: -- l_select_generic := l_select_generic || 'mmt.transaction_set_id '; -- l_select_generic := l_select_generic || ' null '; /*last*/

Line 2239: IF wms_plan_tasks_pvt.g_query_planned_tasks = TRUE

2235: l_from_generic :=
2236: l_from_generic || 'mtl_material_transactions_temp mmtt ';
2237:
2238: --IF g_op_plan_instance_id_visible = 'T' AND
2239: IF wms_plan_tasks_pvt.g_query_planned_tasks = TRUE
2240: THEN
2241: l_from_generic :=
2242: l_from_generic || ', wms_op_operation_instances wooi';
2243: END IF;

Line 2261: /*IF g_operation_sequence_visible = 'T' AND wms_plan_tasks_pvt.g_query_planned_tasks = TRUE THEN

2257: END IF;
2258:
2259: l_from_generic :=
2260: l_from_generic || 'wms_dispatched_tasks_history wdth';
2261: /*IF g_operation_sequence_visible = 'T' AND wms_plan_tasks_pvt.g_query_planned_tasks = TRUE THEN
2262: l_from_generic :=
2263: l_from_generic || 'wms_op_opertn_instances_hist wooih';
2264: END IF; */
2265: --ER13869750 Starts

Line 2451: IF wms_plan_tasks_pvt.g_query_planned_tasks

2447: l_where_generic := 'WHERE 1=1 ';
2448: END IF;
2449:
2450: --IF g_op_plan_instance_id_visible = 'T' AND
2451: IF wms_plan_tasks_pvt.g_query_planned_tasks
2452: THEN
2453: l_where_generic :=
2454: l_where_generic
2455: || ' AND mmtt.transaction_temp_id = wooi.source_task_id (+) ';

Line 3054: IF wms_plan_tasks_pvt.g_from_inbound THEN

3050: * specific transactions. With ATF changes for Outbound and Warehousing we would
3051: * just need to remove the If condition.Hence leaving it in generic_where
3052: */
3053:
3054: IF wms_plan_tasks_pvt.g_from_inbound THEN
3055:
3056: /* -- commented for bug 12541291
3057: l_where_generic := l_where_generic ||
3058: ' AND mmt.transaction_set_id = nvl(wdth.source_document_id,wdth.transaction_id) '; */

Line 3066: wms_plan_tasks_pvt.g_from_inbound := FALSE;

3062: l_where_generic := l_where_generic || ' OR (wdth.source_document_id IS NULL AND mmt.transaction_set_id = wdth.transaction_id ))' ;
3063: l_where_generic := l_where_generic || ' AND mmt.organization_id = wdth.organization_id ';
3064: --added for bug 12541291 ends
3065:
3066: wms_plan_tasks_pvt.g_from_inbound := FALSE;
3067: ELSE
3068: l_where_generic :=
3069: l_where_generic
3070: || 'AND mmt.transaction_set_id = wdth.transaction_id ';

Line 6662: wms_plan_tasks_pvt.g_from_inbound :=TRUE;

6658: BEGIN
6659: /* Commented for --ER13869750 starts
6660: IF p_is_completed THEN
6661: --Bug 3627575:Setting the variable to true for Inbound queries
6662: wms_plan_tasks_pvt.g_from_inbound :=TRUE;
6663: l_loop_end := 2;
6664: ELSE
6665: l_loop_end := 1;
6666: END IF;

Line 6677: wms_plan_tasks_pvt.g_from_inbound :=TRUE;

6673: --Starts ER13869750
6674: IF p_is_picknone THEN
6675: l_loop_end := 3;
6676: ELSIF p_is_completed THEN
6677: wms_plan_tasks_pvt.g_from_inbound :=TRUE;
6678: l_loop_end := 2;
6679: ELSIF p_is_unreleased OR p_is_pending OR p_is_queued OR p_is_dispatched OR p_is_active OR p_is_loaded THEN
6680: l_loop_end := 1;
6681: END IF;

Line 9075: wms_plan_tasks_pvt.g_from_inbound :=TRUE;

9071: BEGIN
9072: /* Commented for ER13869750-Starts
9073: IF p_is_completed THEN
9074: --Bug 3627575:Setting the variable to true for Inbound queries
9075: wms_plan_tasks_pvt.g_from_inbound :=TRUE;
9076: l_loop_end := 2;
9077: ELSE
9078: l_loop_end := 1;
9079: END IF;

Line 9091: wms_plan_tasks_pvt.g_from_inbound :=TRUE;

9087: IF p_is_picknone THEN
9088: l_loop_end := 3;
9089: ELSIF p_is_completed THEN
9090: l_loop_end := 2;
9091: wms_plan_tasks_pvt.g_from_inbound :=TRUE;
9092: ELSIF p_is_unreleased OR p_is_pending OR p_is_queued OR p_is_dispatched OR p_is_active OR p_is_loaded THEN
9093: l_loop_end := 1;
9094: END IF;
9095: l_loop_start := NULL;

Line 9745: wms_plan_tasks_pvt.g_from_inbound :=TRUE;

9741: Commented for ER13869750 Ends*/
9742: IF p_is_picknone THEN
9743: l_loop_end := 3;
9744: ELSIF p_is_completed THEN
9745: wms_plan_tasks_pvt.g_from_inbound :=TRUE;
9746: l_loop_end := 2;
9747: ELSIF p_is_unreleased OR p_is_pending OR p_is_queued OR p_is_dispatched OR p_is_active OR p_is_loaded THEN
9748: l_loop_end := 1;
9749: END IF;

Line 10298: wms_plan_tasks_pvt.clear_globals ();

10294:
10295: -- Delete any existing records in the temp table
10296: IF NOT p_add
10297: THEN
10298: wms_plan_tasks_pvt.clear_globals ();
10299:
10300: DELETE FROM wms_waveplan_tasks_temp;
10301:
10302: g_record_count := 0;

Line 10347: wms_plan_tasks_pvt.set_globals

10343: g_wms_task_summary_tbl(i).task_count := 0;
10344: END LOOP;
10345: END IF;
10346:
10347: wms_plan_tasks_pvt.set_globals
10348: (p_organization_id => p_organization_id,
10349: p_subinventory_code => p_subinventory_code,
10350: p_locator_id => p_locator_id,
10351: p_to_subinventory_code => p_to_subinventory_code,

Line 10450: wms_plan_tasks_pvt.query_inbound_plan_tasks

10446:
10447: IF p_include_inbound OR p_include_crossdock
10448: THEN
10449: /* Patchset J - ATF: Call the new procedure
10450: wms_plan_tasks_pvt.query_inbound_plan_tasks
10451: */
10452: DEBUG ('calling wms_plan_tasks_pvt.query_inbound_plan_tasks',
10453: 'query_tasks'
10454: );

Line 10452: DEBUG ('calling wms_plan_tasks_pvt.query_inbound_plan_tasks',

10448: THEN
10449: /* Patchset J - ATF: Call the new procedure
10450: wms_plan_tasks_pvt.query_inbound_plan_tasks
10451: */
10452: DEBUG ('calling wms_plan_tasks_pvt.query_inbound_plan_tasks',
10453: 'query_tasks'
10454: );
10455: wms_plan_tasks_pvt.query_inbound_plan_tasks (x_return_status,p_summary_mode);
10456: g_record_count :=

Line 10455: wms_plan_tasks_pvt.query_inbound_plan_tasks (x_return_status,p_summary_mode);

10451: */
10452: DEBUG ('calling wms_plan_tasks_pvt.query_inbound_plan_tasks',
10453: 'query_tasks'
10454: );
10455: wms_plan_tasks_pvt.query_inbound_plan_tasks (x_return_status,p_summary_mode);
10456: g_record_count :=
10457: g_record_count + wms_plan_tasks_pvt.g_plans_tasks_record_count;
10458: END IF;
10459:

Line 10457: g_record_count + wms_plan_tasks_pvt.g_plans_tasks_record_count;

10453: 'query_tasks'
10454: );
10455: wms_plan_tasks_pvt.query_inbound_plan_tasks (x_return_status,p_summary_mode);
10456: g_record_count :=
10457: g_record_count + wms_plan_tasks_pvt.g_plans_tasks_record_count;
10458: END IF;
10459:
10460: IF p_include_outbound
10461: THEN