APPS.WMS_WAVE_PLANNING_PVT dependencies on BOM_STD_OP_RESOURCES

Line 1437: FROM bom_std_op_resources_v

1433: FROM dual
1434: WHERE x_labor_time_tbl(task)
1435: .standard_operation_id IN
1436: (SELECT standard_operation_id
1437: FROM bom_std_op_resources_v
1438: WHERE resource_code = x_labor_setup_tbl(setup)
1439: .resource_name);
1440: print_debug('resource3',l_debug);
1441: exception

Line 9032: bom_std_op_resources tt_x_res

9028: SELECT distinct res_equip.inventory_item_id
9029: FROM mtl_material_transactions_temp mmtt,
9030: bom_resource_equipments res_equip,
9031: bom_resources res,
9032: bom_std_op_resources tt_x_res
9033: WHERE mmtt.transaction_temp_id = p_task_id
9034: AND mmtt.standard_operation_id = tt_x_res.standard_operation_id
9035: AND tt_x_res.resource_id = res.resource_id
9036: AND res.resource_type = 1

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 14554: FROM bom_std_op_resources bsor,

14550: END IF;
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