DBA Data[Home] [Help]

APPS.INV_CYC_LOVS dependencies on WMS_DISPATCHED_TASKS_HISTORY

Line 9081: FROM wms_dispatched_tasks_history

9077:
9078: -- Get the employee ID first for the person that performed the task
9079: SELECT DISTINCT NVL ( person_id, -999 )
9080: INTO l_employee_id
9081: FROM wms_dispatched_tasks_history
9082: WHERE transaction_id = p_transaction_temp_id AND task_type = 3;
9083:
9084: IF ( l_debug = 1 ) THEN
9085: print_debug ( 'The employee ID is: ' || l_employee_id );

Line 9113: INSERT INTO WMS_DISPATCHED_TASKS_HISTORY

9109: IF ( l_debug = 1 ) THEN
9110: print_debug ( 'Inserting record into tasks history table' );
9111: END IF;
9112:
9113: INSERT INTO WMS_DISPATCHED_TASKS_HISTORY
9114: ( task_id,
9115: transaction_id,
9116: organization_id,
9117: user_task_type,