DBA Data[Home] [Help]

APPS.WMS_WAVEPLAN_TASKS_PVT dependencies on BOM_RESOURCE_EMPLOYEES

Line 11169: bom_resource_employees bre

11165: WHERE RESULT = 'X'
11166: AND NOT EXISTS (
11167: SELECT 1
11168: FROM bom_std_op_resources bsor,
11169: bom_resource_employees bre
11170: WHERE wwtt.user_task_type_id = bsor.standard_operation_id
11171: AND bsor.resource_id = bre.resource_id
11172: AND bre.person_id = p_employee_id);
11173:

Line 11218: FROM bom_std_op_resources bsor, bom_resource_employees bre

11214:
11215: UPDATE wms_waveplan_tasks_temp wwtt
11216: SET person_resource_id =
11217: (SELECT bre.resource_id
11218: FROM bom_std_op_resources bsor, bom_resource_employees bre
11219: WHERE wwtt.user_task_type_id = bsor.standard_operation_id
11220: AND bsor.resource_id = bre.resource_id
11221: AND bre.person_id = wwtt.person_id
11222: AND ROWNUM < 2)