APPS.EAM_RES_USAGE_VALIDATE_PVT dependencies on BOM_RESOURCE_EQUIPMENTS

Line 144: from bom_resource_equipments

140: if (p_eam_res_usage_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE) then
141:
142: select count(*)
143: into g_dummy
144: from bom_resource_equipments
145: where instance_id = p_eam_res_usage_rec.instance_id
146: and organization_id = p_eam_res_usage_rec.organization_id;
147:
148: end if;

Line 186: from mtl_serial_numbers msn, bom_resource_equipments bre

182: if (p_eam_res_usage_rec.serial_number is not NULL) then
183:
184: select count(*)
185: into g_dummy
186: from mtl_serial_numbers msn, bom_resource_equipments bre
187: where msn.inventory_item_id = bre.inventory_item_id
188: and msn.current_organization_id = bre.organization_id
189: and bre.instance_id = p_eam_res_usage_rec.instance_id
190: and msn.serial_number = p_eam_res_usage_rec.serial_number;