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_OP_RUNTIME_PVT_APIS dependencies on WMS_DISPATCHED_TASKS_HISTORY

Line 1452: * This procedure archives the task records into WMS_DISPATCHED_TASKS_HISTORY

1448:
1449:
1450: /**
1451: *

Procedure:Archive_Dispatched_tasks
1452: * This procedure archives the task records into WMS_DISPATCHED_TASKS_HISTORY

1453: * @param p_task_id - Task Id of WMS_DISPATCHED_TASKS
1454: * @param p_source_task_id - Document Id for the Parent document record
1455: * @param p_activity_type_id - Activity Type Id
1456: * @param p_op_plan_instance_id - Operation Plan Id for the Parent Record

Line 1482: FROM wms_dispatched_tasks_history

1478: l_parent_txn_id NUMBER; --5523365
1479:
1480: CURSOR c_last_task IS
1481: SELECT dest_subinventory_code, dest_locator_id, drop_off_time, source_document_id
1482: FROM wms_dispatched_tasks_history
1483: WHERE parent_transaction_id = p_source_task_id
1484: ORDER BY task_id DESC;
1485:
1486: BEGIN

Line 1517: INSERT INTO WMS_DISPATCHED_TASKS_HISTORY

1513: l_progress:=30;
1514:
1515:
1516:
1517: INSERT INTO WMS_DISPATCHED_TASKS_HISTORY
1518: ( TASK_ID
1519: ,TRANSACTION_ID
1520: ,ORGANIZATION_ID
1521: ,USER_TASK_TYPE

Line 1714: INSERT INTO WMS_DISPATCHED_TASKS_HISTORY

1710: print_debug('l_parent_txn_id = '||l_parent_txn_id,l_module_name,9);
1711: print_debug('Inserting Records for Parent with source_task_id'||p_source_task_id,l_module_name,9);
1712: END IF;
1713:
1714: INSERT INTO WMS_DISPATCHED_TASKS_HISTORY
1715: ( TASK_ID
1716: ,TRANSACTION_ID
1717: ,ORGANIZATION_ID
1718: ,USER_TASK_TYPE