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.INV_CYC_LOVS dependencies on WMS_DISPATCHED_TASKS

Line 395: FROM wms_dispatched_tasks

391: END IF;
392:
393: SELECT COUNT ( * )
394: INTO l_dispatched_count
395: FROM wms_dispatched_tasks
396: WHERE task_type = 3
397: AND organization_id = p_organization_id
398: AND transaction_temp_id = l_dispatched_task
399: AND person_id <> NVL ( g_employee_id, -999 );

Line 933: FROM mtl_cycle_count_entries mcce, wms_dispatched_tasks wdt

929:
930: CURSOR cc_entry_cursor
931: IS
932: SELECT cycle_count_entry_id
933: FROM mtl_cycle_count_entries mcce, wms_dispatched_tasks wdt
934: WHERE mcce.cycle_count_header_id = p_cycle_count_header_id
935: AND mcce.cycle_count_entry_id = wdt.transaction_temp_id
936: AND mcce.organization_id = p_organization_id
937: AND mcce.subinventory = p_subinventory

Line 974: -- for these entries if a record in wms_dispatched_tasks exists,

970: -- Initialize the message stack
971: FND_MSG_PUB.initialize;
972:
973: -- To fetch the cycle count entry ids which are in status 2,4,5.
974: -- for these entries if a record in wms_dispatched_tasks exists,
975: -- it has to be deleted
976:
977: OPEN cc_entry_cursor;
978: LOOP

Line 987: DELETE FROM wms_dispatched_tasks wdt

983: print_debug ( 'Approval Pending/ Rejected/ Completed cycle count entries found' );
984: print_debug( 'Cycle count Entry Id: ' || l_cycle_count_entry_id);
985: END IF;
986: BEGIN
987: DELETE FROM wms_dispatched_tasks wdt
988: WHERE wdt.transaction_temp_id = l_cycle_count_entry_id;
989: IF ( l_debug = 1 ) THEN
990: print_debug('** Deleted wms_dispatched_tasks record with transaction_temp_id : ' || l_cycle_count_entry_id);
991: END IF;

Line 990: print_debug('** Deleted wms_dispatched_tasks record with transaction_temp_id : ' || l_cycle_count_entry_id);

986: BEGIN
987: DELETE FROM wms_dispatched_tasks wdt
988: WHERE wdt.transaction_temp_id = l_cycle_count_entry_id;
989: IF ( l_debug = 1 ) THEN
990: print_debug('** Deleted wms_dispatched_tasks record with transaction_temp_id : ' || l_cycle_count_entry_id);
991: END IF;
992: EXCEPTION
993: WHEN OTHERS THEN
994: IF ( l_debug = 1 ) THEN

Line 995: print_debug('Deleting wms_dispatched_tasks record failed');

991: END IF;
992: EXCEPTION
993: WHEN OTHERS THEN
994: IF ( l_debug = 1 ) THEN
995: print_debug('Deleting wms_dispatched_tasks record failed');
996: END IF;
997: END;
998: ELSE
999: IF ( l_debug = 1 ) THEN

Line 1508: FROM wms_dispatched_tasks wdt

1504: print_debug ( 'Update the wms_picking_pkg.g_previous_task_status table.' );
1505: END IF;
1506: BEGIN
1507: SELECT transaction_temp_id into l_temp_cc_id
1508: FROM wms_dispatched_tasks wdt
1509: WHERE wdt.transaction_temp_id = g_cc_entry.cycle_count_entry_id;
1510:
1511: wms_picking_pkg.g_previous_task_status(g_cc_entry.cycle_count_entry_id) := 2; --WDT exists, so mark as QUEUED
1512: EXCEPTION

Line 5216: mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn, wms_dispatched_tasks wdt

5212:
5213: SELECT Count(DISTINCT msn.serial_number)
5214: INTO l_serial_count
5215: FROM mtl_serial_numbers_temp msnt, mtl_material_transactions_temp mmtt,
5216: mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn, wms_dispatched_tasks wdt
5217: WHERE mmtt.transaction_temp_id = mtlt.transaction_temp_id (+)
5218: AND ((msnt.transaction_temp_id = mmtt.transaction_temp_id and
5219: mtlt.lot_number is null) or
5220: (msnt.transaction_temp_id = mtlt.serial_transaction_temp_id

Line 9443: FROM wms_dispatched_tasks wdt

9439:
9440: CURSOR completed_tasks_cursor
9441: IS
9442: SELECT wdt.transaction_temp_id
9443: FROM wms_dispatched_tasks wdt
9444: WHERE wdt.person_id = l_employee_id
9445: AND wdt.task_type = 3
9446: AND NOT EXISTS (
9447: SELECT 'ACTIVE_TASK'

Line 9466: FROM wms_dispatched_tasks_history

9462:
9463: -- Get the employee ID first for the person that performed the task
9464: SELECT DISTINCT NVL ( person_id, -999 )
9465: INTO l_employee_id
9466: FROM wms_dispatched_tasks_history
9467: WHERE transaction_id = p_transaction_temp_id AND task_type = 3;
9468:
9469: IF ( l_debug = 1 ) THEN
9470: print_debug ( 'The employee ID is: ' || l_employee_id );

Line 9500: INSERT INTO WMS_DISPATCHED_TASKS_HISTORY

9496: END IF;
9497:
9498: BEGIN
9499:
9500: INSERT INTO WMS_DISPATCHED_TASKS_HISTORY
9501: ( task_id,
9502: transaction_id,
9503: organization_id,
9504: user_task_type,

Line 9580: FROM WMS_DISPATCHED_TASKS

9576: attribute15,
9577: task_type,
9578: priority,
9579: task_group_id
9580: FROM WMS_DISPATCHED_TASKS
9581: WHERE TRANSACTION_TEMP_ID = l_task_temp_id AND TASK_TYPE = 3;
9582:
9583: l_progress := '40';
9584:

Line 9591: DELETE FROM WMS_DISPATCHED_TASKS

9587: print_debug ( 'Deleting the record from the dispatched tasks table'
9588: );
9589: END IF;
9590:
9591: DELETE FROM WMS_DISPATCHED_TASKS
9592: WHERE TRANSACTION_TEMP_ID = l_task_temp_id AND TASK_TYPE = 3;
9593:
9594: EXCEPTION
9595: WHEN OTHERS THEN

Line 9597: print_debug ( 'Error while inserting into WMS_DISPATCHED_TASKS for l_task_temp_id: ' || l_task_temp_id );

9593:
9594: EXCEPTION
9595: WHEN OTHERS THEN
9596: IF ( l_debug = 1 ) THEN
9597: print_debug ( 'Error while inserting into WMS_DISPATCHED_TASKS for l_task_temp_id: ' || l_task_temp_id );
9598: END IF;
9599: END;
9600: END LOOP;
9601:

Line 9703: FROM wms_dispatched_tasks

9699:
9700: BEGIN
9701: SELECT 'Y'
9702: INTO l_temp_exists
9703: FROM wms_dispatched_tasks
9704: WHERE transaction_temp_id = l_cc_id
9705: AND status = 9;
9706: EXCEPTION
9707: WHEN NO_DATA_FOUND THEN

Line 9725: UPDATE wms_dispatched_tasks

9721: IF ( l_debug = 1 ) THEN
9722: print_debug ( 'Updating wdt with temp_id : '||p_task_id||' to '||l_cc_id );
9723: END IF;
9724:
9725: UPDATE wms_dispatched_tasks
9726: SET transaction_temp_id = l_cc_id
9727: WHERE transaction_temp_id = p_task_id;
9728:
9729: IF ( l_debug = 1 ) THEN

Line 9811: UPDATE wms_dispatched_tasks

9807: print_debug('l_prev_task_status = ' || l_prev_task_status || ' for p_transaction_temp_id: ' || p_transaction_temp_id);
9808:
9809: IF l_prev_task_status = 2 THEN --If prev task status was Queued
9810: print_debug('Updating the WDT ..' );
9811: UPDATE wms_dispatched_tasks
9812: SET status = l_prev_task_status
9813: ,last_update_date = SYSDATE
9814: ,last_updated_by = p_user_id
9815: WHERE person_id = p_employee_id

Line 9828: DELETE wms_dispatched_tasks

9824: l_progress := 200;
9825: print_debug('l_progress = ' || l_progress);
9826: ELSIF l_prev_task_status = 1 THEN --If prev task status was Pending
9827: print_debug('Deleting the WDT ..' );
9828: DELETE wms_dispatched_tasks
9829: WHERE person_id = p_employee_id
9830: AND task_type = 3
9831: AND (status IN (1,3,9 )) ;
9832:

Line 9988: FROM wms_dispatched_tasks t

9984: SELECT 1
9985: INTO l_wdt_rowcnt
9986: FROM dual
9987: WHERE exists (SELECT 1
9988: FROM wms_dispatched_tasks t
9989: WHERE t.transaction_temp_id = l_transaction_temp_id);
9990:
9991: wms_picking_pkg.g_previous_task_status(l_transaction_temp_id) := 2;
9992: EXCEPTION

Line 10011: INSERT INTO wms_dispatched_tasks

10007: AND NVL(eqp_id, -999) = NVL(p_sign_on_equipment_id, NVL(eqp_id, -999));
10008:
10009: IF l_wdt_rowcnt = 0 THEN
10010:
10011: INSERT INTO wms_dispatched_tasks
10012: (task_id,
10013: transaction_temp_id,
10014: organization_id,
10015: user_task_type,

Line 10035: (wms_dispatched_tasks_s.NEXTVAL,

10031: move_order_line_id,
10032: priority,
10033: task_method)
10034: VALUES
10035: (wms_dispatched_tasks_s.NEXTVAL,
10036: l_transaction_temp_id,
10037: p_organization_id,
10038: l_standard_operation_id,
10039: p_employee_id,

Line 10066: UPDATE wms_dispatched_tasks

10062:
10063: l_progress := 300;
10064: print_debug('Before updating WDT to Active || l_progress'||l_progress);
10065:
10066: UPDATE wms_dispatched_tasks
10067: SET status = 9, -- Active
10068: last_update_date = sysdate,
10069: last_updated_by = p_user_id
10070: WHERE transaction_temp_id = l_transaction_temp_id;