APPS.EAM_RES_VALIDATE_PVT dependencies on BOM_RESOURCES

Line 339: from bom_resources

335: if (p_eam_res_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then
336:
337: select 1
338: into g_dummy
339: from bom_resources
340: where organization_id = p_eam_res_rec.organization_id
341: and resource_id = p_eam_res_rec.resource_id;
342:
343: -- baroy - check whether the resource specified belongs to the department of the operation

Line 397: select 1 into g_dummy from bom_resources

393: from mtl_units_of_measure
394: where uom_code = p_eam_res_rec.uom_code;
395:
396: -- baroy - check whether the uom_code - resource association is correct.
397: select 1 into g_dummy from bom_resources
398: where organization_id = p_eam_res_rec.organization_id
399: and resource_id = p_eam_res_rec.resource_id
400: and unit_of_measure = p_eam_res_rec.uom_code;
401:

Line 700: from BOM_RESOURCES BR, MTL_UNITS_OF_MEASURE_VL UOM

696: l_hour_uom_class := WIP_OP_RESOURCES_UTILITIES.Get_Uom_Class(l_hour_uom);
697:
698: select UOM.uom_class
699: into l_uom_class
700: from BOM_RESOURCES BR, MTL_UNITS_OF_MEASURE_VL UOM
701: where BR.resource_id = p_eam_res_rec.resource_id
702: and BR.unit_of_measure = UOM.uom_code;
703:
704: IF l_hour_uom_class = l_uom_class THEN