DBA Data[Home] [Help]

APPS.WMS_WAVE_PLANNING_PVT dependencies on BOM_RESOURCE_EMPLOYEES

Line 14515: FROM bom_std_op_resources bsor, bom_resource_employees bre

14511: SET RESULT = 'E', error = l_message
14512: WHERE RESULT = 'X'
14513: AND NOT EXISTS
14514: (SELECT 1
14515: FROM bom_std_op_resources bsor, bom_resource_employees bre
14516: WHERE wwtt.user_task_type_id = bsor.standard_operation_id
14517: AND bsor.resource_id = bre.resource_id
14518: AND bre.person_id = p_employee_id);
14519:

Line 14555: bom_resource_employees bre

14551:
14552: UPDATE wms_wp_tasks_gtmp wwtt
14553: SET person_resource_id = (SELECT bre.resource_id
14554: FROM bom_std_op_resources bsor,
14555: bom_resource_employees bre
14556: WHERE wwtt.user_task_type_id =
14557: bsor.standard_operation_id
14558: AND bsor.resource_id = bre.resource_id
14559: AND bre.person_id = wwtt.person_id