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 838: IF NOT (wms_plan_tasks_pvt.g_include_inbound OR wms_plan_tasks_pvt.g_include_crossdock) THEN /* Bug 4047985 */

834: l_insert_generic := l_insert_generic || ', secondary_transaction_uom ';
835: l_insert_generic := l_insert_generic || ', secondary_transaction_quantity ';
836:
837: IF p_is_completed THEN --bug 4510849
838: IF NOT (wms_plan_tasks_pvt.g_include_inbound OR wms_plan_tasks_pvt.g_include_crossdock) THEN /* Bug 4047985 */
839: l_insert_generic := l_insert_generic || ', transaction_set_id ';
840: END IF; /* End of Bug 4047985 */
841: END IF;
842:

Line 1185: IF wms_plan_tasks_pvt.g_query_planned_tasks = TRUE

1181: --operation_plan
1182: END IF;
1183:
1184: --IF g_op_plan_instance_id_visible = 'T' THEN
1185: IF wms_plan_tasks_pvt.g_query_planned_tasks = TRUE
1186: THEN
1187: IF g_operation_sequence_visible = 'T' THEN
1188: l_select_generic := l_select_generic || 'wooi.operation_sequence, '; --operation_sequence
1189: END IF;

Line 1256: --ELSIF wms_plan_tasks_pvt.g_include_inbound

1252: --wdt_last_update_date
1253: l_select_generic := l_select_generic || 'wdt.last_updated_by, ';
1254: --wdt_last_updated_by
1255: -- Bug #3754781 -1 line, +1 line
1256: --ELSIF wms_plan_tasks_pvt.g_include_inbound
1257: ELSIF wms_plan_tasks_pvt.g_inbound_cycle
1258: THEN
1259: l_select_generic :=
1260: l_select_generic

Line 1257: ELSIF wms_plan_tasks_pvt.g_inbound_cycle

1253: l_select_generic := l_select_generic || 'wdt.last_updated_by, ';
1254: --wdt_last_updated_by
1255: -- Bug #3754781 -1 line, +1 line
1256: --ELSIF wms_plan_tasks_pvt.g_include_inbound
1257: ELSIF wms_plan_tasks_pvt.g_inbound_cycle
1258: THEN
1259: l_select_generic :=
1260: l_select_generic
1261: || 'to_number(null), ' /*task_id*/

Line 1541: IF wms_plan_tasks_pvt.g_query_planned_tasks = TRUE THEN

1537: --operation_plan
1538: END IF;
1539:
1540: IF g_operation_sequence_visible = 'T' THEN
1541: IF wms_plan_tasks_pvt.g_query_planned_tasks = TRUE THEN
1542: l_select_generic := l_select_generic || 'to_number(null), ';--operation_sequence
1543: ELSE
1544: l_select_generic := l_select_generic || 'to_number(null), ';--operation_sequence
1545: END IF;

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

1598: --wdt_last_updated_by
1599: l_select_generic := l_select_generic || '''N'', '; --is_modified
1600:
1601: -- bug #5163661
1602: IF NOT (wms_plan_tasks_pvt.g_include_inbound OR wms_plan_tasks_pvt.g_include_crossdock) THEN
1603: -- Bug #4141928
1604: l_select_generic := l_select_generic || 'mmt.secondary_uom_code, ';
1605: --sec_transaction_uom
1606: l_select_generic :=

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

1895: --wdt_last_updated_by
1896: l_select_generic := l_select_generic || '''N'', '; --is_modified
1897:
1898: -- bug #5163661
1899: IF NOT (wms_plan_tasks_pvt.g_include_inbound OR wms_plan_tasks_pvt.g_include_crossdock) THEN
1900: -- Bug #4141928
1901: l_select_generic := l_select_generic || 'wdth.secondary_transaction_uom_code, ';
1902: --sec_transaction_uom
1903: l_select_generic := l_select_generic || 'to_number(null), ';

Line 1941: IF wms_plan_tasks_pvt.g_query_planned_tasks = TRUE

1937: l_from_generic :=
1938: l_from_generic || 'mtl_material_transactions_temp mmtt ';
1939:
1940: --IF g_op_plan_instance_id_visible = 'T' AND
1941: IF wms_plan_tasks_pvt.g_query_planned_tasks = TRUE
1942: THEN
1943: l_from_generic :=
1944: l_from_generic || ', wms_op_operation_instances wooi';
1945: END IF;

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

1959: END IF;
1960:
1961: l_from_generic :=
1962: l_from_generic || 'wms_dispatched_tasks_history wdth';
1963: /*IF g_operation_sequence_visible = 'T' AND wms_plan_tasks_pvt.g_query_planned_tasks = TRUE THEN
1964: l_from_generic :=
1965: l_from_generic || 'wms_op_opertn_instances_hist wooih';
1966: END IF; */
1967:

Line 2148: IF wms_plan_tasks_pvt.g_query_planned_tasks

2144: l_where_generic := 'WHERE 1=1 ';
2145: END IF;
2146:
2147: --IF g_op_plan_instance_id_visible = 'T' AND
2148: IF wms_plan_tasks_pvt.g_query_planned_tasks
2149: THEN
2150: l_where_generic :=
2151: l_where_generic
2152: || ' AND mmtt.transaction_temp_id = wooi.source_task_id (+) ';

Line 2728: IF wms_plan_tasks_pvt.g_from_inbound THEN

2724: * specific transactions. With ATF changes for Outbound and Warehousing we would
2725: * just need to remove the If condition.Hence leaving it in generic_where
2726: */
2727:
2728: IF wms_plan_tasks_pvt.g_from_inbound THEN
2729:
2730: l_where_generic := l_where_generic ||
2731: ' AND mmt.transaction_set_id = nvl(wdth.source_document_id,wdth.transaction_id) ';
2732: wms_plan_tasks_pvt.g_from_inbound := FALSE;

Line 2732: wms_plan_tasks_pvt.g_from_inbound := FALSE;

2728: IF wms_plan_tasks_pvt.g_from_inbound THEN
2729:
2730: l_where_generic := l_where_generic ||
2731: ' AND mmt.transaction_set_id = nvl(wdth.source_document_id,wdth.transaction_id) ';
2732: wms_plan_tasks_pvt.g_from_inbound := FALSE;
2733: ELSE
2734: l_where_generic :=
2735: l_where_generic
2736: || 'AND mmt.transaction_set_id = wdth.transaction_id ';

Line 5872: wms_plan_tasks_pvt.g_from_inbound :=TRUE;

5868: BEGIN
5869: IF p_is_completed THEN
5870:
5871: /*Bug 3627575:Setting the variable to true for Inbound queries*/
5872: wms_plan_tasks_pvt.g_from_inbound :=TRUE;
5873:
5874: l_loop_end := 2;
5875: ELSE
5876: l_loop_end := 1;

Line 8287: wms_plan_tasks_pvt.g_from_inbound :=TRUE;

8283: BEGIN
8284: IF p_is_completed THEN
8285:
8286: /*Bug 3627575:Setting the variable to true for Inbound queries*/
8287: wms_plan_tasks_pvt.g_from_inbound :=TRUE;
8288: l_loop_end := 2;
8289: ELSE
8290: l_loop_end := 1;
8291: END IF;

Line 9399: wms_plan_tasks_pvt.clear_globals ();

9395:
9396: -- Delete any existing records in the temp table
9397: IF NOT p_add
9398: THEN
9399: wms_plan_tasks_pvt.clear_globals ();
9400:
9401: DELETE FROM wms_waveplan_tasks_temp;
9402:
9403: g_record_count := 0;

Line 9448: wms_plan_tasks_pvt.set_globals

9444: g_wms_task_summary_tbl(i).task_count := 0;
9445: END LOOP;
9446: END IF;
9447:
9448: wms_plan_tasks_pvt.set_globals
9449: (p_organization_id => p_organization_id,
9450: p_subinventory_code => p_subinventory_code,
9451: p_locator_id => p_locator_id,
9452: p_to_subinventory_code => p_to_subinventory_code,

Line 9550: wms_plan_tasks_pvt.query_inbound_plan_tasks

9546:
9547: IF p_include_inbound OR p_include_crossdock
9548: THEN
9549: /* Patchset J - ATF: Call the new procedure
9550: wms_plan_tasks_pvt.query_inbound_plan_tasks
9551: */
9552: DEBUG ('calling wms_plan_tasks_pvt.query_inbound_plan_tasks',
9553: 'query_tasks'
9554: );

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

9548: THEN
9549: /* Patchset J - ATF: Call the new procedure
9550: wms_plan_tasks_pvt.query_inbound_plan_tasks
9551: */
9552: DEBUG ('calling wms_plan_tasks_pvt.query_inbound_plan_tasks',
9553: 'query_tasks'
9554: );
9555: wms_plan_tasks_pvt.query_inbound_plan_tasks (x_return_status,p_summary_mode);
9556: g_record_count :=

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

9551: */
9552: DEBUG ('calling wms_plan_tasks_pvt.query_inbound_plan_tasks',
9553: 'query_tasks'
9554: );
9555: wms_plan_tasks_pvt.query_inbound_plan_tasks (x_return_status,p_summary_mode);
9556: g_record_count :=
9557: g_record_count + wms_plan_tasks_pvt.g_plans_tasks_record_count;
9558: END IF;
9559:

Line 9557: g_record_count + wms_plan_tasks_pvt.g_plans_tasks_record_count;

9553: 'query_tasks'
9554: );
9555: wms_plan_tasks_pvt.query_inbound_plan_tasks (x_return_status,p_summary_mode);
9556: g_record_count :=
9557: g_record_count + wms_plan_tasks_pvt.g_plans_tasks_record_count;
9558: END IF;
9559:
9560: IF p_include_outbound
9561: THEN