DBA Data[Home] [Help]

APPS.WMS_WAVEPLAN_TASKS_PVT dependencies on BOM_RESOURCE_EMPLOYEES

Line 10164: bom_resource_employees bre

10160: WHERE RESULT = 'X'
10161: AND NOT EXISTS (
10162: SELECT 1
10163: FROM bom_std_op_resources bsor,
10164: bom_resource_employees bre
10165: WHERE wwtt.user_task_type_id = bsor.standard_operation_id
10166: AND bsor.resource_id = bre.resource_id
10167: AND bre.person_id = p_employee_id);
10168:

Line 10213: FROM bom_std_op_resources bsor, bom_resource_employees bre

10209:
10210: UPDATE wms_waveplan_tasks_temp wwtt
10211: SET person_resource_id =
10212: (SELECT bre.resource_id
10213: FROM bom_std_op_resources bsor, bom_resource_employees bre
10214: WHERE wwtt.user_task_type_id = bsor.standard_operation_id
10215: AND bsor.resource_id = bre.resource_id
10216: AND bre.person_id = wwtt.person_id
10217: AND ROWNUM < 2)